Update problem
am 08.09.2005 22:28:46 von Carlos Olivas------=_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--