RE: Update problem

[Martin King-Turner]

I have seen a similar problem updating records with datetime columns when
the datetime column contains null values.  If this is the problem, use
phpMyAdmin, command line, or something similar to populate the datetime
column.  I used SQL like: "UPDATE table_name SET datetime_column_name =
NOW();"  Once I'd done this, MyODBC worked fine.  (My sample SQL will update
*all* the records, so you may need a WHERE clause).

-----Original Message-----
From: David Dindorp [mailto:ddi@stripped] 
Sent: 12 September 2005 09:36
To: Carlos Daniel Olivas Barba
Cc: myodbc@stripped
Subject: RE: Update problem


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.

-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=1