From: Date: September 12 2005 10:35am
Subject: RE: Update problem
List-Archive: http://lists.mysql.com/myodbc/10339
Message-Id: <79F81D5F4790D344B05F489CE2AC8AB72417DF@dubexdc03.dubex.net>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Carlos Daniel Olivas Barba wrote:
> I have a problem when updating a recordset I got a message that says =
"The
> row for update can=B4t be found: Some of the values may changed since =
last
> read", or something like that because the original message is in =
Spanish,
> this happens only when updating rows when updating tables with =
datetime
> type columns.

Turn on query logging on your MySQL server using the 'log' option in =
either
my.ini or the mysqld command line.  In the query log, find the UPDATE
statement that fails and examine it's WHERE clause.  If you post it =
here,
also include the data row that you expected the update to match.

> This is the table definition:
>=20
> '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', '', '', ''

Perhaps try a 'datetime' column.