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

Arguments	Description
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);