Quoting issue from ODBC
От | Brad White |
---|---|
Тема | Quoting issue from ODBC |
Дата | |
Msg-id | CAA_1=93z4oEXKQ9GHtDkEQhEe5r39C8YSDMpwO8OHmSBreXw3g@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Quoting issue from ODBC
Fwd: Quoting issue from ODBC Re: Quoting issue from ODBC |
Список | pgsql-general |
Front end: Access 365
Back end: Postgres 9.4
(I know, we are in the process of upgrading)
Back end: Postgres 9.4
(I know, we are in the process of upgrading)
I'm getting some cases where the SQL sent from MS-Access is failing.
Looking at the postgres log shows that the field names and table names are not being quoted properly.
It has been my experience that Access usually does a better job at converting the queries than I would have expected, but not in this instance.
For example
Access: connection.Execute "UPDATE [" & strTable & "] SET [" & strTable & "].[InsertFlag] = Null" _
& " WHERE ((([" & strTable & "].[InsertFlag])=" & lngCurrUID & "));", , adCmdText Or adExecuteNoRecordsNote that InsertFlag is bracketed the same way in both instances.
PSQL: UPDATE "public"."Orders" SET InsertFlag=NULL WHERE ("InsertFlag" = 166 )
Note that InsertFlag is quoted once but not the other time.
Of course this gives the error: column "insertflag" of relation "Orders" does not exist at character 35.
Any suggestions on where to look?
Thanks,
Brad.
Brad.
В списке pgsql-general по дате отправления: