The alternative Open SQL interface introduced in DBTools.h++ 4.0 can be used with Microsoft SQL Server ODBC driver. This section provides some specific details and examples.
The placeholder syntax for ODBC is simply:
?
Here is an example:
INSERT INTO PICNICTABLE VALUES( ? )
Placeholders are not a portable feature. Different access libraries use different placeholder syntax.
All the C++ language datatypes are supported for input binding. The following Rogue Wave types are also supported: RWCString, RWWString, RWDate, RWDBDateTime, RWDecimalPortable, RWDBDuration, and RWDBBlob.
You can use the standard ODBC stored procedure syntax when executing stored procedures with RWDBOSql.
©Copyright 2000, Rogue Wave Software, Inc.
Contact Rogue Wave about documentation or support issues.