From: Date: September 9 2005 12:36am
Subject: RE: Update problem
List-Archive: http://lists.mysql.com/myodbc/10330
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_000B_01C5B48B.199E0F50"

------=_NextPart_000_000B_01C5B48B.199E0F50
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Sorry, the version of MyODBC is 3.52.11-2

=20

  _____ =20

De: Carlos Daniel Olivas Barba [mailto:carlosolivas@stripped]=20
Enviado el: Jueves, 08 de Septiembre de 2005 01:29 p.m.
Para: 'myodbc@stripped'
Asunto: Update problem

=20

Hi,

=20

I have a problem when updating a recordset I got a message that says =
=93The
row for update can=B4t be found: Some of the values may changed since =
last
read=94, or something like that because the original message is in =
Spanish,
this happens only when updating rows when updating tables with datetime =
type
columns. I=B4m using MySQL-4.1.13a-win32 and MyODBC-3.52.06, here is a =
sample
of the code in vb:

=20

rs.Open "select * from traspasos where folio_traspaso=3D'" & folio & "' =
and
origen=3D'" & s & "'", conexion, adOpenKeyset, adLockOptimistic

If rs.RecordCount =3D 0 Then

        rs.AddNew

Else

        consec =3D rs!consecutivo

End If

rs!folio_traspaso =3D folio

rs!ORIGEN =3D s

rs!DESTINO =3D cmbDestino

rs!fecha =3D format(date, =93YYYY-MM-DD=94)

rs!hora =3D Time

rs!CODRESPON =3D =93carlos=94

rs!TERM =3D =93my-pc=94

rs!status =3D 2

rs!observaciones =3D txtObs.text

rs.Update

rs.Close

=20

Hope you can help me!!

=20

=20

Carlos Olivas.


------=_NextPart_000_000B_01C5B48B.199E0F50--