SQLDISCONNECT()

SQLDISCONNECT()

Class

SQL Applications

Purpose

Disconnect from a data source

Syntax

SQLDISCONNECT(<nStatementHandle>)

See Also

CREATE CONNECTION, SQLCANCEL(), SQLCOLUMNS(), SQLCOMMIT(), SQLCONNECT(), SQLEXEC(), SQLGETPROP(), SQLMORERESULTS(), SQLPREPARE(), SQLROLLBACK(), SQLSETPROP(), SQLSTRINGCONNECT(), SQLTABLES()

Description

The SQLDISCONNECT() function is used to disconnect from a data source.

The SQLDISCONNECT() function operates on the data source specified by <nStatementHandle>.

Keywords	Description
nStatementHandle	The workarea in which the gateway data source is open. Specifying 0 causes all active connections to be disconnected.

Return values:

Return Value	Description
1	Disconnection completed successfully
–1	Connection error
–2	Environment error

Example

nStatHand=SQLSTRINGCONNECT("mysql@linux1:user1/pass1-database1.tcpip",.T.)
if nStatHand < 1
  dialog box [Could not connect]
else
  dialog box [Connected]
  SQLDISCONNECT(nStatHand)
endif

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer