|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 interrogated by SQL by using 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 line.|
|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||Positions on the last line of 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 memory Table control (a List Box or Combo Box control), with the possibility of Partial Fetch (the result is retrieved by blocks of rows).|
|SQLTransaction||Allows you to start, validate or cancel 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.