SQLGETPROP()

From Recital Documentation Wiki
Jump to: navigation, search

Purpose

Query property settings for a connection or the environment


Syntax

SQLGETPROP(<nStatementHandle>, <cSetting>)


See Also

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


Description

The SQLGETPROP() function is used to query the property settings for a specified connection or for the current environment.

The SQLGETPROP() 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 the SQLGETPROP() function to return the property setting for the environment.
cSetting The property setting to query. For available property settings, please see SQLSETPROP().


Return values:

Return Value Description
<expression> The queried property setting
–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
  eGetProp = SQLGETPROP(nStatHand,"ConnectString")
  if type("eGetProp") = "N" and eGetProp < 0
    dialog box [Error Occurred]
  else
    dialog box etos(eGetProp)
  endif
endif


Products

Recital, Recital Server