Hi!

Just change the = " = GetAutoInc() " to " = @@IDENTITY"

Sarosh


>Thank you Sarosh,
>Unfortunately this CA must works with 2 DB (users choice) SQL Server or Native VFP DB.
>
>>Hi!
>>
>>Try this in your CA's Init.
>>
>>

>>This.InsertCmdRefreshCmd = "select " + This.InsertCmdRefreshKeyFieldList + " from " + This.Tables + " where " + This.InsertCmdRefreshKeyFieldList + " = GetAutoIncValue() "
>>

>>
>>Sarosh
>>
>>>Am I missing something?
>>>I have a table with AutoInc field in it setted as Key field in my CA. I waht after I insert record in that Cursor that firld to be refresed automaticly. So I set :
>>>
>>>

>>>this.InsertCmdRefreshKeyFieldList = [Id] && Name of the field
>>>this.InsertCmdRefreshCmd          = []   && Empty string
>>>                                         && according to HELP - The CA object generates the refresh command automatically.
>>>
>>>** Cursor has Table buffering. Now after I insert a record in CA
>>>IF NOT TableUpdate(1, .t., [MyTable])
>>>  ** Error handling here
>>>ENDIF
>>>

>>>Also with SQL Profiler I didn't see any command relative to some refresh :-)
>>>
>>>BUT the field ID is always empty. Am I missing something (I am sure I am but what)?
>>>TIA