PC SOFT

ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
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
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