|
|
|
|
|
|
|
|
|
|
SQL functions for accessing the external databases
Reminder | | | HExecuteQuery | Declares a query created in the query editor to the HFSQL engine and runs this query. | | HExecuteSQLQuery | Initializes a query written in SQL language and declares this query to the HFSQL engine. |
The list of SQL functions available in WLanguage is as follows:
| | | 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 web service 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.
|
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|