Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DateFormat error on TxQuery 3.01 #46

Open
GoogleCodeExporter opened this issue May 27, 2015 · 3 comments
Open

DateFormat error on TxQuery 3.01 #46

GoogleCodeExporter opened this issue May 27, 2015 · 3 comments

Comments

@GoogleCodeExporter
Copy link

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
Copy link
Author

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
Copy link
Author

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
Copy link
Author

Thanks a lot. it works.

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant