OracleSQLPreparedStatement

From Xojo Documentation

Revision as of 22:15, 19 October 2010 by Dbrandt (talk | contribs) (added oraclesqlprepparedstatement)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Class (inherits from PrepareSQLStatement)

Used to upcast the result of a call to Database.Prepare by the OracleDatabase class. You must upcast it or you will get a NilObjectException.

Notes

Added the following constants to OracleSQLPreparedStatement that can be used in the BindType method.

Constant
SQL_TYPE_CLOB
SQL_TYPE_DATE
SQL_TYPE_FLOAT
SQL_TYPE_INTEGER
SQL_TYPE_NULL
SQL_TYPE_STRING


It uses the leading colons as markers in the prepared statement, i.e.
"SELECT * FROM Persons WHERE Name = :name"

It requires the use of BindType.


See Also

Database class, OracleDatabase, PrepareSQLStatement classes.