PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
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
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 is using the views in 5.5 format while FileToMemoryTable is using the functions in WINDEV format.
The documentation about HViewToTable available in WINDEV 5.5 is as follows.
 
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.
Components
WINDEVReports and Queries wd230obj.dll
WEBDEV - Server code wd230page.dll
Windows Mobile wp230obj.dll
Linux wd230obj.so
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment