- Characteristics of the Table control populated programmatically
- Closing a query
- Using the Partial Fetch
- The different types of queries
- Unicode management
In french: SQLTable
Transfers the result of a query to a Table control populated programmatically (a List Box or Combo Box control), with the possibility of Partial Fetch (the result is retrieved by blocks of rows). In a "SQLFetch/SQLGetCol" browse, the transfer of information to the Table control will start from the current record.
: This function must be used to browse the result of the SQLFetch/SQLGetCol query. A fatal error occurs if this function is used in an SQLFirst/SQLCol browse. For more details, see Types of SQL browse
// Transfer to a Table control: retrieval without fetch
ResSQL = SQLExec("SELECT CUSTNAME, CUSTFIRSTNAME FROM INV", "QRY1")
IF ResSQL THEN
SQLTable("QRY1", TABLE_QryTab, "Customer name" + TAB + "First name", "30 20")
// Calculates the number of result records
NbRec is int = TableCount(TABLE_QryTab)
// SQL error
Transfer to a Table control populated programmatically without Partial Fetch Hide the details
SQLTable(<Query name> , <Table control> , <Maximum number of rows> [, <Title of columns>] , <Width of columns>)
<Query name>: Character string
Name of the query created and executed with SQLExecWDR, or executed with SQLExec.
<Table control>: Control name
Name of the Table control populated programmatically where the result of the query will be displayed.
<Maximum number of rows>: Integer
Maximum number of rows displayed in the Table control. If this parameter is specified, the Table control will contain a maximum of <Maximum number of rows> rows displayed, even if the result of the query contains a greater number of rows.
<Title of columns>: Optional character string
List of all the column titles in the Table control populated programmatically. The different titles are separated by TAB characters. To specify the widths of the columns only, this parameter can correspond to an empty string ("").
<Width of columns>: Character string
List of all the column widths, separated by a space character. To specify the titles of the columns only, this parameter can correspond to an empty string ("").
Characteristics of the Table control populated programmatically
The number of columns in the Table control populated programmatically must be sufficient to accept all the columns of the query result.
A query is automatically closed:
- once SQLTable has been executed if the partial Fetch is not used.
- as soon as the query result is entirely retrieved if the Partial Fetch is used.
Using the Partial Fetch
The current retrieval stops as soon as SQLClose
is called or as soon as the window containing the Table control is closed.
The Partial Fetch can be used on several queries at the same time.
The different types of queries
associates a Table control populated programmatically with the queries created by SQLExec
You can define how Unicode will be managed in the project configuration ("Unicode" tab of the configuration description window):
- If the "Use ANSI strings at runtime" option is selected: the data is converted using the current character set.
Reminder: ChangeCharset changes the current character set.
- If "Use UNICODE strings at runtime" is selected, the data is inserted without being converted.
This page is also available for…