Open SQL and MySQL
The alternative Open SQL interface can be used with MySQL. This section provides some specific details and examples.
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
“Input Binding of Data.”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.
Executing Cancel in Open SQL
The DB Access Module for MySQL does not currently implement RWDBOSql::cancel() functionality.