PC SOFT

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
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
Checks and optimizes the system tables of a 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 (with or without quotes) or Connection variable
Connection for which the system tables must be checked and optimized. This connection corresponds to:
<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 : wd250hf.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