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