MySQL Forums
Forum List  »  Delphi

Re: MySQL 5.0 ,DbExpress , Delphi 2006
Posted by: Bene Jazem Bandeira Nobre
Date: July 10, 2007 09:48AM

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

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.