Is there a CAR EXAMPLE where I have two query's, one has the main data I would pull fields from, the other query would have to run seperately for each row from the 1st query's results. I think this is some sort of REPEAT or LOOP. In any case, I need to create a new HOLD file based off of the results of the loop above I am talking about. Can anyone point me in the right direction, I would be most appreciative!!!

Happy weekend all!

neuro,
i'll take a shot:
-SET &RECORD = '';
TABLE FILE CAR
PRINT SALES BY COUNTRY BY CAR
ON TABLE HOLD AS MYFILE FORMAT ALPHA
END
-RUN
-top.loop
-READ MYFILE NOCLOSE &RECORD.A32
-IF &IORETURN NE 0 GOTO end.loop;
-SET &COUNTRY=EDIT(&RECORD,'9999999999');
-SET &CAR=SUBSTR(32,&RECORD,11,26,16,'A16');
-SET &SALES=SUBSTR(32,&RECORD,27,32,6,'A6');
EXEC SOMEFEX COUNTRY=&COUNTRY , CAR=&CAR , SALES=&SALES
-RUN
-GOTO top.loop ;
-* or whatever you need to do
-end.loop

note: most other focus installations on theplanet can do their -READ statment like this
-READ MYFILE NOCLOSE &COUNTRY.A10. &CAR.A16. &SALES.A6.
but for some reason my site won't work that way
so i have to read the whole record and parse it.
no big deal.
note: whats &IORETURN? a system var that tells you when you've hit the end of file. 0 is record ok, non-zero is end of file.
note: why do i HOLD FORMAT ALPHA rather than SAVE? because i want to eyeball at the master i create in order to make absolutely sure i know how big the fields are before i begin a -READ
How do i do that?
TABLE FILE CAR
..do stuff
ON TABLE HOLD AS MYFILE FORMAT ALPHA
END
CHECK FILE MYFILE HOLD
TABLE FILE HOLD PRINT *
END
..i do this one time, in development , just to look at the field sizes, then erase this CHECK code. I could then change HOLD to SAVE, but i just dont..
Any help?

This message has been edited. Last edited by: susannah,

Am I supposed to enter something in for the parameter when I click run?

Thanks for the quick feedback, I would have tested over the weekend if I had the time.

Thanks

NM, my fault however, my response is this:


0 NUMBER OF RECORDS IN TABLE= 18 LINES= 18
(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: SOMEFEX
(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: SOMEFEX
(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: SOMEFEX
(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: SOMEFEX
(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: SOMEFEX
(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: SOMEFEX
(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: SOMEFEX
(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: SOMEFEX
(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: SOMEFEX
(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: SOMEFEX
(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: SOMEFEX
(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: SOMEFEX
(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: SOMEFEX
(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: SOMEFEX
(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: SOMEFEX
(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: SOMEFEX
(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: SOMEFEX
(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: SOMEFEX