Native Informix Connector : Programming with SQL functions

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Help

Native Connectors/Native Accesses

Native Informix Connector

Native Informix Connector : Programming with SQL functions

Overview

Programming

See also

Natif Informix Connector for WINDEV and WEBDEV

Native Informix Connector : Programming with SQL functions

Available only with this kind of connection

Overview

Using the SQL functions to handle the Informix data does not require to import the structure of files into the analysis. However, the data must be handled by queries only. The content of the Informix files cannot be read directly.

Programming

1. Opening the connection

SQLConnect is used to establish a connection to an Informix database via Native Connector. The type of database used (INFORMIX in this case) must be passed in parameter to SQLConnect.

The database name corresponds to the name of the Informix server (or to its alias).

ConnectionNum = SQLConnect("InformixDatabase", "sa", "", "", "INFORMIX")

2. Running queries

The queries are run by SQLExec. SQLExec expects in parameter the text of SQL query as well as the name that will be given to this query.

SQLExec("SELECT LASTNAME, FIRSTNAME, EXTENSION, PHOTO FROM CUSTOMER", "QRY1")

3. Retrieving the result

Several methods can be used to retrieve the result:

SQLFirst: Used to retrieve the result and to initialize a browse (SQLFirst/SQLCol).
SQLTable: Used to retrieve the query result in a memory table of the WINDEV or WEBDEV application. The result of the query can be retrieved by partial Fetch.
SQLAvance: Used to browse the different lines of query result. The browse performed in the query result is an SQLFetch/SQLGetCol browse.

SQLLock is used to lock the table records or the records selected by the query.

4. Closing the connection

SQLClose is used to close the connection to the database when all the necessary queries have been run.