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