The thing is though, that I'm pretty sure TableUpdate() will return .T. even when there are no changes to update as long as it doesn't run into a problem. I think it will return .F. only if it
cannot update the table for whatever reason.
Are you issuing GetFldSate() with the -1 argument?
Alan
>>Claude, look up GetFldState() in the help. It can tell you if a record has been deleted before you do the TableUpdate()
>
>Thamls for suggestion but it does not seem to work.
>
>I always get a value of 1. This may be because table is using optomistic buffering.
>
>I have no problem doing a rollback if tableupdate fails as long as I know that is a depentable way of determing if delete flag is really not set.
>
>>
>>Alan
>>
>>>I have code like
>>>
>>>DELETE NEXT 1 FOR pireq.creqno = lcReqNo IN pireq
>>>
>>>where table pireq is on a server.
>>>
>>>Can I use the TABLEUPDATE command to check if delete was successful? I so can I use the sysntax
>>>
>>>llTableUpdatepi = TABLEUPDATE(.T.,.F.,'pireq')
>>>
>>>If not what can I do?