>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?