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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement