UPDATE problem

From: Luis Sousa <llsousa(at)ualg(dot)pt>
To: pgsql-odbc(at)postgresql(dot)org
Subject: UPDATE problem
Date: 2005-03-31 13:32:53
Message-ID: 424BFC05.8040001@ualg.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Luis Sousa 2005-03-31 14:13:22 Re: UPDATE problem
Previous Message Goeke, Tobias 2005-03-31 10:14:50 Re: Ignoring the limited user-rights by using ODBC