Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
TimeStamp asString problem |
Fri, Jan 5 2007 4:27 AM | Permanent Link |
"kevanB" | [Delphi2005, DBISam 4.24b6)
Greetings we have being replicating data betweens sites for over 8 months without problem, but after the new year occasional timestamps switched into usa (mm/dd/yyyy) rather than uk( dd/mm/yyyy) format within the same batch of records (this happended to 2nd Jan, 3rd Jan but not yet to the 4th). The data is correct at the source site, both sites haveUK settings. As I said, this happened within the same batch of records, so it appears extremely unlikely that a user had altered their OS date settings at the destination site... Each appliable record is transferred, with each field replicated as a string value, ie SourceSite: data := dataSet.fieldbyname(FIELD).asString; DestinationSite Dataset.fieldbyname(FIELD).asString := Data; I dont have the source files so could anyone point out what controls the TField.SetAsString with relation to TimeStamp fields? Is there a mechanism to overwrite this (ie ignore what the OS settings state?) Cheers KevanB |
Fri, Jan 5 2007 10:51 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Kevan,
<< [Delphi2005, DBISam 4.24b6) >> Just so you know, this is the ElevateDB newsgroup. << I dont have the source files so could anyone point out what controls the TField.SetAsString with relation to TimeStamp fields? Is there a mechanism to overwrite this (ie ignore what the OS settings state?) >> The current locale settings for the OS control timestamp conversions using AsString, specifically the short date format and short time format. Check out "ShortDateFormat" in the Delphi help. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Feb 23 2007 7:03 AM | Permanent Link |
"kevanB" | Problem has been resolved
It appears that a user has been RDP connecting to the server while it was processing an XML file for site to site replication.. "somehow"(tm) the user's RDP session has defaulted to USA rather than UK settings, affecting the export of datetime fields. Learn something new every dasy I guess. KevanB "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message news:90C5DAE1-6F8A-4DB6-8EF7-70336E0BC2FE@news.elevatesoft.com... > Kevan, > > << [Delphi2005, DBISam 4.24b6) >> > > Just so you know, this is the ElevateDB newsgroup. > > << I dont have the source files so could anyone point out what controls > the TField.SetAsString with relation to TimeStamp fields? Is there a > mechanism to overwrite this (ie ignore what the OS settings state?) >> > > The current locale settings for the OS control timestamp conversions using > AsString, specifically the short date format and short time format. Check > out "ShortDateFormat" in the Delphi help. > > -- > Tim Young > Elevate Software > www.elevatesoft.com > |
Fri, Feb 23 2007 7:18 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Kevan,
<< It appears that a user has been RDP connecting to the server while it was processing an XML file for site to site replication.. "somehow"(tm) the user's RDP session has defaulted to USA rather than UK settings, affecting the export of datetime fields. >> That will do it. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Saturday, May 4, 2024 at 09:18 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |