At 10:16 PM 7/04/2008, you wrote:

>I have an embedded database for my application. When i sent my
>application to a customer to test, he was not able to use the
>applicaten as intended. He was having all sorts of problem with the
>database.

That's not exactly *informative*.

>I found out that the 'where' clause in the SQL was not working. All SQL
>statements work but when there is a where clause, the database does not
>return anything.
>Well, I sent the customer a database with all the data in it and still
>he could not see everything. It worked on a different computer and on
>almost all the computer in my office. Does anyone know what is going on?

No, because you haven't told us anything,

>One more thing. On my computer also, if I have an exception raised from
>the database, where clause in the SQL stops working.

If an exception is raised from the database, everything will stop working if you don't handle the exception. Maybe the where clause is invalid and that's what the exception is telling you: who knows if you don't? Did you write the application? or can you hand the problem over to the one who did write it?

You might like to read this article before posting again:
http://www.catb.org/~esr/faqs/smart-questions.html

^ heLen