ONLINE HELP
 WINDEV, WEBDEV 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
Checks and optimizes the system tables of an HFSQL server
Example
HServerMaintenance(MyConnection)
Syntax
<Result> = HServerMaintenance(<Connection> [, <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>: Character string or Connection variable
Connection for which the system tables must be checked and optimized. This connection corresponds to:
<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: wd280hf.dll
See also
Minimum version required
  • Version 22
This page is also available for…
Comments
PROCEDURE evento_verificar_tabelas(MyConnection, MyDatabase)
//Verifica e otimiza as tabelas do sistema de um servidor HFSQL
Info("Verificando Tabelas...")

IF HServerMaintenance(MyConnection,MyDatabase) = True
Info("Verificação finalizada..")
ELSE
Info(HErrorInfo())
END
Boller
02 Sep. 2023
Checks and optimizes the system tables of an HFSQL server
Trace("Verificando Tabelas...")
bHresultado is boolean=HServerMaintenance(Matos_hyperfil_server,"matos")
IF bHresultado=True THEN
Trace("finalizado..")
ELSE
Trace(HError())
END

// BLOG COM VIDEO E EXEMPLO

http://windevdesenvolvimento.blogspot.com.br/2017/07/aula-1214-windev-hyperfile-30.html

https://www.youtube.com/watch?v=Xi4oEwLo05w
De matos
18 Jul. 2017

Last update: 05/26/2022

Send a report | Local help