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.huveneers@xillion.nl
W: www.xillion.nl

-----Original Message-----
From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org]On Behalf Of Sistemas C.M.P.
Sent: donderdag 27 april 2006 17:49
To: pgsql-odbc@postgresql.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!