It is ok, it include additional ' because the DFM format also uses '
to define the string literal.

In the IDE | Properties, I can see:

SELECT * FROM HERD WHERE HTYPE=0 AND CODI='372'

I am sure that all users are using the correct client for the FB
server, some installations have been made in new and clean computers.
In any case, this problem also arises in local computer.

You can test it in your computer.

Thank you for your help

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> At 08:13 AM 31/05/2004 +0000, you wrote:
> > SQL.Strings = (
> > 'SELECT * FROM HERD WHERE HTYPE=0 AND CODI=''372''')
>
> This statement looks weird. Are you really storing apostrophes in
this
> column CODI?
>
> Are you sure all of your users are using the correct client for the
> Firebird server version you are using?
>
> Helen