Claude, I'm not sure what to tell you. I just tried it. First I did it in code on a form, and when did MessageBox(GetFldState(-1)), it returned "111111111". I deleted the current record and did the messagebox again, and got "211111111".
Then I tried it with a browse, and again it worked properly. When you did the browse from the command window, did you check the table properties to make sure you had buffering on? I think when you open a table from the command window, it automatically defaults to non-buffered.
Alan
>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?