|
|
|
|
|
|
|
|
|
|
- Filtered source
- Data source: View or query
HToFile (Function) In french: HVersFichier
  Available 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 can be used, for example, to save a history: a query selects all records for the year 2019, the result is transferred to a data file, and a new query deletes all records for the year 2019. 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.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|