Focal Point
how to get return values ?

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7031028331

January 03, 2005, 10:07 AM
Motiejus
how to get return values ?
lets say we have something like this:

TABLE FILE my_table
SUM
COMPUTE
MY_VALUE/I11 = VAL1+VAL2;
ON TABLE HOLD AS MY_HOLD
END

how should I access computed values?
For instance, I want to write something like this:

IF MY_HOLD.MY_VALUE(0) EQ '0' THEN GOTO Somethere;

or

-SET &MY_NEXT_FEX = MY_HOLD.MY_VALUE(3);
TABLE FILE &MY_NEXT_FEX
PRINT *
END


Thanks,
January 03, 2005, 03:00 PM
reFOCUSing
Hope this will help.

SET HOLDLIST = PRINTONLY
TABLE FILE CAR
SUM
COMPUTE COST/I11 = RETAIL_COST + DEALER_COST;
ON TABLE HOLD AS H0 FORMAT ALPHA
END
-RUN
-READ H0 &COST.I11
-TYPE &COST

-IF &COST EQ 0 THEN GOTO :SKIP1 ;
-EXIT

-:SKIP1
-TYPE At Skip1
-EXIT
January 10, 2005, 04:41 AM
Motiejus
I got an ansaver from Information Builders Customer Support(Wen Gouw, dutch office).

Technique for reading an unknown number of records and setting some variables:

TABLE FILE CAR
PRINT COUNTRY
ON TABLE HOLD AS WW
END
-RUN
-SET &N=0;
-*
-:AGAIN
-SET &N=&N+1;
-READ WW &CO.&N.A10
-IF &IORETURN EQ 0 THEN GOTO :AGAIN;
-*
-SET &N=&N-1;
-? &


Thanks to CurtisA and Wen Gouw!