ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
<Connection variable>.ServerMaintenance (Function)
In french: <Variable Connexion>.MaintenanceServeur
Checks and optimizes the system tables of an HFSQL server
Example
// Describe the connection
MyConnection is Connection
 
MyConnection.ServerMaintenance()
Syntax
<Result> = <Connection>.ServerMaintenance([<Database>])
<Result>: Boolean
  • True if the system tables have been checked and optimized.
  • False if an error occurred. HError is used to identify the error.
<Connection>: Connection variable
Name of the Connection variable that describes the connection with the system tables to check and optimize.
<Database>: Optional character string
Name of the database containing the system tables to check and optimize. If this parameter is not specified, this function will check and optimize the global system tables.
Component: wd290hf.dll
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/21/2023

Send a report | Local help