Using Oracle Bind Variables in VB 6 [modified]
-
I'm trying to use parameterized queries in VB6. I am using the Oracle ODBC driver version 9.02.00.00. All of the Oracle documentation states that I should be using a colon (: ) to identify the parameter (i.e. :myparam). However, I've found documentation that says I should be using a question mark (?). My code currently works if I have one parameter in a query (i.e. Select name, id, blah from tablename where id=? ). But if I have two parameters (i.e Select name, id, blah from tablename where id=? and blah=?), I receive the following error message. Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done Of course this message doesn't help me at all. Originally, I was expecting to create queries like "Select name,id,blah from tablename where (id= :Id and blah= :Blah) and then Append parameters to the Command object that is executing the query, but that doesn't seem to work. Any thoughts or ideas are much appreciated. -- modified at 16:11 Thursday 25th May, 2006