I want to use the DataEnvironment interface for my project devoloping.
I am using VB6.0 SP5 and Oracle 8 with Microsoft OLE DB Provider for Oracle.
Everything works fine till I have to use the "named parameters" for
When I used "SQL Builder" I set the Prefix Caracters to "[" and the Sufix
Caracters to "]" then in the Criteria column of a field i wrote LIKE [Des]
("Des" intended to be the name of the parameter). The SQL command changed to
"Select .... Where ... LIKE [Des] " but when I made RUN SQL I got out an
error message telling me "The provider connot derive the parameter
information and SeParameterInfo has not been called !"
and the Parameters page is empty.
If get out from the Query designer(saving the query) and get into again the
Prefix Caracters and the Sufix Caracters are blank.
If I manually write (without using SQL Builder) the query using an unnamed
parameter "?" then I can see a new parameter added to the "Parameters" page
but the "?" is not a named parameter.
I really don't know where I am wrong . Can someone give a hint?