Decimal Intrinsic Functions - AsValue Method

Return the variable as a value if SQLNull

Member of Decimal Intrinsic Functions (PRIM_LIBI.IDecimalIntrinsics)

Parameters

Name

Type

Data Type

Description

Result

*Result (Optional)

Decimal

Resulting value

Default

*Input (Optional)

Decimal

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 = 123) *or (#Variable.IsSqlNull)
     ...

AsValue allows the following

     If (#Variable.AsValue(123))
     ...


See also

All Component Classes

Technical Reference