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.

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.