IF FIELD EQ (HOLD_FILE)

[LeonelSanchezJr]

I need to create a HOLD file with DRIVER_NUMBERS.
Then, I need to query a second table based on the DRIVER_NUMBERS that exist in the previous HOLD file.

I think the logic is like this.

TABLE FILE CAR
PRINT
CAR
WHERE CAR EQ 'BMW';
ON TABLE HOLD AS DRIVER FORMAT FOCUS

TABLE FILE MY_CARS
PRINT
CAR2
WHERE CAR2 EQ (DRIVER);
END

But I am not sure of the logic syntax...

Thanks,

Leo ;-)

 

[focwizard]

Reading values from an external file requires the file to be SEQUENTIAL. Take out the FORMAT FOCUS when you HOLD the file, and it'll do what you want.

 

[focwizard]

Sorry, just re-read you original message.

To use the syntax 'EQ (ddname)', you use an IF test:

IF fieldname EQ (ddname)

to use a WHERE test, the syntax is:

WHERE fieldname IN FILE ddname