Time Intrinsic Functions - AsValue Method

Return the variable as a value if SQLNull

Member of Time Intrinsic Functions (PRIM_LIBI.ITimeIntrinsics)


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


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.


Rather than having to test as below
If ((#Variable = "00:00:00") *or (#Variable.IsSqlNull)
AsValue allows the following
If (#Variable.AsValue(00:00:00))

See also

All Component Classes

Technical Reference

LANSA Version 15, April 2020