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
HSetCache (Function)
In French: HGèreCache
HFSQL Client/ServerAvailable only with this kind of connection
Used to configure the management of caches in the HFSQL Client/Server engine.
Versions 17 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for the iPhone/iPad applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 22 and later
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
WINDEVJava This function is now available for the Java applications.
New in version 22
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
WINDEVJava This function is now available for the Java applications.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
WINDEVJava This function is now available for the Java applications.
Example
HSetCache(hPageSize, 2000)
Syntax
<Result> = HSetCache(<Parameter to Modify> [, <File Name> [, <Item Name>]] , <Value>)
<Result>: Integer
Former value of modified parameter (value before modification).
<Parameter to Modify>: Constant
Parameter of the cache to modify:
hPageSizeSize of a block of caches. This block of caches will be used when browsing a data file.
A large block of caches improves the browse and increases the transfers via network and the memory consumption.
This parameter corresponds to the number of records read during the browse.
<File Name>: Optional character string (with or without quotes)
Name of the data file to which the modification must be applied.
If this parameter is not specified, the modification is applied to all the data files.
<Item Name>: Optional character string (with or without quotes)
Name of the item to which the modification must be applied.
If this parameter is not specified, the modification will be applied to all the items found in the specified data file.
<Value>: Integer
New value that must be given to the parameter.
For the hPageSize constant, this value must be included between 1 and 5000 (the default value on a PC is 1000 and the default value on a Pocket PC is 10).
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Windows Mobile wp230hf.dll
Java wd230java.jar
Linux wd230hf.so
Android wd230android.jar
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment