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
HServerMaintenance (Function)
In french: HMaintenanceServeur
Checks and optimizes the system tables of a HFSQL server
Example
HServerMaintenance(MyConnection)
Syntax
<Result> = HServerMaintenance(<Connection name> [, <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 name>: Character string (with or without quotes)
Name of the connection for which the system tables must be checked and optimized. This connection was defined in the data model editor, or by HDescribeConnection or HOpenConnection.
<Database>: Optional character string (with or without quotes)
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 : wd240hf.dll
See also
Minimum required version
  • Version 22
This page is also available for…
Comments
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
Jul. 18 2017