MDAC 2.5 SDK - OLE DB Providers
OLE DB Provider for Microsoft Jet

ICommandWithParameters

ICommandWithParameters::SetParameterInfo

Specifies the native data type of each parameter. For information about how this interface is implemented, see the OLE DB Programmer's Reference.

If Jet can determine the base type for a parameter, it will coerce the parameter into that type. If Jet does not know the type of the parameter (indicated by a ? with no parameter clause), it makes a best guess. ICommandWithParameters::SetParameterInfo determines the type to be used. If not set, the parameter binding type is used instead.

For example:

parameters p1 long;

The first condition applies to this statement:

SELECT * FROM Tablename WHERE col1=p1;

The second condition applies to this statement:

SELECT * FROM Tablename WHERE col1=?;

The ? parameter binding is supported in the version 4.0 provider.

Long value parameter binding is supported in this provider, either through structured storage interfaces passed to ICommand::Execute or via direct memory bindings.