Open (OSqlStmt) Method

Applies To

OSqlStmt

Description

This method opens a SQL statement.

Usage

oresult Open(const ODatabase &odb, const char *sql_statement, long options = OSQLSTMT_DEFAULT);

Arguments

odb	The database with which to open this dynaset.
sqlstmt	A valid select SQL statement.
options	Options to be used to create the OSqlStmt instance. Valid options are: OSQLSTMT_DEFAULT OSQLSTMT_NOBIND OSQLSTMT_FAILEXEC

Remarks

The OSQLSTMT_FAILEXEC option forces an error when there is an error executing the sql statement.

Return Value

An oresult indicating whether the operation succeeded (OSUCCESS) or not (OFAILURE).

Example

oresult res;

OSession osess;

OStartup();

osess.Open();

ODatabase odb(osess, "exampledb", "scott", "tiger");

OSqlStmt osql;

osql.Open(odb, "insert into emp(empno, deptno) values (99,10)",

OSQLSTMT_FAILEXEC);