QTIPS - Guaranteed Variable Assignment
The system function UNASSIGNED (Vol 1 Issue 1) is most often used within a program to trap and assign to null, unassigned variables e.g.
0001 DECLARE FUNCTION UNASSIGNED
0002 IF UNASSIGNED(X) THEN X= ""
0002 IF UNASSIGNED(X) THEN X= ""
A new system function GUAR_ASSIGN can be used to take the place of the above code. Passed a variable, it returns the value of the variable if it is assigned. or null if it is unassigned. i.e.
0001 DECLARE FUNCTION GUAR_ASSIGN
0002 X = GUAR_ASSIGN(X)
0002 X = GUAR_ASSIGN(X)
(Volume 2, Issue 10, Page 3)
| Making Databases Happen |
UK +44 (0) 20 8912 1010 USA +1 267 238 3814 |