I am using MS Access to connect to Oracle7 using ODBC. When I try to run a Passthrough SQL Select statement that contains the variable & in a BETWEEN operator (to prompt the user to enter two values) Oracle returns the error message "ORA-01008 not all variables bound."
If I remove the & variables and tnter the values in the BETWEEN operator, the query runs fine.
I would like to have the users to be able to be prompted to enter the respective values. Does anyone knows a solution to this & variable problem?
Your help will be greatly appreciated.
Received on Tue Aug 22 1995 - 00:00:00 CEST