10 10 7 AsValue

LANSA Technical

10.10.7 AsValue

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

Input Parameters

Default - The value to be returned when the variable contains an SQLNull.

Allowable value for a time is any valid time.

Example

Rather than having to test as below

If ((#Time = 00:00:00) *or (#Time.IsSqlNull)

 

Endif

 

AsValue allows the following

If (#Time.AsValue( 00:00:00 ) = 00:00:00)

 

Endif

 

Ý 10.10 Time Intrinsic Functions