ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
<Source>.ViewToFile (Function)
In french: <Source>.VueVersFichier
HFSQL ClassicAvailable only with this kind of connection
Saves the modifications performed in an HFSQL view (by <Source>.Modify, <Source>.Delete or <Source>.Cross) in the corresponding data file.
Remark: This operation can be performed only if the view was created with the hViewLocking constant (which means that the records imported into the view have been locked in the data file). After the call to <Source>.ViewToFile, the records are unlocked in the view source file.
Example
// Saves the modifications of Customer34 view
// into Customer file
Customer34.ViewToFile()
WINDEVWEBDEV - Server codeWindowsHFSQL Classic
// Check the status report of HViewToFile
IF Customer13.ViewToFile() <> True THEN
Error("Unable to save the modifications performed on the view")
END
Syntax
<Result> = <Source>.ViewToFile()
<Result>: Boolean
  • True if the view was transferred into the data file,
  • False otherwise. HError returns more details about the problem.
<Source>: Type of Source
Name of view used.
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: wd290hf.dll
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 10/26/2023

Send a report | Local help