If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
query ODBC call failed when using a parameter
This is a bit strange but works fine with access tables
but NOT with ODBC. When I create a query using a hard coded value for selection (i.e. = "486-66") my query returns all data. If I try to use a parameter to be inputted (i.e. [imputvalue] I get an ODBC error - call failed. When I use the same approach with an access table it returns whatever value I pass. On my ODBC it does not seem to work. I even tried to use native SQL commands in VBA and can't get it to work. Is it my ODBC setup? is it an incompatibility with Pervasive SQL? if it works with access tables why can't another table work when you can get all recrds or select those with a hardcoded value but not with an inputted value via a parameter entry? Help! I can't go further until I get this resolved. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Hidden files in Ms-Query cause ODBC connect errors or Query is wac | needyourhelp | General Discussion | 4 | July 12th, 2004 09:38 PM |
Convert to a Parameter Query | Al Eaton | General Discussion | 3 | July 9th, 2004 04:05 PM |
Using a query with a replaceable parameter as the source of a control | Hoo | Using Forms | 2 | May 30th, 2004 09:43 AM |
Using a query with a replaceable parameter as the source of a control | Hoo | Running & Setting Up Queries | 1 | May 30th, 2004 07:07 AM |
ODBC CALL FAILED | bikermike | Running & Setting Up Queries | 2 | May 25th, 2004 08:58 PM |