RE: Update problem

[Carlos Daniel Olivas Barba]

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] 
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 “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.
>
Have you got a primary key and a timestamp? Maybe send your table 
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.

-- 
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: ([phone] / F: ([phone]
email: dkasak@stripped
website: http://www.nusconsulting.com.au

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