Difference between revisions of "SQLGETPROP()"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
(7 intermediate revisions by 2 users not shown) | |||
Line 6: | Line 6: | ||
==See Also== | ==See Also== | ||
− | [[SQLCANCEL()]], [[SQLCOLUMNS()]], [[SQLCOMMIT()]], [[SQLCONNECT()]], [[SQLDISCONNECT()]], [[SQLERROR()]], [[SQLEXEC()]], [[SQLMORERESULTS()]], [[SQLPREPARE()]], [[SQLROLLBACK()]], [[SQLSETPROP()]], [[SQLSTRINGCONNECT()]], [[SQLTABLES()]] | + | [[SQLCANCEL()]], [[SQLCOLUMNS()]], [[SQLCOMMIT()]], [[SQLCONNECT()]], [[SQLDISCONNECT()]], [[SQLERROR()]], [[SQLEXEC()]], [[SQLMORERESULTS()]], [[SQLPREPARE()]], [[SQLROLLBACK()]], [[SQLSETPROP()]], [[SQLSTRINGCONNECT()]], [[SQLTABLES()]], [[SQLTRANSACTION()]] |
==Description== | ==Description== | ||
Line 14: | Line 14: | ||
This function is not yet implemented. | This function is not yet implemented. | ||
− | {| class="wikitable" width=100% | + | {| class="wikitable" width="100%" |
− | !width=30%|Keywords||width=70%|Description | + | !width="30%"|Keywords||width="70%"|Description |
|- | |- | ||
− | |nStatementHandle|| | + | |nStatementHandle||Statement handle to the connection. 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()]]. | |cSetting||The property setting to query. For available property settings, please see [[SQLSETPROP()]]. | ||
Line 25: | Line 25: | ||
====Return values:==== | ====Return values:==== | ||
− | {| class="wikitable" width=100% | + | {| class="wikitable" width="100%" |
− | !width=30%|Return Value||width=70%|Description | + | !width="30%"|Return Value||width="70%"|Description |
|- | |- | ||
|<expression>||The queried property setting | |<expression>||The queried property setting | ||
Line 54: | Line 54: | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
− | |||
[[Category:ODBC Functions]] | [[Category:ODBC Functions]] | ||
[[Category:SQL Functions]] | [[Category:SQL Functions]] | ||
− | [[Category: | + | [[Category:VFP Not Implemented]] |
Latest revision as of 12:44, 5 March 2013
Purpose
Query property settings for a connection or the environment
Syntax
SQLGETPROP(<nStatementHandle>, <cSetting>)
See Also
SQLCANCEL(), SQLCOLUMNS(), SQLCOMMIT(), SQLCONNECT(), SQLDISCONNECT(), SQLERROR(), SQLEXEC(), SQLMORERESULTS(), SQLPREPARE(), SQLROLLBACK(), SQLSETPROP(), SQLSTRINGCONNECT(), SQLTABLES(), SQLTRANSACTION()
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>.
This function is not yet implemented.
Keywords | Description |
---|---|
nStatementHandle | Statement handle to the connection. 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 = sqlconnect("awhr") if nStatHand < 1 messagebox("Cannot make connection", 16, "SQL Connect Error") else eGetProp = sqlgetprop(nStatHand,"ConnectString") if type("eGetProp") = "N" and eGetProp < 0 messagebox("Error Occurred") else messagebox(etos(eGetProp)) endif endif