|
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.
Syntax
SqlSelect(<select_statement>|<method_call>[,
<window_name>])
Parameters
select_statement|method_call
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.
window_name
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. |
Note:
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')
|
