Postgres Pro
Downloads
Home   >   mailing lists

Thread: Access using Postgres

Access using Postgres

From
"Joseph"
Date:
Does anyone have a utility in access to add backslashes to single quotes for
the odbc connection to postgres?

Thanks Joseph

Re: Access using Postgres

From
Thomas Lockhart
Date:
> 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

RE: Access using Postgres

From
Michael Davis
Date:
/' 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