PC SOFT

ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
  • The different types of queries
  • Browsing the data file
  • FileToMemoryTable function and New property
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Fills a "Memory table" control with all the records from a data file, HFSQL view or query (query created in the query editor or by 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.
Versions 16 and later
Linux This function is now available for WINDEV applications in Linux.
New in version 16
Linux This function is now available for WINDEV applications in Linux.
Linux 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:
  1. Modify BrowsedItem by assigning it with the item returned by HFilter.
  2. Use FileToMemoryTable.

FileToMemoryTable function and New property

FileToMemoryTable assigns New to True.
Component: wd260obj.dll
See also
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment