Subject Re: [firebird-support] trouble with sql statement
Author Alexandre Benson Smith
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
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil