Re: multiple parameter sets

Hi Bob,

Thanks a lot.
That clarifies things a bit.

Cheers
Maxime.


-----Message d'origine-----
De : OLEDB_DEV [mailto:[email protected]]De la part de
Beauchemin, Bob
Envoye : mardi 1 avril 2003 10:20
A : [email protected]
Objet : Re: [OLEDB_DEV] multiple parameter sets


Hi Maxime,

Multiple parameter sets are useful to minimize database round trips for
providers that make one DBMS round trip with all of the parameters. For
example, last time I tried this, the SQL Server provider supported multiple
parameter sets but made one database roundtrip per set (no benefit), some
providers (OraOLEDB.Oracle, I believe, was one) used a single roundtrip
regardless of the number of sets benfiting from multiple parameter sets.
There's an example of an ATL class to encapsulate multiple parameter sets at
http://staff.develop.com/bobb <http://staff.develop.com/bobb>  (called
Multiparm IIRC). This should clarify how to code them in OLE DB (by reading
the ATL code), if you want a more detailed explanation, write back.

Cheers,
Bob Beauchemin
http://staff.develop.com/bobb <http://staff.develop.com/bobb>


-----Original Message-----
From: Maxime LABELLE [mailto:[email protected]]
Sent: Thursday, March 27, 2003 12:39 AM
To: [email protected]
Subject: [OLEDB_DEV] multiple parameter sets



Hi all,

I would like clarifications about how to handle multiple parameter sets,
and why they're useful.

ICommand::Execute() accepts multiple parameter sets and a corresponding
accessor
ICommand::SetParameterInfo(), seems to only accept one set of parameters

What is the relationship with these two calls?
Cheers.
Maxime.

You can read messages from the OLEDB_DEV archive, unsubscribe from
OLEDB_DEV, or subscribe to other DevelopMentor lists at
http://discuss.develop.com.

You can read messages from the OLEDB_DEV archive, unsubscribe from
OLEDB_DEV, or subscribe to other DevelopMentor lists at
http://discuss.develop.com.


You can read messages from the OLEDB_DEV archive, unsubscribe from OLEDB_DEV,
or subscribe to other DevelopMentor lists at http://discuss.develop.com.