Dear all,

I connect my informix database during IBM SDK Client.
If I include my option (field tye is char) with double quote I recieved an error.

-217 column not found in any table or SLV undefined.

So I included it into apostrophe an it works. But I'm looking for a supplier name and some factory has an apostrophe i their name and then an Syntax error occur.

For example:

select * from supplier where name = "Hello" ( error 217)
select * from supplier where name = 'Hello' works
select * from supplier where name = 'Hello's world' Syntax error

Did anybody knows another way to solve this problem ?

Schenker

Hi,

Use a thrid party tool to connect to your database. Winsql is good one -
www.indus-soft.com/winsql

select * from supplier where name = 'Hello''s world'

will work !