ODBC error

[pandy1]

Hi,

Can anybody help me to the solve the following error:

ODBC error : Error while executing the query.

Error: JOIN/ON clause refers to "employee" which is not part of JOIN.

This report works to be fine. Suddenly im getting this error. It worked well so far. I did not change anything like tables, databse. etc. pl help me.

thanks

 

[synapsevampire]

Try opening the report and selecting Database->Verify Database.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[pandy1]

Verfied. The database is up to date

 

[synapsevampire]

And now it works, or???

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[pandy1]

it is not working, the same problem, the report hangs..

 

[txkitten]

Have you checked the SQL statement? Or have you made any changes to it? They sometime lose the joins when messed with.

Let us know if it works. Contract Report Developer
coogrcub@yahoo.com
Houston, TX