Re: Oracle and Parameters
Are you sure the order is causing the error?
What is the wording of the error?
Re: Oracle and Parameters
My personal option is I would add the parameters in the same order they are in the statement (add name then add age). Yes I know it should work either way but I find it always works if I add them in the same order (at least for Oracle)
Re: Oracle and Parameters
Quote:
Originally Posted by GaryMazzone
My personal option is I would add the parameters in the same order they are in the statement (add name then add age). Yes I know it should work either way but I find it always works if I add them in the same order (at least for Oracle)
I agree with this completely, however, I don't believe the order should generate an error, which leads me to believe there is other evil afoot here.
Re: Oracle and Parameters
Quote:
Originally Posted by Hack
Are you sure the order is causing the error?
What is the wording of the error?
Yes, because if you change the order it works well (it's only a very simple example, I get this error in a code that use hashtable to store the parameter but it doesn't preserve the order).
So I only want to know if the name of the parameter it's a big joke and it doesn't meaning nothing and there isn't any relationship with the query parameters.
So I can have a query like : select ... where a=:a and b=:b
and call the add parameter called x and y.
Sorry for my poor english :(
Re: Oracle and Parameters
I don't know if this is the case for Oracle, but for Access database, you must add the parameters in the exact same order as the query string... However, from what you've experiencing, I would say that is the case too.