Skip site navigation (1) Skip section navigation (2)

Re: UPDATE problem

From: "Miguel Juan" <mjuan(at)cibal(dot)es>
To: "Luis Sousa" <llsousa(at)ualg(dot)pt>, <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: UPDATE problem
Date: 2005-03-31 14:26:17
Message-ID: 005501c535fd$99e6e090$07c8a8c0@miguel2000 (view raw or flat)
Thread:
Lists: pgsql-odbc
Hello,

If you already have an existing PsqlOdbc instalation, you just need to copy
the psqlodbc.dll file (version 7.03.0200) in the  "%WINDOWS%\system32\"
folder

Regards

Miguel Juan


----- Original Message ----- 
From: Luis Sousa
To: pgsql-odbc(at)postgresql(dot)org
Sent: Thursday, March 31, 2005 4:13 PM
Subject: Re: [ODBC] UPDATE problem


Any of the snapshots available have this problems solved?

Luis Sousa wrote:

> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>      message can get through to the mailing list cleanly
>
>

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org


In response to

pgsql-odbc by date

Next:From: Tom LaneDate: 2005-03-31 15:08:02
Subject: Re: UPDATE problem
Previous:From: Luis SousaDate: 2005-03-31 14:13:22
Subject: Re: UPDATE problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group