I am using the following code to update a field to auto incrementing. How can I test to see if the field has already been changed so the following code doesn't get continually run?
USE Customer IN 0 EXCLUSIVE
SELECT Customer
CALCULATE MAX(CustId) TO lnNextValue
ALTER TABLE Customer ALTER COLUMN CustId I AUTOINC NEXTVALUE lnNextValue + 1
Thanks
John