<Connection variable>.RefreshQuery (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

HFSQL Client/Server functions

ActivateServerTrigger

AddGroup

AddLink

AddScheduledBackup

AddScheduledOptimization

DeactivateServerTrigger

DeleteScheduledBackup

DeleteScheduledOptimization

DescribeServerTrigger

ExecuteScheduledBackup

ListScheduledOptimization

ModifyDatabaseProperty

ModifyScheduledBackup

ModifyScheduledOptimization

NotifAddEmailRecipient

NotifConfigure

NotifDeleteCCRecipient

NotifDeleteEmailRecipient

NotifListCCRecipient

NotifListEmailRecipient

New WINDEV, WEBDEV, WINDEV Mobile 25 feature!

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Connection variable>.RefreshQuery (Function)

In french: <Variable Connexion>.MiseAJourRequête

Available only with this kind of connection

Creates or refreshes a query on a HFSQL server. Then, the query (.WDR file) can be used in a stored procedure on the server. Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Versions 22 and later

This function is now available for iPhone/iPad applications.

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

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for the Java applications.

New in version 22

This function is now available for iPhone/iPad applications.

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

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for the Java applications.

This function is now available for iPhone/iPad applications.

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

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for the Java applications.

Example

// Describe the connection
MyConnection is Connection

// Refresh or create the query
MyConnection.RefreshQuery(Query1)

// Update the query even if there is a more recent version of the query on the server
MyConnection.RefreshQuery(Query1, True)

Syntax

<Result> = <Connection>.RefreshQuery(<Query> [, <Force>])

<Result>: Boolean

True if the query was created or refreshed,
False otherwise. HError is used to identify the error.

<Connection>: Connection variable

Name of the Connection variable that describes the connection to the server on which the query must be created or updated.

<Query>: Character string (with quotes)

Name of the query to create or refresh on the server.
If this parameter corresponds to "*", all the queries will be refreshed or created on the server.
Versions 16 and later
The quotes are no longer mandatory for this parameter.
New in version 16
The quotes are no longer mandatory for this parameter.
The quotes are no longer mandatory for this parameter.

<Force>: Optional boolean

False (default value): the query will be created or refreshed:
if the query is not found on the server.
if an earlier version of the query is found on the server.
True: the query will be created in any case.

Component : wd250hf.dll