Hi Lorne,

Here's the story. I do an SQLEXEC(nhandle, mystatement, mycursor) to get the table info into a cursor. I then set the cursor properties. ( TABLES, UPDATENAMELIST, KEYFIELDLIST, UPDATABLEFIELDLIST, SENDUPDATES). I then make changes to 1 or more of the records in the cursor. Or even delete 1 or more of the records. Sometimes at the same time. Then I do the TABLEUPDATE(.T.). The changes seem to have taken effect. If I ask for the same info, the deleted records don't show up. Are the deleted records just sitting there marked for deletion? MUST I do a SQLCOMMIT(nhandle) in order for them to be sent to oblivian? Please elaborate.

TIA
Mike