This.InsertCmdRefreshCmd = "select " + This.InsertCmdRefreshKeyFieldList + " from " + This.Tables + " where " + This.InsertCmdRefreshKeyFieldList + " = GetAutoIncValue() "Sarosh
>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 :-)