Re: Error when I try to update

From: Jean Huveneers <j(dot)huveneers(at)xillion(dot)nl>
To: "'Sistemas C(dot)M(dot)P(dot)'" <sistemascmp(at)redynet4(dot)com(dot)ar>, "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Error when I try to update
Date: 2006-04-27 19:09:00
Message-ID: 20060427190929.6BDE860009@groupware-01.mx.xillion.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

add 'UpdateableCursors=1' to your connect string.
For more informatie search the mailing-list archive on updateablecursors.

Regards,

Jean Huveneers
Xillion ICT Solutions BV
Marktplein 8
6243 BR Geulle
T: +31 (0)43-3659244
F: +31 (0)43-3659249
M: +31 (0)6-45644357
E: j(dot)huveneers(at)xillion(dot)nl
W: www.xillion.nl
-----Original Message-----
From: pgsql-odbc-owner(at)postgresql(dot)org [mailto:pgsql-odbc-owner(at)postgresql(dot)org]On Behalf Of Sistemas C.M.P.
Sent: donderdag 27 april 2006 17:49
To: pgsql-odbc(at)postgresql(dot)org
Subject: [ODBC] Error when I try to update

I have a Visual Basic Aplication With ODBC Driver (PSQLODBCA 8.01) and when I tray to update one row It returns this message:

Query-based update failed because the row to update could not be found.

But when I execute a SELECT this row exist!

Browse pgsql-odbc by date

  From Date Subject
Next Message Philippe Lang 2006-04-28 07:50:59 Re: PG 8 INOUT parameters & ADO
Previous Message Dave Page 2006-04-27 18:55:17 Re: [COMMITTERS] psqlodbc - psqlodbc: adds to a document.