HViewToFile (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / Managing databases / HFSQL / HFSQL functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HViewToFile (Function)

In french: HVueVersFichier

Available only with this kind of connection

Warning
From version 20, SQL views and the materialized views are available.
The views handled by this function correspond to the former view mechanism. They do not correspond to SQL views or to materialized views.

Saves the modifications performed in an HFSQL view (by HModify, HDelete or HCross) in the corresponding data file.

Note This operation can only be performed if the view has been created with the constant hVueBlock constant (i.e. the records imported into the view have been locked in the data file). After the call to HViewToFile, the records are unlocked in the view source file.

Example

See additional examples

// Enregistre les modification de la vue Client34
// dans le fichier Client
HViewToFile(Client34)

// Test du compte-rendu de la fonction HVueVersFichier
IF HViewToFile(Client13) <> True THEN
	Error("Impossible d'enregistrer les modifications effectuées sur la vue")
END

Syntax

<Result> = HViewToFile(<View>)

<Result>: Boolean

True if the view was transferred into the data file,
False otherwise. HError returns more details about the problem.

<View>: Character string

Name of view used. If this name is not specified, HViewToFile will handle the last view used by an HFSQL function (function starting with "H").

Remarks

If an error occurs when updating the data file, HError is used to identify the records that caused the problem. Simply loop through the view again and run HError on each record in the view.

Component: wd300hf.dll