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 20060427194934.801F760009@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
<div><span class="770570719-27042006"><font color="#0000ff" face="Arial" size="2">Hi,</font></span></div><div><span
class="770570719-27042006"><fontcolor="#0000ff" face="Arial" size="2"></font></span> </div><div><span
class="770570719-27042006"><fontcolor="#0000ff" face="Arial" size="2">add 'UpdateableCursors=1' to your connect
string.</font></span></div><div><spanclass="770570719-27042006"><font color="#0000ff" face="Arial" size="2">For more
informatiesearch the mailing-list archive on updateablecursors.</font></span></div><div><span
class="770570719-27042006"><fontcolor="#0000ff" face="Arial" size="2"></font></span> </div><div><span
class="770570719-27042006"><fontcolor="#0000ff" face="Arial" size="2">Regards,</font></span></div><div><span
class="770570719-27042006"><fontcolor="#0000ff" face="Arial" size="2"></font></span> </div><div><span
class="770570719-27042006"><p><fontface="Arial" size="2">Jean Huveneers</font><p><font face="Arial" size="2">Xillion
ICTSolutions BV</font><br /><font face="Arial" size="2">Marktplein 8</font><br /><font face="Arial" size="2">6243 BR 
Geulle</font><p><fontface="Arial" size="2">T: +31 (0)43-3659244</font><br /><font face="Arial" size="2">F: +31
(0)43-3659249</font><br/><font face="Arial" size="2">M: +31 (0)6-45644357</font><br /><font face="Arial" size="2">E:
j.huveneers@xillion.nl</font><br/><font face="Arial" size="2">W: www.xillion.nl</font></span></div><blockquote
dir="ltr"style="MARGIN-RIGHT: 0px"><div align="left" class="OutlookMessageHeader" dir="ltr"><font face="Tahoma"
size="2">-----OriginalMessage-----<br /><b>From:</b> pgsql-odbc-owner@postgresql.org
[mailto:pgsql-odbc-owner@postgresql.org]<b>OnBehalf Of </b>Sistemas C.M.P.<br /><b>Sent:</b> donderdag 27 april 2006
17:49<br/><b>To:</b> pgsql-odbc@postgresql.org<br /><b>Subject:</b> [ODBC] Error when I try to update<br /><br
/></font></div><div><fontface="Arial" size="2">I have a Visual Basic Aplication With ODBC Driver (PSQLODBCA 8.01) and
whenI tray to update one row It returns this message:</font></div><div><font face="Arial"
size="2"></font> </div><div><fontface="Arial" size="2"> <font color="#000080">Query-based update failed because the row
toupdate could not be found.<br /></font></font></div><div><font face="Arial" size="2"><font color="#000080"><font
color="#000000">Butwhen I execute a SELECT this row exist!</font></font></font></div></blockquote> 

pgsql-odbc by date:

Previous
From: Jean Huveneers
Date:
Subject: Re: Error when I try to update
Next
From: "Philippe Lang"
Date:
Subject: Re: PG 8 INOUT parameters & ADO