Re: Error when I try to update

[Jean Huveneers <j(dot)huveneers(at)xillion(dot)nl>]

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!