Re: Error when I try to update

From: Jean Huveneers <j(dot)huveneers(at)xillion(dot)nl>
To: "'Sistemas C(dot)M(dot)P(dot)'" <sistemascmp(at)redynet4(dot)com(dot)ar>, "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Error when I try to update
Date: 2006-04-27 19:09:00
Message-ID: 20060427194934.801F760009@groupware-01.mx.xillion.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1543" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=770570719-27042006><FONT face=Arial color=#0000ff
size=2>Hi,</FONT></SPAN></DIV>
<DIV><SPAN class=770570719-27042006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=770570719-27042006><FONT face=Arial color=#0000ff
size=2>add&nbsp;'UpdateableCursors=1' to your connect
string.</FONT></SPAN></DIV>
<DIV><SPAN class=770570719-27042006><FONT face=Arial color=#0000ff size=2>For
more informatie search the mailing-list archive on
updateablecursors.</FONT></SPAN></DIV>
<DIV><SPAN class=770570719-27042006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=770570719-27042006><FONT face=Arial color=#0000ff
size=2>Regards,</FONT></SPAN></DIV>
<DIV><SPAN class=770570719-27042006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=770570719-27042006>
<P><FONT face=Arial size=2>Jean Huveneers</FONT> </P>
<P><FONT face=Arial size=2>Xillion ICT Solutions BV</FONT> <BR><FONT face=Arial
size=2>Marktplein 8</FONT> <BR><FONT face=Arial size=2>6243 BR&nbsp;
Geulle</FONT> </P>
<P><FONT face=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(dot)huveneers(at)xillion(dot)nl</FONT> <BR><FONT face=Arial size=2>W:
www.xillion.nl</FONT> </P></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
pgsql-odbc-owner(at)postgresql(dot)org [mailto:pgsql-odbc-owner(at)postgresql(dot)org]<B>On
Behalf Of </B>Sistemas C.M.P.<BR><B>Sent:</B> donderdag 27 april 2006
17:49<BR><B>To:</B> pgsql-odbc(at)postgresql(dot)org<BR><B>Subject:</B> [ODBC] Error
when I try to update<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>I have a Visual Basic Aplication With ODBC Driver
(PSQLODBCA 8.01) and when I tray to update one row It returns this
message:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>&nbsp;<FONT color=#000080>Query-based update
failed because the row to update could not be found.<BR></FONT></FONT></DIV>
<DIV><FONT face=Arial size=2><FONT color=#000080><FONT color=#000000>But when
I execute a SELECT this row
exist!</FONT></DIV></BLOCKQUOTE></FONT></FONT></BODY></HTML>

Attachment Content-Type Size
unknown_filename text/html 2.6 KB

Browse pgsql-odbc by date

  From Date Subject
Next Message Philippe Lang 2006-04-28 07:50:59 Re: PG 8 INOUT parameters & ADO
Previous Message Dave Page 2006-04-27 18:55:17 Re: [COMMITTERS] psqlodbc - psqlodbc: adds to a document.