[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-odbc
Subject:    RE: Update problem
From:       "David Dindorp" <ddi () dubex ! dk>
Date:       2005-09-13 6:58:00
Message-ID: 79F81D5F4790D344B05F489CE2AC8AB72418A0 () dubexdc03 ! dubex ! net
[Download RAW message or body]

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.

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


[prev in list] [next in list] [prev in thread] [next in thread]