Previous Next

Creates an info window with the name specified in a SELECT statement. Examples of where this function can be used include startup, button, decision and dialog actions.


SqlSelect(<select_statement>|<method_call>[, <window_name>])



The SQL SELECT statement you want as underlying query for the info window to be created.

Alternatively, you can specify a method call, like FORMULA() or an ObjectName.propertyName() call that returns the current value of a property.


The name of the window to be created.

· If an info window with this name is available in the ESI file, it is used.


· If not specified, the Object name Plural of the main table of the query is used.


· Otherwise a default info window is created.


The UNION set operator cannot be used within SqlSelect().

Example 1

SqlSelect('SELECT destination, tour_type FROM TOUR', 'Destinations')

If you want to refer to a certain value produced by an existing global variable, or from a certain text box or column, surround it with double quotes and start with a colon, as shown in example 2 and 3:

Example 2

SqlSelect('SELECT destination, tour_type FROM TOUR where :"Global.MyVariable"', 'Destinations')

Example 3

SqlSelect('SELECT destination, tour_type FROM TOUR where destination = :"Variables.Text_Box_1()"', 'Destinations')

In a Yes or No Action Decision, you cannot define SQLSelect() statement with a placeholder referring directly to the value retrieved by its Decision SQL. Instead, first transform the output of the Decision SQL to a global variable using ResourceFileUpdate(). Then, define SqlSelect() referring to the new value of the global variable, as shown in example 4:

Example 4

Decision SQL:

Select destination from tour where tour_type = 'SPORTIVE'

Yes or No Action Decision:

ResourceFileUpdate('MyFavoriteDestination: ' ||:1)

SqlSelect('SELECT destination, tour_type FROM TOUR where destination = :"MyFavoriteDestination"', 'Destinations')