Kim,

Works like a charm. Hadn't even thought of doing it that way... :)

Thanks for the suggestion!

-----Original Message-----
From: Kim, Cardyin [mailto:CKim@s...] 
Sent: Monday, October 22, 2001 10:06 AM
To: professional vb
Subject: [pro_vb] RE: Help with ADO please


Here is a repeat posting of information I posted on another thread for you:

There is probably a formal way to append the parameter, but
it currently escapes my mind at the moment.  Here is another way that may be
a few fractions of a milisecond slower but 
will work:

Send the parameter list after the procedure name as if you
were calling it from a query analyzer type program.

ProcSelectTransactionsByCustomer 10, "Testing" 

The only thing you must remember is to make sure that
the commandtype property of your data control is
1 - adCmdText not 4 - adCmdStoredProc.  The control
will parse the text statement, then pass the
parameters as needed to the data source.

Hope this helps,

Cardyin

---------------------------------------
Cardyin Kim
Client/Server & Web Development Analyst
---------------------------------------


-----Original Message-----
From: John Walborn [mailto:JWalborn@m...]
Sent: Monday, October 22, 2001 8:44 AM
To: professional vb
Subject: [pro_vb] Help with ADO please


(Sorry this is a double post, I forgot to change the subject line. It looked
more like a continuation of a previous post. It's actually a new
question...)

All,

This is a really stupid question and I apologize. But a quick answer and no
comments about the inferiority of the ADO Data Control would be
appreciated... :)

What do I need to do in order to append a parameter to the data control when
opening a recordset by way of Stored Procedure? Here's what I've got:

dbcTransactions.CommandType = adCmdStoredProc dbcTransactions.RecordSource 
"ProcSelectTransactionsByCustomer"

But I can't seem to find a way to append a parameter anywhere. Anyone know?

Peace,

J