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.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
IF HToFile(MyView, "C:\temp\Test.fic") = True THEN
Info("Data transferred into a data file")
<Result> = HToFile(<Name of Data Source> , <Name of Destination File>)
- 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.
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.