UPDATE problem
От | Luis Sousa |
---|---|
Тема | UPDATE problem |
Дата | |
Msg-id | 424BFC05.8040001@ualg.pt обсуждение исходный текст |
Ответы |
Re: UPDATE problem
Re: UPDATE problem |
Список | pgsql-odbc |
Hi all, I'm using Postgresql 7.3.4-9 Debian binaries and ODBC 8.00.01.01, on Windows 2003 Server. Using ODBC, when the instruction PREPARE "_PLAN586fbb8"(int4, int4) as UPDATE "public"."plano" SET "alunosInscritos"=$1 WHERE "oid" = $2;EXECUTE "_PLAN586fbb8"(40,1676937) I get the following error: ERROR: parser: parse error at or near "=$" at character 84 I changed from "alunosInscritos"=$1 to "alunosInscritos" = $1 and worked. Is there any workaround for this? Also, I thought, probably using an older version of ODBC driver could create a different SQL expression, but, when I tried to uninstall the driver from Add/Remove Programs, everything went ok, but on ODBC Data Sources -> Drivers, the driver still remains there. Then I installed 7.03.0200, but didn't write over the other driver? How can I deinstall the most recent driver and install an older one? Best regards, Luis Sousa
В списке pgsql-odbc по дате отправления: