RE: Update problem

[David Dindorp]

Carlos Daniel Olivas Barba wrote:
> Hi, I turned on logging, what I got is this:
>
> UPDATE `sweet`.`traspasos` SET
> `FOLIO_TRASPASO`=1,`ORIGEN`='VD',`DESTINO`='JR',`FECHA`='20050912',
> `HORA`='10:39:43',`CODRESPON`='CARLOS',`TERM`='CARLOS',`STATUS`='2',
> `OBSERVACIONES`='ok. guardar para continuar despues'
> WHERE `FOLIO_TRASPASO`=1 AND `ORIGEN`='VD' AND `DESTINO`='JR' AND
> `FECHA`='20050908' AND `HORA` IS NULL
> AND `CODRESPON`='CARLOS' AND `TERM`='CARLOS' AND `STATUS`='2' AND
> `OBSERVACIONES`='ok. guardar para continuar despues' AND
`CONSECUTIVO`=1
>
> I think the error is the column FECHA because the date format is
> "YYYY-MM-DD" and then column HORA in the selected recordset is not
null,
> it's "00:00:00".

Ok, so far so good.  Never seen that problem before.

The manual:
 http://dev.mysql.com/doc/mysql/en/date-and-time-types.html

states that:
 "Zero" date or time values used through MyODBC are converted
automatically
 to NULL in MyODBC 2.50.12 and above, because ODBC can't handle such
values.

which might be a clue.