ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Filtered source
  • Data source: View or query
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
HToFile (Function)
In french: HVersFichier
HFSQL ClassicHFSQL Client/ServerAvailable only with these kinds of connection
Copies a data source (file, query, view, ...) to a physical HFSQL data file with the same description. This data file is neither encrypted nor password protected.
This function is used to save an history for example: a query selects all the records found for year 2019, the result is transferred to a data file and a new query deletes all the records found for year 2019.
Example
IF HToFile(MyView, "C:\temp\Test.fic") = True THEN
Info("Data transferred into a data file")
END
Syntax
<Result> = HToFile(<Data source> , <Destination file>)
<Result>: Boolean
  • True if the operation was performed,
  • False otherwise (the destination file already exists for example).
<Data source>: Character string
Logical name of the data source to copy (data file, view, query, ...).
<Destination file>: Character string
Full name of the physical data file into which the records found in the source must be copied. This data file and the data source will have the same description. To access this data file, use HDeclareExternal for example.
Remarks

Filtered source

Only the records corresponding to the filter will be copied if a filter is defined and enabled on the data source.

Data source: View or query

If the data source is a view or a query, all the items will be keys of the created data file except for:
  • Memo items.
  • items whose size exceeds 260 characters and not key in the source file of the view or query.
Component: wd290hf.dll
Minimum version required
  • Version 10
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help