SQL Yoga version 1.1.0 build 4 :: Visit website

Printer friendly version

command dbconn_retrieveQueryAsData

Executes a SQL query against a database connection and returns the result as data from the selected columns (no cursor).

command dbconn_retrieveQueryAsData pSQL, pBindingsA, @pOutData, [pColDel], [pRowDel]
Parameters
TypeNameDescription
Simple parameter. pSQL SQL query to execute.
Simple parameter. pBindingsA Array of values to bind to pSQL. Key "1" will replace ":1" in the query, etc. You can pass empty.
[Pointer] Write only variable. @pOutData Upon completion the data returned will be in this parameter.
OptionalSimple parameter. [pColDel] Character to delimit columns in the returned text. Default is the default value for revDataFromQuery (tab character).
OptionalSimple parameter. [pRowDel] Character to delimit rows in the returned text. Default is the default value for revDataFromQuery (return character).
OptionalSimple parameter. [pConnName] The name of a Database Connection. The default is the "default connection" for the Database Object.
OptionalSimple parameter. [pDBKey] Database Object connection is associated with. Default is name returned by sqlyoga_getDefaultDatabase().
Return

Empty. Any errors will be thrown: sqlyoga_executesql_err,ERROR