ODBC Call failed

J

Jim

The below query snip works fine WITHOUT the WHERE clause. As soon as
I put in the WHERE clause I get an "ODBC Call Failed" (the tables are
linked)

SELECT .... blah blah blah ...
FROM ((Reinsurance_getClaimData1 INNER JOIN elgemp ON
Reinsurance_getClaimData1.chemno = elgemp.eenmbr) INNER JOIN elgdep ON
Reinsurance_getClaimData1.chemno = elgdep.ednmbr)
WHERE (((elgemp.eeftdt)=99999999) AND ((elgdep.editdt)=99999999))
ORDER BY elgemp.eelnam;
 
D

Dorian

Looks like you might be comparing dates?
If so, I'd change the format of your dates to comply with the database syntax.
-- David
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
J

Jim

Nope - not it. This is a numeric field.

"Women's Version: Give a man a fish and you've fed him for a day.
Teach a man to fish and you have the whole weekend to your self."
 
S

Stefan Hoffmann

hi Jim,
The below query snip works fine WITHOUT the WHERE clause. As soon as
I put in the WHERE clause I get an "ODBC Call Failed" (the tables are
linked)
Linked against what kind of backend?

If it is a different than Access check the data type. Maybe it either
due to rounding issues or an kind of out of range error.


mfG
--> stefan <--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top