query_retrieve_or_set_the_sql_data_query_.htm
| Navigation: Templates > Guide to all Templates > Additional Libraries and Templates > Crystal8 Class >====== Query (retrieve or set the SQL data query) ====== |    |
Query( | querystring |)
Query Set or retrieve the SQL data query.
querystring A string constant, variable, EQUATE, or expression containing the SQL query to be sent to the SQL data source. This parameter is optional.
The Query method is used to either get or set the SQL query. If the querystring is omitted from the method call, the current query is retrieved.
Return Data Type: STRING
Example:
formula = oCrystal8.Query()!retrieve query into formula variable
formula = '{{Customer.Country} in [“Australia”]' ! SQL query
oCrystal8.Query( formula ) ! Set the query
query_retrieve_or_set_the_sql_data_query_.htm.txt · Last modified: 2021/04/15 15:57 by 127.0.0.1