General information
Category:
Coding, syntax & commands
Title:
Why doesn't this DELETE ALL WHILE work?
The following code does not delete from the DRAW table the records where draw.obligor == m.obligor .AND. draw.obligation == m.obligation .AND. draw.unit == m.unit. After the SEEK the record pointer is correctly on the first matching record. Then after the DELETE ALL WHILE is executed the record pointer is at the first record of the index and the matching records are not deleted.
IF SEEK( m.obligor+m.obligation+m.unit, "DRAW", "obr_obn_un")
SELECT draw
DELETE ALL WHILE draw.obligor == m.obligor .AND. ;
draw.obligation == m.obligation .AND. ;
draw.unit == m.unit
ENDIF
Thanks
Brenda
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only