Common arguments
The common arguments for the ResultTableRead
and ResultTableUpdate
are listed here.
QueryCode
= The entry in FsQuery that has the SQL statement to execute.QueryArgs
= A list of replacements values to be used when executing the SQL. This list replaces the numbered tokens in the SQL, i.e.,[%1]
,[%2]
, etc.QueryNamedArgs
= A list of named replacement values to be used when executing the SQL. This list replaces the named tokens in the SQL, i.e.,[%%NAMED_TOKEN1]
,[%%NAMED_TOKEN2]
- The query is scanned by the system and the list of named tokens is replaced.
%%SEARCHTABLE
– the name of the current Search Result table%%KEYFIELD
– the name of the primary key field for the current search object%USER
– the code of the current user%LAB
– the code of the current lab%GROUP
– the code of the current group%%CURRENT_DB_NAME
– the code of the current database connection%%CURRENT_SESSION_ID
– the current session ID value
Public ReadOnly Property SearchedKeyField As String
Returns the name of the primary key field for the current search object. (i.e., "ITEM_CODE" when searching for Items, "FORMULA_ID" when searching for Formulas)
Public Property SearchSQL() As String
Enables the script to retrieve and update the SQL that is used to execute the search.
- Returns Nothing during the
PreSearch
script hook. - Updating the SQL during the
PreSearch
script hook is ignored. - Updating the SQL during the
PreSearchExecute
script hook is permitted. - Updating the SQL during the
PostSearch
script hook is ignored.
- Returns Nothing during the