FileToMemoryTable (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

The different types of queries

Browsing the data file

FileToMemoryTable function and ..New property

See also

CollapseExpand

BuildBrowsingTable

Constants for managing Table, Treeview Table, Looper and List Box controls

FileToMemoryTable

Functions for managing Table controls

TableAddLineWithAnimation

TableCellSelectOccurrence

TableCollapseExpand

TableColumnSelect

TableColumnSelectOccurrence

TableDeleteWithAnimation

TableFormulaDeleteAll

TableInsertLineWithAnimation

TableRestorePositionAndSelection

TableSave

TableSavePositionAndSelection

The different types of queries
Browsing the data file
FileToMemoryTable function and ..New property

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

FileToMemoryTable (Function)

In french: FichierVersTableMémoire

Fills a "Memory table" control with all records found in a data file, a HFSQL view or a query (query created in the query editor or by HExecuteSQLQuery).

The memory Table control must contain the columns to associate with the items. FileToMemoryTable will:

clear the Table control.
associate the columns of the Table control with the items found in a data file, a HFSQL view or a query. The items will be associated according to their 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.

Versions 16 and later

This function is now available for WINDEV applications in Linux.

New in version 16

This function is now available for WINDEV applications in Linux.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Example

// Fill the TABLE_MyTable control with the content of QRY_Query1
FileToMemoryTable(TABLE_MyTable, QRY_Query1)

Syntax

FileToMemoryTable(<Table control> , <Data file>)

<Table control>: Control name

Name of memory Table control to fill.

<Data file>: Character string (with or without quotes)

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 memory Table control, use SQLTable.

Browsing the data file

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

FileToMemoryTable assigns ..NewLine to True.

Component : wd250obj.dll