>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.