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 MyView.ToFile("C:\temp\Test.fic") = True THEN
Info("Data transferred into a data file")
END
Syntax
<Result> = <Source>.ToFile(<Destination file>)
<Result>: Boolean
- True if the operation was performed,
- False otherwise (the destination file already exists for example).
<Source>: Type corresponding to the specified source
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 <Source>.DeclareExternal 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.