ADO Class

[Mark]

Hi,

I am developing a client server application and I was writing a class module
where I can genericly call this class module and execute different queries.
Everythign seem to work fine except with I need to call a store procedure
with parameters. At first I was thinking of storing the paramaters in an
array, then creating them on the class module, but it gives me an error of
type mismatch. IS there anyway to build this class modue. Thanks.

Mark

[Paul Clement]

On 8 May 2002 14:15:57 -0800, "Mark" <vb.@127.0.0.1> wrote:

¤
¤ Hi,
¤
¤ I am developing a client server application and I was writing a class module
¤ where I can genericly call this class module and execute different queries.
¤ Everythign seem to work fine except with I need to call a store procedure
¤ with parameters. At first I was thinking of storing the paramaters in an
¤ array, then creating them on the class module, but it gives me an error of
¤ type mismatch. IS there anyway to build this class modue. Thanks.

Instead of an array why not use a Collection or the Scripting Dictionary object?

You might also want to look at using a ParamArray.


Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

[Tim]

Mark,

You could pass your parameters as an ADO recordset record. This way, you
can pass it across process boundaries if necessary, and you can type each
parameter any way you like. It could be a bit more overhead than you want
if you are going to do a lot of these in a tight loop or something, but
should be pretty handy otherwise. The ADO recordset is self-describing and,
to be more generic, you could put the name of the stored procedure to run in
field zero or something.

Just A Thought,
Tim C.



"Mark" <vb.@127.0.0.1> wrote in message news:3cd9958d$1@10.1.10.29...
>
> Hi,
>
> I am developing a client server application and I was writing a class
module
> where I can genericly call this class module and execute different
queries.
> Everythign seem to work fine except with I need to call a store procedure
> with parameters. At first I was thinking of storing the paramaters in an
> array, then creating them on the class module, but it gives me an error of
> type mismatch. IS there anyway to build this class modue. Thanks.
>
> Mark
>