Error 3146

  • Thread starter Thread starter Brad Tornberg
  • Start date Start date
B

Brad Tornberg

When I query against a Pervasive SQL table and do not add
a [ ] parameter for the criteria of a query, all of the
records are returned As soon as I enter any parameter [ ]
I receive an ODBC error 3146. Why won't it take an input
parameter. I know this works when I test it against any
access table but it keeps blowing up if i try any select
(except if I hard code the value - i.e. "486-66") The
query wil ask for the paramter to be inputted (this part
seems to work) but once entered it blows up. Help!! What
could be causing this. Driver? Not specifying the correct
index when the file table is first opened? odbc SETTING?
 
Brad Tornberg said:
When I query against a Pervasive SQL table and do not add
a [ ] parameter for the criteria of a query, all of the
records are returned As soon as I enter any parameter [ ]
I receive an ODBC error 3146. Why won't it take an input
parameter. I know this works when I test it against any
access table but it keeps blowing up if i try any select
(except if I hard code the value - i.e. "486-66") The
query wil ask for the paramter to be inputted (this part
seems to work) but once entered it blows up. Help!! What
could be causing this. Driver? Not specifying the correct
index when the file table is first opened? odbc SETTING?
Click to expand...

I will ask one more time, and if you do not
respond, I won't bother you again....

Did you explicitly declare the type of your parameter?

this works:

SELECT * FROM Ptable
WHERE somefield = "486-66";

this does not work:

SELECT * FROM Ptable
WHERE somefield = [Enter parameter];

did you try explicitly declaring type of parameter:

PARAMETERS [Enter parameter] Text ( 255 );
SELECT * FROM Ptable
WHERE somefield = [Enter parameter];
 
Back
Top