Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 7 of 7 total |
Developing for different computer DATE formats |
Thu, Dec 18 2008 9:17 PM | Permanent Link |
Pat | Hi all,
DBISAM v4, D6, XP My app works very nicely on my XP development machine (and a couple other machines) with the date setting of dd/mm/yy in the Control Panel | Regional.... I wanted to test it with Vista. I loaded a VMware clean Vista install, and my app, and now its broke It does not like the default setting of M/d/yyyy that Vista gives it (I remember now I had to change this date setting on new XP installs also). So the obvious question is HOW do I develope my app to factor in the various flavours of the date settings that users have? Do I use the ANSI something for every occurance of the DATE in my application? Regards, Pat |
Fri, Dec 19 2008 2:18 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Pat
Why not just set ShortDateFormat and LongDateFormat? Roy Lambert [Team Elevate] |
Fri, Dec 19 2008 2:28 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Pat
Just seen your post on the CodeGear forums and it adds an extra dimension. My answer was purely for display purposes. For database if using sql I'd follow the suggestion on using parameters or, as with filters, use the built in functions in the engine eg AnsiDateToStr , AnsiDateTimeToStr etc Roy Lambert [Team Elevate] |
Fri, Dec 19 2008 4:18 AM | Permanent Link |
Pat | Hi Roy,
>For database if using sql I'd follow the suggestion on using parameters or, as with filters, use the built in functions in the engine eg AnsiDateToStr , AnsiDateTimeToStr etc Thanks for that Roy >Just seen your post on the CodeGear forums Yeah, first time I visited there for about 6 months. I pointed my newsreader (Agent) to forums.borland.com as usual but it could not connect. I did some scratching around and found https://forums.codegear.com/category.jspa?categoryID=15 Roy do you know what the replacement for "forums.borland.com" is? I would like to use Agent instead of the web browser. Pat |
Fri, Dec 19 2008 4:33 AM | Permanent Link |
Pat | >Roy do you know what the replacement for "forums.borland.com" is? I
>would like to use Agent instead of the web browser. Cancel that I just tried forums.codegear.com again & I got all the goodies. I tried that addy earlier and only got DelphiPrism newsgroups, ah well, not to worry. |
Fri, Dec 19 2008 2:16 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Pat,
<< I wanted to test it with Vista. I loaded a VMware clean Vista install, and my app, and now its broke >> What part is broken ? DBISAM 4.x uses ANSI date/time formatting for everything, so it will be unaffected by changes in the OS regional settings. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Dec 19 2008 6:11 PM | Permanent Link |
Pat | Hi Tim,
><< I wanted to test it with Vista. I loaded a VMware clean Vista install, >and my app, and now its broke >> > >What part is broken ? DBISAM 4.x uses ANSI date/time formatting for >everything, so it will be unaffected by changes in the OS regional settings. It looks like I (as the user) was breaking it. In the reports I was keying in DATE criteria in dd/mm/yy format and not respecting the operating system's M/d/yyyy format. If I keyin M/d/yyyy format my report works OK. I guess I hit the panic button when Vista took me out of my comfort zone (at least I learned a bit more in troubleshooting). Pat |
This web page was last updated on Wednesday, April 24, 2024 at 11:07 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |