ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Attention : This is version 26 of this documentation page. This feature may have been changed or removed in a higher version.
Help / WLanguage / Managing databases / HFSQL functions / Compatible Hyper File functions
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
HViewToTable (Function)
In french: HVueVersTable
HFSQLAvailable only with this kind of connection
Warning
HViewToTable is kept for backward compatibility (this function will still be supported in the forthcoming version).
Since version 8, the number of rows found in a memory table is not limited in WINDEV, so it may take a few minutes to fill the memory table and the memory might get saturated if the view contains an important number of records.
To optimize the management of your memory tables based on a view, use FileToMemoryTable.
Caution: HViewToTable uses 5.5 views, while FileToMemoryTable uses WINDEV functions.
Below is the documentation of HViewToTable, available in WINDEV 5.5.
 
Purpose
Filling a memory table with a view.
Syntax
<Result>= HViewToTable(<ViewIdent>,<TableName>)
  • <Result> is a boolean, equal to True if the association is successful.
  • <ViewIdent> is a long integer corresponding to the identifier of the view returned by HCreateView_55.
  • <TableName> is the name of the memory table to fill.
Details
<Result> is used to find out whether the memory table was filled with the view records. If <Result> is set to False, then:
  • the view does not exist,
  • the table does not exist,
  • the name of the table is not the name of a memory table.
The columns are filled in the order of the items in the view. The type of columns must correspond to the type of items.
Component: wd260obj.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 02/26/2021

Send a report | Local help