Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Posts
    1

    Cool Unanswered: IBM SDK Client Column not found

    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

  2. #2
    Join Date
    Aug 2003
    Location
    India
    Posts
    262
    Hi,

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

  3. #3
    Join Date
    Jan 2003
    Posts
    30

    Smile Use 2 apostrophys

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

    will work !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •