SQLFetch (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

SQLFetch: Partial retrieval of the query result
Lifespan of a browse

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

SQLFetch (Function)

In french: SQLAvance

Goes to the next row (i.e next record) of the query result.

During the first call to SQLFetch, the current record will be the first record selected by the query.

This function is used to browse the query result "line by line". See Types of SQL browse for more details.

To optimize the performances, we recommend that you use a SQLFirst/SQLNext browse.

The SQL functions are used to handle the MySQL databases and the databases accessible by ODBC (HFSQL for example).

Versions 16 and later

This function is now available in Browser code.

The SQL functions are used to handle the local databases (such as Web SQL databases). Only the SQLFetch/SQLGetCol browse mode is available. See Accessing a database in local mode (SQLite) for more details.

New in version 16

This function is now available in Browser code.

Versions 19 and later

This function is now available in Android Widget mode (accessing the external databases via a Webservice).

This function is now available for the Android applications (accessing the external databases via a Webservice).

This function is now available for the iPhone/iPad applications (accessing the external databases via a Webservice).

New in version 19

This function is now available in Android Widget mode (accessing the external databases via a Webservice).

This function is now available for the Android applications (accessing the external databases via a Webservice).

This function is now available for the iPhone/iPad applications (accessing the external databases via a Webservice).

This function is now available in Android Widget mode (accessing the external databases via a Webservice).

This function is now available for the Android applications (accessing the external databases via a Webservice).

This function is now available for the iPhone/iPad applications (accessing the external databases via a Webservice).

Versions 21 and later

This function is now available in Universal Windows 10 App mode.

New in version 21

This function is now available in Universal Windows 10 App mode.

Example

i is int = 0
SQLExec("SELECT LASTNAME, FIRSTNAME, EXTENSION, PHOTO FROM CUSTOMER", "QRY1")
// Retrieve the query row by row
WHILE SQLFetch("QRY1") = 0
// There is still another row to read
i++
// Retrieve the data
LASTNAME[i] = SQLGetCol("QRY1", 1)
FIRSTNAME[i] = SQLGetCol("QRY1", 2)
EXTENSION[i] = SQLGetCol("QRY1", 3)
{"IMAGE"+i} = SQLGetMemo("QRY1", 4)
END
SQLClose("QRY1")

Syntax

<Result> = SQLFetch(<Query name>)

<Result>: Integer

0 if the record was successfully read. The data can be retrieved by SQLGetCol and SQLGetMemo.

<Query name>: Character string (with or without quotes)

Name of the query created and run by SQLExec (with quotes),
Name of the query run by SQLExecWDR (with or without quotes).
The queries created with the query editor must be specified in the format of a character string with quotes.
Versions 16 and later
Only the queries created and run by SQLExec are available.
New in version 16
Only the queries created and run by SQLExec are available.
Only the queries created and run by SQLExec are available.

Remarks

SQLFetch: Partial retrieval of the query result

SQLFetch does not retrieve all the lines of the query result: only the current record is retrieved by SQLFetch.

Therefore, the total number of result rows (SQL.NbLine) cannot be retrieved by SQLInfo if SQLFetch is used to browse the result.

Lifespan of a browse

The lifespan of a browse performed by SQLFetch is limited to the lifespan of the PHP script. No browse can be continued with SQLFetch once the page was returned (even in session mode).

Component : wd250hf.dll