From: Date: September 9 2005 6:47pm
Subject: RE: Update problem
List-Archive: http://lists.mysql.com/myodbc/10333
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

This is the table definition:

'FOLIO_TRASPASO', 'bigint(20)', '', '', '0', ''
'ORIGEN', 'varchar(15)', '', 'MUL', '', ''
'DESTINO', 'varchar(15)', '', 'MUL', '', ''
'FECHA', 'date', 'YES', '', '', ''
'HORA', 'time', 'YES', '', '', ''
'CODRESPON', 'varchar(15)', 'YES', '', '', ''
'TERM', 'varchar(20)', 'YES', '', '', ''
'STATUS', 'char(1)', 'YES', '', '0', ''
'A_DISCO', 'enum('Y','N')', 'YES', '', 'N', ''
'FOLIO_REF', 'int(11)', 'YES', '', '0', ''
'OBSERVACIONES', 'varchar(200)', 'YES', '', '', ''
'CONSECUTIVO', 'bigint(20) unsigned', '', 'PRI', '', 'auto_increment'
'MOTIVO_CANCELADO', 'varchar(200)', 'YES', '', '', ''

-----Mensaje original-----
De: Daniel Kasak [mailto:dkasak@stripped]=20
Enviado el: Jueves, 08 de Septiembre de 2005 05:36 p.m.
Para: Carlos Daniel Olivas Barba; myodbc@stripped
Asunto: Re: Update problem

Carlos Daniel Olivas Barba wrote:

>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.
>
Have you got a primary key and a timestamp? Maybe send your table=20
definition ( 'describe traspasos' from the mysql client ).
Actually I'm not sure if you need a timestamp for a VB app, but you need =

one with Access.

--=20
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@stripped
website: http://www.nusconsulting.com.au

--=20
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:
http://lists.mysql.com/myodbc?unsub=3Dcarlosolivas@stripped