Fills an control of type "Memory table" with all the records of a data file, of an HFSQL view or of a query (query created with the query editor or with the HExecuteSQLQuery
The memory Table control must contain the columns to be bound to the items. FileToMemoryTable will:
- clear the Table control.
- bind the columns of the Table control to the items of a data file, HFSQL view or query. The items will be bound according to the logical order defined in the file.
- fill the Table control with the content of data file or query.
CAUTION: This operation may take quite a long time and it may overflow the memory if the data file is very large.
This function is now available for WINDEV applications in Linux.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
// Remplir le champ TABLE_MaTable avec le contenu de REQ_Requête1
FileToMemoryTable(<Table control> , <Data file>)
<Table control>: Control name
Name of memory Table control to fill.
<Data file>: Character string
Name of data file, HFSQL view or query used.
The different types of queries
can be used with the queries created in the query editor or by HExecuteSQLQuery
To associate a query created by SQLExec
with a memory Table control, use SQLTable
The data file is browsed according to the content of BrowsedItem
In order for FileToMemoryTable to take into account the filter applied to the data file, you must:
- Modify BrowsedItem by assigning it with the item returned by HFilter.
- Use FileToMemoryTable.
FileToMemoryTable function and New property
This function replaces the HVueVersTablefunction, which was retained for compatibility with WINDEV 5.5.