|
 |
access thread: Differentiating Normal & Replication Fields Using ADO
Message #1 by "nnnhack" <nnnhack@y...> on Tue, 21 Aug 2001 23:07:44 -0400
|
|
Hello... Was wondering if anyone could help me with this one...
I'm using VB ADO, and recently set up replication for my access database.
I know there's probably an easier way to do this, but I created a procedure
to
get the list of fields in a table - into an array... (I'm currently using
the
ADO Schema "adSchemaColumns"...) Now it seems to be getting
all of the row-level replication data... (s_ColLineage, s_Generation,
s_Guid, s_Lineage)...
I know this is sort-of an ADO question vs Access, but if anyone has any
input as to
how I could differentiate between normal columns, and these s_ (replication)
columns,
I would greatly appreciate the help!
Many Thanks...
Respectfully,
Doug Weir
Message #2 by "Pardee, Roy E" <roy.e.pardee@l...> on Thu, 23 Aug 2001 07:34:48 -0700
|
|
Well, you could always hard-code the rep field names (I believe there's a
whitepaper that lists all the tables & fields that replication adds to a db)
and have your code ignore or delete the corresponding recs, but you probably
already knew that.
If you're not married to doing .OpenSchema, you may be able to do something
more cumbersome w/a small recordset defined against the table--there may be
some member of the .Properties() collection of a rep field that will set it
apart from a user-defined field.
HTH,
-Roy
-----Original Message-----
From: nnnhack [mailto:nnnhack@y...]
Sent: Tuesday, August 21, 2001 8:08 PM
To: Access
Subject: [access] Differentiating Normal & Replication Fields Using ADO
Hello... Was wondering if anyone could help me with this one...
I'm using VB ADO, and recently set up replication for my access database.
I know there's probably an easier way to do this, but I created a procedure
to
get the list of fields in a table - into an array... (I'm currently using
the
ADO Schema "adSchemaColumns"...) Now it seems to be getting
all of the row-level replication data... (s_ColLineage, s_Generation,
s_Guid, s_Lineage)...
I know this is sort-of an ADO question vs Access, but if anyone has any
input as to
how I could differentiate between normal columns, and these s_ (replication)
columns,
I would greatly appreciate the help!
Many Thanks...
Respectfully,
Doug Weir
|
|
|
View Cart
