What I did is is (from the command window)
1. open the table with the browse command.
2. issue the command ? GetFldState(0,'pireq') (also tried it with ? GetFldState(-1,'pireq'))
3. mark the current field as deleted
4. reissued the command ? GetFldState(0,'pireq') (also tried it with ? GetFldState(-1,'pireq'))
First version always returns 1 and second version always returns 111111111.
>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?