SQLReqExists (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

SQLReqExists (Function)

In french: SQLReqExiste

Checks the existence of a query.

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). See Accessing a database in local mode (SQLite) for more details.

New in version 16

This function is now available in Browser code.

The SQL functions are used to handle the local databases (such as Web SQL databases). See Accessing a database in local mode (SQLite) for more details.

This function is now available in Browser code.

The SQL functions are used to handle the local databases (such as Web SQL databases). See Accessing a database in local mode (SQLite) for more details.

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

// Checks the existence of a query
IF SQLReqExists("QRY1") = 1 THEN
Info("The query exists")
END

Syntax

<Result> = SQLReqExists(<Query Name>)

<Result>: Boolean

True if the query exists,
False otherwise.

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

Name of query created and run by SQLExec (with quotes), or 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.

Component : wd240hf.dll