Subject trouble with sql statement
Author irajoel2000
I have very strange problem. I've been using firebird with no
problem for some time. I've developed an app that works fine on my
pc. I use firebird 2.0.

When I install the app and firebird software on my client's pc I can
not run the app.

Everytime the app comes to a sql statement that contains a where
clause I get a "dynamic sql error" and the only way out is to abort
the program.

For instance:

sql = "select * from resource" works, but

sql = "select * from resource where zip = '10011'" does not work

The client's pc is actually an apple running Windows. I don't know
if this is the problem, but I'm stymied at this point.

Any suggestions?