|
|
|
|
|
|
|
WEBDEV allows a site to create and access a database created by the browser on the computer of the Web user in browser code.
|
|
|
|
|
|
|
The database can be accessed via a web service... |
|
|
|
|
|
|
List of SQL functions used to access the external databases |
|
|
|
|
|
|
List of SQL functions: Special cases |
|
|
|
|
|
|
Automatically associates each column of the query result with a control or with a variable of the application. |
|
|
|
|
|
|
Modifies the current connection. |
|
|
|
|
|
|
Declares the end of the query execution and frees the memory resources allocated during the execution of the query. |
|
|
|
|
|
|
Retrieves the content of the specified column from the query result, for the current line. |
|
|
|
|
|
|
Returns the characteristics of all the columns (or items):- for a given table.
- for a given query.
|
|
|
|
|
|
|
Returns the different types of columns supported: |
|
|
|
|
|
|
Usage example of the SQLConnect function |
|
|
|
|
|
|
Connects the current application to a database that must be interrogated via SQL. |
|
|
|
|
|
|
Connects the current application to a database that will be queried by SQL through a web service proxy (SOAP). |
|
|
|
|
|
|
Closes the current connection and frees the memory used by the connection. |
|
|
|
|
|
|
Usage example of the SQLExec function |
|
|
|
|
|
|
Names and runs an SQL query. |
|
|
|
|
|
|
Runs the SQL code of a query created in the query editor. |
|
|
|
|
|
|
Goes to the next row (i.e next record) of the query result. |
|
|
|
|
|
|
Usage example of the SQLFirst function |
|
|
|
|
|
|
Positions on the first row of the query result. |
|
|
|
|
|
|
Retrieves the content of the specified column from the query result, for the current line. |
|
|
|
|
|
|
Retrieves the content of a Memo column from the query result, for the current row. |
|
|
|
|
|
|
Retrieves the content of a Text Memo column found in the query result, for the current line. |
|
|
|
|
|
|
Initializes the different SQL variables with information relative to the last query run. |
|
|
|
|
|
|
Sets the position on the last row of the query result. |
|
|
|
|
|
|
Lists the data sources declared on a local site. |
|
|
|
|
|
|
List all the tables that can be accessed by the connected database system. |
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
Usage example of the SQLModify function |
|
|
|
|
|
|
Modifies the content of a row in the query result. |
|
|
|
|
|
|
Positions on the next row of the query result. |
|
|
|
|
|
|
Positions on the previous row of the query result. |
|
|
|
|
|
|
Checks the existence of a query. |
|
|
|
|
|
|
Positions on the specified result row of the query. |
|
|
|
|
|
|
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). |
|
|
|
|
|
|
Usage example of the SQLTransaction function |
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
Two types of browse can be used to browse the result of a query run by SQLExec... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|