I'm using ado with vb6. I use a command object and add parameters in a loop by iterating through a collection object. if I change the order of the parameters in the sproc to match the order that they're added when looped through in the collection, everything's ok. Otherwise I get a 'cannot convert varchar to int' error when executing the command object. I saw something in another forum about using the '@' symbol, otherwise it just sends them in in order. I tried that, but it still didn't work.
BlackDice
BlackDice
