Difference between revisions of "SQLGETPROP()"
From Lianjapedia
Helen.george (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
| Line 9: | Line 9: | ||
==Description== | ==Description== | ||
| − | The SQLGETPROP() function is used to query the property settings for a specified connection or for the current environment. | + | 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>. | The SQLGETPROP() function operates on the data source specified by <nStatementHandle>. | ||
| − | {| class="wikitable" | + | This function is not yet implemented. |
| − | !Keywords||Description | + | |
| + | {| class="wikitable" width=100% | ||
| + | !width=30%|Keywords||width=70%|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. | |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. | ||
| Line 24: | Line 25: | ||
====Return values:==== | ====Return values:==== | ||
| − | {| class="wikitable" | + | {| class="wikitable" width=100% |
| − | !Return Value||Description | + | !width=30%|Return Value||width=70%|Description |
|- | |- | ||
|<expression>||The queried property setting | |<expression>||The queried property setting | ||
| Line 37: | Line 38: | ||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
| − | nStatHand = | + | nStatHand = sqlconnect("awhr") |
if nStatHand < 1 | if nStatHand < 1 | ||
| − | + | messagebox("Cannot make connection", 16, "SQL Connect Error") | |
else | else | ||
| − | eGetProp = | + | eGetProp = sqlgetprop(nStatHand,"ConnectString") |
if type("eGetProp") = "N" and eGetProp < 0 | if type("eGetProp") = "N" and eGetProp < 0 | ||
| − | + | messagebox("Error Occurred") | |
else | else | ||
| − | + | messagebox(etos(eGetProp)) | |
endif | endif | ||
endif | endif | ||
</code> | </code> | ||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| Line 58: | Line 57: | ||
[[Category:ODBC Functions]] | [[Category:ODBC Functions]] | ||
[[Category:SQL Functions]] | [[Category:SQL Functions]] | ||
| + | [[Category:Not_Yet_Implemented]] | ||
Revision as of 10:22, 7 January 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()
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 | 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 = 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
