Please enable JavaScript to view this site.

Take Command / TCC Help v. 29

@ODBCQUERY[arrayvar, "query"] : Send a query to a SQL database through the ODBC driver. Returns the string result of the query.

 

arrayvar - An array variable that receives the output of the SQL query. (You must create it with SETARRAY before calling @ODBCQUERY.)

 

"query" - The SQL query to execute.

 

You must have called @ODBCOPEN or ODBC /O "name" before calling @ODBCQUERY.