January 03, 2005, 10:07 AM
Motiejushow 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
reFOCUSingHope 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
MotiejusI 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!