Re: dealing with quotes?
Posted in 1993
Jonathan Leffler — — source: Informix-list mailing list archive (1991-1998)
}From: ries@hqrim.sedd.trw.com (Marc Ries) }Subject: dealing with quotes? }Date: Wed, 8 Dec 1993 16:45:53 GMT }X-Informix-List-Id: <news.5040> } } I there a relatively easy 4gl/FORMs solution to dealing with quotation } marks within character fields so they don't conflict with the } quotation marks used to build an SQL statement? Example: } } [He said, "Hello."] } } becomes either a syntax: } } "He said, "Hello."" Either surround the string with single quotes instead of double quotes: 'He said, "Hello"' or use doubled double quotes: "He said, ""Hello""" Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>