From: Date: September 12 2005 12:12pm
Subject: RE: Update problem
List-Archive: http://lists.mysql.com/myodbc/10341
Message-Id: <000001c5b782$78aaad10$22b0cd89@langroup.wmg.warwick.ac.uk>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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 =
=3D
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]=20
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=20
> "The row for update can=B4t be found: Some of the values may changed=20
> since last read", or something like that because the original message=20
> is in Spanish, this happens only when updating rows when updating=20
> 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',=20
> 'bigint(20) unsigned', '', 'PRI', '', 'auto_increment'=20
> 'MOTIVO_CANCELADO', 'varchar(200)', 'YES', '', '', ''

Perhaps try a 'datetime' column.

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