Region Settings & saving to SQLServer (PB 6.5)

[Nils Hedglin]

Hi,
I have an application that is used both in the US & overseas. I
have changed all our display & editmask formats to force all date
entry & display into the US format. But, it seems the date/datetime
variable values are still in the non-US format. When we try to save a
date to a SQLServer DBMS, it gives the error "Error converting data
type varchar to datetime." I know this is because the DBMS expects a
US date format & is getting a non-US date format. I could set the
registry to the US format at the beginning of the app & set it back to
the original format when it's done, but that would affect all the
other applications running at the same time. At the time of the
updae, I could also check the registry setting & if it's non-US, &
temporarily set it to US & reset it when the update is done. But,
that would require a lot of check to ensure I got all the places in
the code. So, is there a way to force the app to default all
date/datetime variables to the US format?

Thank you very much,
Nils Hedglin
nils.a....@intel.com