
Parameter Queries / Data Enviroment window
Help!!!!!!!!
I am trying to use the new data environment to build queries to SELECT
information from some ORACLE database tables. Here is my problem when I
build my SQL statement, either by hand or with the sql builder I get an
error.
This is my statement and parLastName is the parameter I want to
substitute for.
SELECT FIRST_NAME
FROM USERS
WHERE (LAST_NAME = [parLastName])
The error
The provider cannot derive parameter info and SetParameterInfo has not
been called.
What do I do? I have exhausted the books online and documentation about
parameter queries and cannot find the answer.
Please respond to my email as well as the groups.
Thanks in advance,
Bart Ross