Floating Point Intrinsic Functions - AsValue Method

Return the variable as a value if SQLNull

Member of Floating Point Intrinsic Functions (PRIM_LIBI.IFloatingPointIntrinsics)

Parameters

NameTypeData TypeDescription
Result*Result (Optional)FloatResulting value
Default*Input (Optional)FloatValue 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 = 123) *or (#Variable.IsSqlNull)
...
AsValue allows the following
If (#Variable.AsValue(123))
...

See also

All Component Classes

Technical Reference

Febuary 18 V14SP2