SQLDisconnect (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / Managing databases / SQL functions

HFSQL analysis connection
Miscellaneous

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

SQLDisconnect (Function)

In french: SQLDéconnecte

Closes the current connection and frees the memory used by the connection. SQLDisconnect must be systematically called to close the connection, even if this connection failed.

Example

// Example associated with the SALESMGT analysis
// TABLE_QryTable is a Table control populated programmatically
ResConnect is int
ResExec is boolean
MyDatabase is string = "C:\SALESMGT.WDD"
ResConnect = SQLConnect(MyDatabase, "", "")
IF ResConnect <> 0 THEN
ResExec = SQLExec("SELECT NAME, CITY FROM POP", "QRY1")
IF ResExec = True THEN
// Retrieve the data in the table
SQLTable("QRY1", TABLE_QryTable)
ELSE
// Error while running the query
// Retrieve information about the query run
SQLInfo("QRY1")
Error(SQL.MesError)
END
// Free the query in any case
SQLClose("QRY1")
ELSE
// Connection error
Error("The connection to the database" + MyDatabase + " failed")
END
// Free the query in any case
SQLDisconnect()

Syntax

SQLDisconnect()

Remarks

HFSQL analysis connection

In a connection with an HFSQL analysis, SQLDisconnect closes the analysis (same as HCloseAnalysis). To continue to use the analysis files, the analysis must be opened by HOpenAnalysis.

Miscellaneous

A single connection can be established at a given time.
The memory allocated during the connection (execution of "SQLFreeConnect") is automatically freed.

Component: wd300hf.dll