[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

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

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
>

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