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 hVueBlocage (i.e. records imported into the view have been blocked in the data file).. After the call to HViewToFile, the records are unlocked in the view source file.

Example

See additional examples

// Saves the modifications of Customer34 view
// into Customer file
HViewToFile(Customer34)

// Check the status report of HViewToFile
IF HViewToFile(Customer13) <> True THEN
	Error("Unable to save the modifications performed on the view")
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