|
|
|
|
|
|
|
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 case
|
|
|
|
|
|
|
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 Webservice 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...
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|