Open SQL and MySQL

DB Access Module for MySQL User's Guide
Rogue Wave web site: Home Page | Main Documentation Page

2.16 Open SQL and MySQL

The alternative Open SQL interface can be used with MySQL. This section provides some specific details and examples.

2.16.1 Placeholder Syntax

The placeholder syntax for MySQL is simply:

?

Here is an example:

INSERT INTO PICNICTABLE VALUES( ? )

Placeholders are not a portable feature. Different Access Modules use different placeholder syntax. All values are sent as literals upon execution of the SQL statement. Please see Section 2.14, "Input Binding of Data."

2.16.2 RWDBDataCallback and Open SQL

The data callback classes are not supported in the DB Access Module for MySQL. Attempts to use the data callbacks will result in an RWDBStatus::notSupported error.

The Rogue Wave name and logo, and SourcePro, are registered trademarks of Rogue Wave Software. All other trademarks are the property of their respective owners.
Provide feedback to Rogue Wave about its documentation.