Difference between revisions of "SQLDATASOURCES()"
From Lianjapedia
Yvonne.milne (Talk | contribs) (Created page with "==Purpose== Function to return a comma separated list of the 32-bit ODBC System DSNs ==Syntax== SQLDATASOURCES() ==See Also== SQLCANCEL(), SQLCOLUMNS(), SQLCOMMIT(...") |
Yvonne.milne (Talk | contribs) (→Description) |
||
Line 9: | Line 9: | ||
==Description== | ==Description== | ||
− | The SQLDATASOURCES() function is used to return a comma separated list of the 32-bit ODBC System DSNs | + | The SQLDATASOURCES() function is used to return a comma separated list of the 32-bit ODBC System DSNs on the current machine. |
==Example== | ==Example== |
Latest revision as of 07:53, 4 March 2019
Contents
Purpose
Function to return a comma separated list of the 32-bit ODBC System DSNs
Syntax
SQLDATASOURCES()
See Also
SQLCANCEL(), SQLCOLUMNS(), SQLCOMMIT(), SQLCONNECT(), SQLDISCONNECT(), SQLDRIVERS(), SQLERROR(), SQLEXEC(), SQLGETPROP(), SQLMORERESULTS(), SQLPREPARE(), SQLROLLBACK(), SQLSETPROP(), SQLSTRINGCONNECT(), SQLTABLES(), SQLTRANSACTION()
Description
The SQLDATASOURCES() function is used to return a comma separated list of the 32-bit ODBC System DSNs on the current machine.
Example
astore(aDSNs,sqlDataSources(),",") ? aDSNs Array (refcnt=1) ( [1] = Excel Files [2] = MS Access Database [3] = dBASE Files [4] = lianja_mssqltest [5] = Lianja_Southwind [6] = lianja_mysqltest )