>sorry i forget to say that is a cursor adapter

A wonderfull toy is SQL Sever isn't it :o))))
CursorAdapter:
Make sure you have set these properties:
UpdatableNameList
UpdateFieldList
SendUpdates
AllowUpdate
AllowInsert
AllowDelete
WhereType
KeyFieldList
Tables

If you set them to the right values, after you made some changes (Insert record, Delete it or just change some values) Issue
TableUpdate(1,.t.,[CA Alias here])
And don't forget to check for errors:

IF NOT TableUpdate(1,.t.,[CA Alias here])
   AERROR(lAerror)
   MessageBox([Can not update table "+lAerror[1,2])
ENDIF