Using SynchronizationRecord how to find column ordinal?

MarkLFT

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

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