Postgres Pro
Downloads
Home   >   mailing lists

Re: Error when I try to update - Mailing list pgsql-odbc

From Jean Huveneers
Subject Re: Error when I try to update
Date
Msg-id 20060427190929.6BDE860009@groupware-01.mx.xillion.nl
Whole thread Raw
In response to Error when I try to update  ("Sistemas C.M.P." <sistemascmp@redynet4.com.ar>)
List pgsql-odbc
Tree view
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!

pgsql-odbc by date:

Previous
From: "Dave Page"
Date:
Subject: Re: [COMMITTERS] psqlodbc - psqlodbc: adds to a document.
Next
From: Jean Huveneers
Date:
Subject: Re: Error when I try to update