DateFormat error on TxQuery 3.01

GoogleCodeExporter commented 9 years ago

I got a error message :

'1989/05/01' is not valid date.

but on version 2.7 it is OK. 

winxp
delphi 2006

Original issue reported on code.google.com by t...@ms9.url.com.tw on 9 Aug 2013 at 3:43

GoogleCodeExporter commented 9 years ago

how to set the properity of DateFormat to solve the problem ?

Original comment by t...@ms9.url.com.tw on 14 Aug 2013 at 2:42

GoogleCodeExporter commented 9 years ago

Please change either.
A) Edit the default settings: open qFormatsettings.pas
change:
 CxFmtDefaultDateSeparator:Char = '-'; -->  CxFmtDefaultDateSeparator:Char = '/'

 CxFmtDefaultShortDateFormat: String = 'yyyy/mm/dd';

And recompile 
-----------------------------------------------------------
OR
B) Each Txquery component has a Formatsettings property, and then Parser and 
Runtime settings each one has 'DateSeparator' and 'ShortDateFormat' please be 
sure each one has the '/' and the 'yyyy/mm/dd' respectively

Original comment by fdue...@gmail.com on 26 Sep 2013 at 5:36

GoogleCodeExporter commented 9 years ago

Thanks a lot. it works.

Original comment by t...@ms9.url.com.tw on 27 Sep 2013 at 1:16

adem0x / txquery

DateFormat error on TxQuery 3.01 #46