Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parametrized ADO Commands.

Status
Not open for further replies.

Gutes

Programmer
Dec 5, 2001
16
AR
I've big trouble whe assigning parameters to a Command which ActiveConnection property was asigned by a Connection object whithout a DSN (that means, by manually assigning the ConnectionString).
The problem is, that when I try to access a Parameter from the Collection Parameters, it returns an Error.

Do I have to create again each parameter in VB?

for example :
MyCommand.Parameters.Refresh
number=MyCommand.Parameters.Count

number has 0 in its value.

I've tried creating a ADODB.Parameter Object, but the problem is when I simply don't know, how many parameters does the Command have.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top