>>Dan, I haven't tried this, but you could load 2 copies of the table in question. The first is used for editing. When you wish to check the delete status, USE MyTable AGAIN... and check the record in question with DELETED(). Slow, but accurate as of the time you do the USE...AGAIN command.
>>
>>Interesting problem...
>>
>>Barbara
>
>My curiosity was aroused.....
>I added two buttons to an existing form one to check GETFLDSTATE the other DELETED(), ran two sessions of this form, navigated to the same record on both and deleted the record with one of them.
>When the buttons were clicked on the other form deletion status was 1 (unchanged) and was not marked for deletion (returned .f.)
>I think this confirms what Dan has been saying. (BTW buffermode=2, datasession=1)
Dan, GetFldState(-1) will only check if the Delete status was changed on your machine, true. However, I think you'll get the right results checking Deleted() if you re-use your data before checking. Remember that the form is checking what's in memory, not what's been changed on the server. That's why I suggested that Dan fire off a "USE AGAIN" at the moment he wanted to check the data.
Barbara