Page 1 of 1
Time format issue
Posted: Mon 10 Aug 2009 14:53
by jputnam
I am using SDAC with Delphi vs 7. I am having a problem with times coming in with the format 12_38_00 instead of 12:38:00. This has been picking up more and more in the last couple months. First, it was just once every couple months, now, it seems to be 2-3 times per week with each user. Any ideas what may be causing this issue? Thanks for the help.
Posted: Tue 11 Aug 2009 10:17
by Dimon
I can not reproduce the problem.
Try to check Regional and Language Options.
Also please, send me a complete small sample to dmitryg*devart*com to demonstrate the problem, including a script to create and fill table.
Posted: Tue 11 Aug 2009 14:53
by jputnam
Like I said, it happens infrequently - Vistas, XP, etc. Basically, I'm just reading a time value from a SQL database, and I get the value returned with _. If I refresh my connection to the DB and try it again, I get : returned to me. All I'm doing is a simple read from the DB - such as table.FieldByName('time').asstring.
Posted: Tue 25 Aug 2009 08:40
by Dimon
I still can not reproduce the problem. To solve this problem we need a sample to demonstrate it.