pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Access using Postgres
3+ messages / 3 participants
[nested] [flat]

* Access using Postgres
@ 2001-01-03 11:12  Joseph <lters@mrtc.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Joseph @ 2001-01-03 11:12 UTC (permalink / raw)
  To: pgsql-interfaces


Does anyone have a utility in access to add backslashes to single quotes for
the odbc connection to postgres?

Thanks Joseph




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Access using Postgres
@ 2001-01-03 14:17  Thomas Lockhart <lockhart@fourpalms.org>
  parent: Joseph <lters@mrtc.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Thomas Lockhart @ 2001-01-03 14:17 UTC (permalink / raw)
  To: Joseph <lters@mrtc.com>; +Cc: pgsql-interfaces

> 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* RE: Access using Postgres
@ 2001-01-03 16:00  Michael Davis <mdavis@sevainc.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Michael Davis @ 2001-01-03 16:00 UTC (permalink / raw)
  To: 'Thomas Lockhart' <lockhart@fourpalms.org>; Joseph <lters@mrtc.com>; +Cc: pgsql-interfaces

/' 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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2001-01-03 16:00 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-01-03 11:12 Access using Postgres Joseph <lters@mrtc.com>
2001-01-03 14:17 ` Thomas Lockhart <lockhart@fourpalms.org>
2001-01-03 16:00 RE: Access using Postgres Michael Davis <mdavis@sevainc.com>

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