RE: Update problem

[David Dindorp]

Carlos Daniel Olivas Barba wrote:
> I have a problem when updating a recordset I got a message that says "The
> row for update can´t 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:
> 
> '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.