10 6 12 AsValue

LANSA Technical

10.6.12 AsValue

The AsValue() intrinsic method can be used to specify a value to be returned from a field if it contains an SQL Null.

See Intrinsic Method .AsValue.

Input Parameters

The value to be returned instead of an SQLNull.

Example

Rather than having to test as below whether the value of an object is AAA or an SQL null:

If ((#Std_obj = AAA) *or (#Std_obj.IsSqlNull)

 

Endif

 

 

You can use AsValue:

If (#Std_obj.AsValue( AAA ) = AAA)

 

Endif

 

Ý 10.6 Alphanumeric/String Intrinsic Functions