irajoel2000 wrote:

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

Hi !

The first thing I would try out is ISQL, if ISQL works ok, then I would
try a 3rd party tool like FlameRobin, if FlameRobin works, then you have
something wrong in you app.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br