Accessing a database in local mode (SQLite) WEBDEV allows a site to create and access a database created by the browser on the computer of the Web user in browser code. Accessing a database via a web service The database can be accessed via a web service... Funciones SQL para acceder a las bases de datos externas Lista de funciones SQL utilizadas para acceder a las bases de datos externas Los diferentes tipos de navegación disponibles en SQL Se pueden utilizar dos tipos de búsqueda para buscar el resultado de una consulta realizada por SQLExec..... SQL functions: Special case List of SQL functions: Special cases SQLAssociate (Function) Automatically associates each column of the query result with a control or with a variable of the application. SQLChangeConnection (Function) Modifies the current connection. SQLClose (Function) Declares the end of the query execution and frees the memory resources allocated during the execution of the query. SQLCol (Function) Retrieves the content of the specified column from the query result, for the current line. SQLColumn (Function) Returns the characteristics of all the columns (or items): for a given table. for a given query. SQLColumnFormat( Función) Devuelve los diferentes tipos de columnas soportadas: por la fuente de datos identificada por SQLConnect. por la base de datos a la que se accede por una conexión específica (conexión descrita en el análisis o descrita por HDescribeConnection o HOpenConnection). SQLConnect (Example) Usage example of the SQLConnect function SQLConnect (Function) Connects the current application to a database that must be interrogated via SQL. SQLConnectWS (Function) Connects the current application to a database that will be queried by SQL through a web service proxy (SOAP). SQLDisconnect (Función) Cierra la conexión actual y libera la memoria utilizada por la conexión. SQLExec (Function) Names and runs an SQL query. SQLExecWDR (Function) Runs the SQL code of a query created in the query editor. SQLFetch (Function) Goes to the next row (i.e next record) of the query result. SQLFirst (Example) Usage example of the SQLFirst function SQLFirst (Function) Positions on the first row of the query result. SQLGetCol (Function) Retrieves the content of the specified column from the query result, for the current line. SQLGetMemo (Function) Retrieves the content of a Memo column from the query result, for the current row. SQLGetTextMemo (Function) Retrieves the content of a Text Memo column found in the query result, for the current line. SQLInfo (Function) Initializes the different SQL variables with information relative to the last query run. SQLLast (Function) Sets the position on the last row of the query result. SQLListSource (Function) Lists the data sources declared on a local site. SQLListTable (Function) List all the tables that can be accessed by the connected database system. SQLLock (Function) 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 (Function) Modifies the content of a row in the query result. SQLNext (Function) Positions on the next row of the query result. SQLPrevious (Function) Positions on the previous row of the query result. SQLReqExists (Función) Comprueba la existencia de una consulta. SQLSeek (Function) Positions on the specified result row of the query. SQLTable (Function) 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 (Example) Usage example of the SQLTransaction function 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.