Mlarocca: Mlarocca moved page $DECODE to $Decode: Lower case change

2014-07-17T13:13:27Z

Mlarocca moved page $DECODE to $Decode: Lower case change

← Older revision	Revision as of 13:13, 17 July 2014
(No difference)

Alex: Automatically generated page update

2013-04-20T13:18:50Z

Automatically generated page update

New page

The $DECODE function performs a table lookup and returns a decoded character string value. $DECODE is useful for printing descriptive information on reports when the records themselves contain only coded values. 
$DECODE conserves space and minimizes the keystrokes required for requests by retaining only codes for fields. $DECODE takes two arguments:
$DECODE('table_name',resolve)

where
<ul>
<li>table_name is the name of a table.</li>
</li>
<li>resolve contains the code that is to be decoded.</li>
</li>
</ul>
Example
The state field contains a 2-character code. Full state names are printed.
BEGIN
STATE: FOR EACH VALUE OF STATE IN ORDER
STATE.VAL: FIND ALL RECORDS FOR WHICH
STATE = VALUE IN STATE
END FIND
NO.IN.EACH: COUNT RECORDS IN STATE.VAL
SKIP 1 LINE
PRINT $DECODE ('STATE', VALUE IN STATE) -
WITH COUNT IN NO.IN.EACH AT COLUMN 30
END FOR
END

[[Category:SOUL $functions]]

$Decode - Revision history

Mlarocca: Mlarocca moved page $DECODE to $Decode: Lower case change

Alex: Automatically generated page update