PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
HToFile (Function)
In French: HVersFichier
HFSQLHFSQL 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 2012, the result is transferred to a data file and a new query deletes all the records found for year 2012.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Versions 22 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
WINDEVJava This function is now available for the Java applications.
New in version 22
iPhone/iPad This function is now available for the iPhone/iPad applications.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
WINDEVJava This function is now available for the Java applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
WINDEVJava This function is now available for the Java applications.
Example
IF HToFile(MyView, "C:\temp\Test.fic") = True THEN
Info("Data transferred into a data file")
END
Syntax
<Result> = HToFile(<Name of Data Source> , <Name of Destination File>)
<Result>: Boolean
  • True if the operation was performed,
  • False otherwise (the destination file already exists for example).
<Name of Data Source>: Character string (with or without quotes)
Logical name of the data source to copy (data file, view, query, ...).
<Name of Destination File>: Character string (with quotes)
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.
Components
WINDEVWEBDEV - Server code wd230hf.dll
Windows Mobile wp230hf.dll
Java wd230java.jar
Linux wd230hf.so
Android wd230android.jar
Minimum required version
  • Version 10
This page is also available for…
Comments
Click [Add] to post a comment