deleted records 3

[RGoldthorpe]

What is the code I need to use to tell if a record is flagged for deletion.

All help gratefully received

ThanX

Rach X-)

 

[ramani]

HI Rachel,

To delete DELETE
To recall it, RECALL
To permanently remove the deleted records... PACK..but this command can be used only in an exclusive mode..
SO

myStatus=SET("EXCLUSIVE&quot
SET EXCLUSIVE ON
USE myTable
PACK
SET EXCLUSIVE TO &myStatus

You may have to add code to catch other users, who might be already in. (Beware !)

Hope this helps you. ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com
LET KNOW IF THIS HELPED. ENOUGH EXPERTS ARE HERE TO HELP YOU OUT! BEST OF LUCK

 

[RGoldthorpe]

Thanks Ramani

 

[CatalinC]

You can use deleted() function :

use yourdatabase
scan
if deleted()
wait window 'Record flagged for delete! '+str(recno(),5) timeout 1
endif
endscan
use