DBOpenSQLStatement

LabWindows/CVI SQL Toolkit 2.3 Help

Edition Date: August 2015

Part Number: 370502D-01

»View Product Info
Download Help (Windows Only)

int DBOpenSQLStatement (int statementHandle);

Purpose

Opens an SQL statement that you created with DBNewSQLStatement.

Example

hstmt = DBNewSQLStatement (hdbc, "SELECT UUT_NUM, MEAS1, \

MEAS2 FROM TESTRES");

resCode = DBSetStatementAttribute (hstmt, ATTR_DB_STMT_CURSOR_TYPE,

DB_CURSOR_TYPE_FORWARD_ONLY);

/* Set other attributes. */

...

resCode = DBOpenSQLStatement (hstmt);

...

resCode = DBCloseSQLStatement (hstmt);

Parameters

Input
Name Type Description
statementHandle int Handle to the SQL statement that DBNewSQLStatement returned.

Return Value

Name Type Description
resultCode int Result code that DBOpenSQLStatement returns. This function returns the set of result codes listed in the LabWindows/CVI SQL Toolkit Error Codes topic in the LabWindows/CVI SQL Toolkit Help. Use DBErrorMessage to obtain the text of the error message.

WAS THIS ARTICLE HELPFUL?

Not Helpful