Re: dealing with quotes?

From Marc Ries: * * 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."" Build your SQL statement replacing all your var's with question marks ( ? ). See in the 4GL manual on page 7-190 ( PREPARE statement ) of the 4.00 ( March 1990 ) Reference Manual 2. That way, you don't have to worry about any quote marks, single or double. Robert Minter |Data Systems Support| \\\\\\_/// Programmer, Software Development | Orange, CA | ( _ _ ) internet: rob@dssmktg.com | Tel: 714.771.0454 | (| ^ |) bangpath: uunet.uu.net!dssmktg!rob| Fax: 714.771.3028 | \\`-'/ I used to not know, now I know I don't know. \\_/