Received: from mail01.phoenixdsl.com (mail.phoenixdsl.com [216.178.151.24]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f03Fxg794141 for ; Wed, 3 Jan 2001 10:59:42 -0500 (EST) (envelope-from mdavis@sevainc.com) Received: (qmail 58273 invoked by uid 89); 3 Jan 2001 16:00:11 -0000 Received: from unknown (HELO SALLY) (64.32.157.45) by 0 with SMTP; 3 Jan 2001 16:00:11 -0000 Received: by localhost with Microsoft MAPI; Wed, 3 Jan 2001 09:00:10 -0700 Message-ID: <01C07563.93A378B0.mdavis@sevainc.com> From: Michael Davis Reply-To: "mdavis@sevainc.com" To: "'Thomas Lockhart'" , Joseph Cc: "pgsql-interfaces@postgresql.org" Subject: RE: Access using Postgres Date: Wed, 3 Jan 2001 09:00:06 -0700 Organization: Seva Inc. X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/32 X-Sequence-Number: 641 /' does not work in Access. The following does work using VBA in Access with PostgreSQL: DoCmd.RunSQL "update Attributes set [note] = 'can''t' where AttributesID = 31" or DoCmd.RunSQL "update Attributes set [note] = ""can't"" where AttributesID = 31" Thanks, Michael -----Original Message----- From: Thomas Lockhart [SMTP:lockhart@fourpalms.org] Sent: Wednesday, January 03, 2001 7:17 AM To: Joseph Cc: pgsql-interfaces@postgresql.org Subject: Re: Access using Postgres > Does anyone have a utility in access to add backslashes to single quotes for > the odbc connection to postgres? Does Access support the SQL9x standard of using two adjacent single quotes to represent an embedded single quote? PostgreSQL recognizes that syntax in addition to the backslashed form... - Thomas