| |
| SQLAssociate | Automatically associates each column of the query result with a control or with a variable of the application. |
| SQLChangeConnection | Modifies the current connection. |
| SQLClose | Declares the end of the query execution and frees the memory resources allocated during the execution of the query. |
| SQLCol | Retrieves the content of the specified column from the query result, for the current line. |
| SQLColumn | Returns the characteristics of all the columns (or items):- for a given table.
- for a given query.
|
| SQLColumnFormat | Returns the different types of columns supported: |
| SQLConnect | Connects the current application to a database that must be interrogated via SQL. |
| SQLConnectWS | Connects the current application to a database that will be queried by SQL through a Webservice proxy (SOAP). |
| SQLDisconnect | Closes the current connection and frees the memory used by the connection. |
| SQLExec | Names and runs an SQL query. |
| SQLExecWDR | Runs the SQL code of a query created in the query editor. |
| SQLFetch | Goes to the next row (i.e next record) of the query result. |
| SQLFirst | Positions on the first row of the query result. |
| SQLGetCol | Retrieves the content of the specified column from the query result, for the current line. |
| SQLGetMemo | Retrieves the content of a Memo column from the query result, for the current row. |
| SQLGetTextMemo | Retrieves the content of a Text Memo column found in the query result, for the current line. |
| SQLInfo | Initializes the different SQL variables with information relative to the last query run. |
| SQLLast | Sets the position on the last row of the query result. |
| SQLListSource | Lists the data sources declared on a local site. |
| SQLListTable | List all the tables that can be accessed by the connected database system. |
| SQLLock | Used to lock:- The entire data table, in read and write mode. Its data cannot be accessed by other computers.
- The records selected by the query. This data cannot be accessed by the other computers. This method can be used to update records for example.
|
| SQLModify | Modifies the content of a row in the query result. |
| SQLNext | Positions on the next row of the query result. |
| SQLPrevious | Positions on the previous row of the query result. |
| SQLReqExists | Checks the existence of a query. |
| SQLSeek | Positions on the specified result row of the query. |
| 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). |
| SQLTransaction | Begins, commits or rolls back a transaction:- on the files of a database opened by SQLConnect,
- on the files of a database opened by a connection (OLE DB or Native Access/Native Connector) described in the data model editor or by HOpenConnection.
|