Open SQL and Microsoft SQL Server ODBC

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

2.17 Open SQL and Microsoft SQL Server ODBC

The alternative Open SQL interface can be used with Microsoft SQL Server ODBC driver. This section provides some specific details and examples.

2.17.1 Placeholder Syntax

The placeholder syntax for Microsoft SQL Server is simply:

?

Here is an example:

INSERT INTO PICNICTABLE VALUES( ? )

Placeholders are not a portable feature. Different Access Modules use different placeholder syntax.

2.17.2 Supported Data Types for Input Binding

Please see Section 2.15, "Input Binding of Data," for information on the supported data types.

2.17.3 Stored Procedures and Open SQL

You can use the standard ODBC CALL syntax when executing stored procedures with RWDBOSql.

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.
Contact Rogue Wave about documentation or support issues.