What are the challenges you face when working across database platforms? Take the survey
Options

Using SynchronizationRecord how to find column ordinal?

MarkLFTMarkLFT Posts: 15
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

Comments

Sign In or Register to comment.