From: Michael Davis <mdavis@sevainc.com>
To: 'Thomas Lockhart' <lockhart@fourpalms.org>
To: Joseph <lters@mrtc.com>
Cc: pgsql-interfaces@postgresql.org <pgsql-interfaces@postgresql.org>
Subject: RE: Access using Postgres
Date: Wed, 3 Jan 2001 09:00:06 -0700
Message-ID: <01C07563.93A378B0.mdavis@sevainc.com> (raw)
/' 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: mdavis@sevainc.com, lockhart@fourpalms.org, lters@mrtc.com
Subject: RE: Access using Postgres
In-Reply-To: <01C07563.93A378B0.mdavis@sevainc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox