Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Filtered source
  • Data source: View or query
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
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.
IF HToFile(MyView, "C:\temp\Test.fic") = True THEN
Info("Data transferred into a data file")
<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.

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…
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help