Thread: Error when I try to update

Error when I try to update

From
"Sistemas C.M.P."
Date:
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!

Re: Error when I try to update

From
Jean Huveneers
Date:
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!

Re: Error when I try to update

From
Jean Huveneers
Date:
<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>