Re: escape single quote in INSERT command
mark carew <markcarew@bigpond.com>
From: "mark carew" <markcarew@bigpond.com>
To: pgsql-sql@postgresql.org
Date: 2002-11-22T21:50:35Z
Lists: pgsql-sql
Hi Hunter,
From my xbase++ program suite, sqlcontext class.
*
cValue := strtran(cValue,['],[\'])
*
Its called masquarading, simply replace the single quote with back_slash
+ single quote.
Regards
Mark Carew
Brisbane Australia