From: Date: September 8 2005 10:28pm
Subject: Update problem
List-Archive: http://lists.mysql.com/myodbc/10329
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0009_01C5B479.3DF13E70"

------=_NextPart_000_0009_01C5B479.3DF13E70
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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_0009_01C5B479.3DF13E70--