ODBC Call failed

[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;

 

[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".

 

[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."

 

[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 <--