Using SynchronizationRecord how to find column ordinal?

MarkLFT · Joined: 22 Apr 2011 Posts: 10 Location: Bali, Indonesia

I want to compare two tables and usinf SyncronisationRecord, only update the tables where the values of a specific column are different. I can use the row.FieldDifferent, but for this I need the ordinal of the column. I don't like to use a number, as they have a habit of changing. Better to use the column name, less likely to change. Is there anyway to find what is the ordinal number of a column by it's name?

Thanks

peter.peart · Posted: Mon Apr 25, 2011 2:43 pm Post subject:

Hi there,

The example on the below page details how to get comparison results including column names:

http://sdk.red-gate.com/index.php/StoreExample

With that in mind, once you have the column names you should then be able to sync based on them.

HTH!

Pete
_________________
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569

	All times are GMT + 1 Hour
Page 1 of 1