I have a problem deleting records during a Begin and End Transaction.
Basically this is what is happening:
If User1 is viewing a record in MYTABLE at the same time that User2 runs a
procedure to delete a batch of records from MYTABLE then all the records get
deleted except for the one that User1 was looking at. I have tried
including the following code, but it makes no difference!
IF EXP1 = EXPR2
DO WHILE !RLOCK("mytable")
DELETE IN mytable
UNLOCK IN mytable
Could someone please tell me where I am going wrong?
Many thanks - Debbie