Error when I try to update
am 27.04.2006 17:49:23 von sistemascmp
This is a multi-part message in MIME format.
------=_NextPart_000_0029_01C669F9.029C78E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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!
------=_NextPart_000_0029_01C669F9.029C78E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
charset=3Diso-8859-1">
I have a Visual Basic Aplication With =
ODBC Driver=20
(PSQLODBCA 8.01) and when I tray to update one row It returns this=20
message:
Query-based =
update failed=20
because the row to update could not be found.
color=3D#000000>But when I=20
execute a SELECT this row =
exist!
------=_NextPart_000_0029_01C669F9.029C78E0--
Re: Error when I try to update
am 27.04.2006 21:09:00 von Jean Huveneers
--610544-41-1146164972-1972
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Hi,
=20
add 'UpdateableCursors=3D1' to your connect string.
For more informatie search the mailing-list archive on updateablecursors.
=20
Regards,
=20
Jean Huveneers=20
Xillion ICT Solutions BV=20
Marktplein 8=20
6243 BR Geulle=20
T: +31 (0)43-3659244=20
F: +31 (0)43-3659249=20
M: +31 (0)6-45644357=20
E: j.huveneers@xillion.nl=20
W: www.xillion.nl=20
-----Original Message-----
From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.o=
rg]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:
=20
Query-based update failed because the row to update could not be found.
But when I execute a SELECT this row exist!
--610544-41-1146164972-1972
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
>
size=3D2>Hi,
size=3D2>
size=3D2>add 'UpdateableCursors=3D1' to your connect=20
string.
ze=3D2>For=20
more informatie search the mailing-list archive on=20
updateablecursors.
size=3D2>
size=3D2>Regards,
size=3D2>
Jean Huveneers
Xillion ICT Solutions BV
ce=3DArial=20
size=3D2>Marktplein 8
6243 BR =
=20
Geulle
T: +31 (0)43-3659244
=3DArial=20
size=3D2>F: +31 (0)43-3659249
M: +31=
=20
(0)6-45644357
E:=20
j.huveneers@xillion.nl
W:=20
www.xillion.nl
I have a Visual Basic Aplication With OD=
BC Driver=20
(PSQLODBCA 8.01) and when I tray to update one row It returns this=20
message:
Query-based =
update=20
failed because the row to update could not be found.
IV>
000>But when=20
I execute a SELECT this row=20
exist!
--610544-41-1146164972-1972--
Re: Error when I try to update
am 27.04.2006 21:09:00 von Jean Huveneers
>
size=3D2>Hi,
size=3D2>
size=3D2>add 'UpdateableCursors=3D1' to your connect=20
string.
ze=3D2>For=20
more informatie search the mailing-list archive on=20
updateablecursors.
size=3D2>
size=3D2>Regards,
size=3D2>
Jean Huveneers
Xillion ICT Solutions BV
ce=3DArial=20
size=3D2>Marktplein 8
6243 BR =
=20
Geulle
T: +31 (0)43-3659244
=3DArial=20
size=3D2>F: +31 (0)43-3659249
M: +31=
=20
(0)6-45644357
E:=20
j.huveneers@xillion.nl
W:=20
www.xillion.nl
I have a Visual Basic Aplication With OD=
BC Driver=20
(PSQLODBCA 8.01) and when I tray to update one row It returns this=20
message:
Query-based =
update=20
failed because the row to update could not be found.
IV>
000>But when=20
I execute a SELECT this row=20
exist!