Fixed Character Intrinsic Functions - AsValue Method

Return the variable as a value if SQLNull

Member of Fixed Character Intrinsic Functions (PRIM_LIBI.IFixedCharIntrinsics)

Parameters

Name	Type	Data Type	Description
Result	*Result (Optional)	String	Resulting value
Default	*Input (Optional)	String	Value to use when the variable is SQLNull

Details

AsValue allows you to better handle *SQLNull. Rather than having to test for a potential SQLnull, AsValue allows a variable to return a specified value.

Example

Rather than having to test as below

If ((#Variable = Xxxx) *or (#Variable.IsSqlNull)
...

AsValue allows the following

If (#Variable.AsValue(Xxxx))
...

See also

All Component Classes

Technical Reference

LANSA Version 15, April 2020