ODBC Oracle and Query Parameter

M

Mike Johnson

Using MS Acces 2002.I have a query parameter which prompts user for a text
value, the ODBC connection was changed a few days ago and I had to refresh
the links. I was using a ODBC connection to Oracle 8.0.5 and now Oracle
8.1.7. since the refresh my queries are not working. If I type in the value
directly into the critria field it works fine. I've tried using the trim$
function thinking it maybe adding leading or trailing spaces to the parameter
but this did'nt work. Does any one have any ideas. Thanks
 
M

Mike Johnson

No error, just no data.

It turned out to be Oracle was expecting the string tobe 15 charaters long
not just 5 so all i had to do was add 10 spaces to the string.
 
Top