|
|
|
|
|
|
|
|
|
|
- The different types of queries
- Browsing the data file
- FileToMemoryTable function and New property
- Previous versions
FileToMemoryTable (Function) In french: FichierVersTableMémoire Populates a Table control programmatically with the records from a data file, HFSQL view or query (query created in the query editor or with HExecuteSQLQuery). The Table control populated programmatically must contain the columns to be bound to the items. The FileToMemoryTable function will: - clear the Table control.
- bind the columns of the Table control to the items of a data file, HFSQL view or query. The fields will be associated according to their physical order defined in the data file.
- populate the Table control with the data from a data file or query.
ATTENTION: This operation can take a long time and saturate memory if the data file is large.
FileToMemoryTable(TABLE_MyTable, QRY_Query1)
Syntax
FileToMemoryTable(<Table control> , <Data file>)
<Table control>: Control name Name of the Table control to be populated. <Data file>: Character string Name of data file, HFSQL view or query used. Remarks The different types of queries FileToMemoryTable can be used with the queries created in the query editor or by HExecuteSQLQuery. To associate a query created by SQLExec with a Table control populated programmatically, use SQLTable. The data file is browsed through according to the content of the BrowsedItem property. In order for FileToMemoryTable to take into account the filter applied to the data file, you must: - Assign the item returned by HFilter to the BrowsedItem property.
- Use FileToMemoryTable.
FileToMemoryTable function and New property FileToMemoryTable sets the NewLine property to True.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|