How to erase records in datatrieve

[panneer]

I have two files A and B .there is no common field for both.date(field in A) and day(field in B).
Ready A
Ready B
find all a cross b with date < day
find all current with status="OK"
Erase all

Since erase all wont work ....i have tried this in a for loop
for first in A
erase all B with date < first.day

The above code will erase all the records .But i need to delete records based on the status="OK".

so how to combine Ready A
Ready B
find all a cross b with date < day
find all current with status="OK"
Erase all
into a for loop or is ter any other means of converting this so tat i can delete only the required records.

[Leif R. Jansson]

Hi

Try:

for first in A
erase all B with date < first.day and status="OK"

/Regards
Leif J