constantvalue(
NAME
)

The constantvalue( function converts a field or variable into an equivalent constant value.


Parameters

This function has one parameter:

name – name of the field or variable to convert into a constant.


Description

This function converts a field or variable into an equivalent constant value. If the field or variable contains text the result will be quoted. If it contains binary data it will be encoded using base64. The result of this function can be used in an execute statement. Here some examples of this function with typical data.

constantvalue("City") ☞ "San Francisco"
constantvalue("Quantity") ☞ 12
constantvalue("Price") ☞ 9.95
constantvalue("Date") ☞ 2456762
constantvalue("Data") ☞ decodebase64("3g#=")

See Also


History

VersionStatusNotes
10.0UpdatedCarried over from Panorama 6.0, but now supports binary data as well as text and numbers. Also, the field/variable name parameter no longer has to be quoted.