>Hi,
>
>I want to delete a record in a cursor created with a CursorAdapter record but not the record in the base table (in SQL Server)? How do you do it? TIA.
If you give us the reason why, maybe it will be easier to us.
You could delete the record and than make something like this:
DELETE
thisCA.SendUpdates = .f.
TABLEUPDATE(......)
thisCA.SendUpdates = .t.
Make INSTEAD OF DELETE Trigger in SQL Server.
It depends what you want to do.
Why you want to delete the records in the Frontend but not in BackEnd?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.