Does anyone know if you can use more than 7 RECAP statements in one focexec?
I get an error telling me I've exceeded the maximum number if I use more than this. Is there a way to increase this number or to turn off the flag completely?
December 04, 2003, 06:56 PM
Mikel
I think it isn't possible to avoid this limit. But, with FOCUS, we always have alternatives.
In this case, probably you can use a multiverb query with the appropriate COMPUTEs.
Example. (FOC107) with 8 RECAPS.
-* PROBLEM (FOC107). TABLE FILE CAR SUM SALES BY COUNTRY BY CAR ON COUNTRY SUBTOTAL RECAP SAL1/D15.2 = SALES + 1 ; RECAP SAL2/D15.2 = SALES + 2 ; RECAP SAL3/D15.2 = SALES + 3 ; RECAP SAL4/D15.2 = SALES + 4 ; RECAP SAL5/D15.2 = SALES + 5 ; RECAP SAL6/D15.2 = SALES + 6 ; RECAP SAL7/D15.2 = SALES + 7 ; RECAP SAL8/D15.2 = SALES + 8 ; END -RUN
0 ERROR AT OR NEAR LINE 25 IN PROCEDURE (FOC107) THE NUMBER OF RECAP FIELDS EXCEEDS 7 (FOC009) INCOMPLETE REQUEST STATEMENT BYPASSING TO END OF COMMAND[/code]Example. POSSIBLE WORKAROUND using multiverb.
The word RECAP may not be specified more than seven times. However, more than seven RECAP calculations are permitted. Use the following syntax: ON fieldname RECAP field1/format= ... ; field2/format= ... ; . .
Previous example using RECAP keyword only one time. TABLE FILE CAR SUM SALES BY COUNTRY BY CAR ON COUNTRY SUBTOTAL RECAP SAL1/D15.2 = SALES + 1 ; SAL2/D15.2 = SALES + 2 ; SAL3/D15.2 = SALES + 3 ; SAL4/D15.2 = SALES + 4 ; SAL5/D15.2 = SALES + 5 ; SAL6/D15.2 = SALES + 6 ; SAL7/D15.2 = SALES + 7 ; SAL8/D15.2 = SALES + 8 ; END -RUN Regards, MikelThis message has been edited. Last edited by: <Mabel>,