Re: MySQL 5.0 ,DbExpress , Delphi 2006
I have a Delphi application that stores data in a MySQL5 server.
It did work whitout problems.
but now, when I try to save data in database, the date fields (even the data are send correctly) always appear 0000-00-00. An example of the sql command is here:
'INSERT INTO DMOUNTTITULOS (ID,NUMDOCTO,NUMCONTRATO,VALOR,DTVENCTO,DTPAGTO,SITUACAO,TIPOCOBRANCA) VALUES (null,'10000-1','10000','350',10/7/2007,null,'EM ABERTO',null)'
and the stored data on database is here:
HEADER->ID,"NUMDOCTO","NUMCONTRATO","VALOR","DTVENCTO","DTPAGTO","SITUACAO","TIPOCOBRANCA"
DATA ->33,"10000-1", 10000,350.00,"0000-00-00","","EM ABERTO",""
Somebody knows what's happening?
I'll be glad for help!!!
Thank's