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 access to a database can be performed via a Webservice... |
| |
| |
| |
List of SQL functions used to access the external databases |
| |
| |
| |
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: |
| |
| |
| |
Connects the current application to a database that must be interrogated via SQL. |
| |
| |
| |
Connects the current application to a database to be queried via SQL through a web service proxy (SOAP). |
| |
| |
| |
Closes the current connection and frees the memory used by the connection. |
| |
| |
| |
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. |
| |
| |
| |
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 line. |
| |
| |
| |
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. |
| |
| |
| |
Positions on the last line of 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.
|
| |
| |
| |
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 memory Table control (a List Box or Combo Box control), with the possibility of Partial Fetch (the result is retrieved by blocks of rows). |
| |
| |
| |
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.
|
| |
| |
| |