>Hi,
>
>I am using CursorAdapter method of updating base table in SQL Server from VFP application. One of the columns is identity column. Typically user has not access to this column so when the base table in SQL is updated, there is no problem. But I have a process that can enter a value into the Identity column (usually 0) of the CursorAdapter. In this case, before I call TABLEUPDATE() I would like to "disable" cursor adapter from trying to set the value in the base table. Otherwise, there is an error. Is there a method/approach of programmatically "instruct" CursorAdapter not to try updating the Identity column?
>
>TIA.
You have to remove this column from UpdatableNameList property.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.