Skip to content

Latest commit

 

History

History
44 lines (35 loc) · 1.22 KB

DBSQLExecuteDSN.md

File metadata and controls

44 lines (35 loc) · 1.22 KB

DBSQLExecuteDSN

Description

Executes a SQL query the specified DSN. It is not necessary to be registered in the ODBC manager. '''Note!''' The resultSetInstance have to be deleted with call to DBSQLExecuteDelete

FUNCTION DBSQLExecuteDSN(
				dsn                  : DYNARRAY[] of CHAR;
				userName             : DYNARRAY[] of CHAR;
				password             : DYNARRAY[] of CHAR;
				SQLQuery             : DYNARRAY[] of CHAR;
				VAR outColumnCnt     : LONGINT;
				VAR outResultSetInst : LONGINT): BOOLEAN;
def vs.DBSQLExecuteDSN(dsn, userName, password, SQLQuery):
    return (BOOLEAN, outColumnCnt, outResultSetInst)

Parameters

Name Type Description
dsn DYNARRAY[] of CHAR
userName DYNARRAY[] of CHAR
password DYNARRAY[] of CHAR
SQLQuery DYNARRAY[] of CHAR
outColumnCnt LONGINT
outResultSetInst LONGINT

Remarks

CMP: DSN param appears to need a POSIX path

Examples

DBSQL

See Also

DBSQLExecuteGet | DBSQLExecuteNext | DBSQLExecuteDelete

Version

Availability: from Vectorworks 2011

Category