Обсуждение: Access using Postgres

Поиск
Список
Период
Сортировка

Access using Postgres

От
"Joseph"
Дата:
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

От
Thomas Lockhart
Дата:
> 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

От
Michael Davis
Дата:
/' 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