vfpoledb decimal separator

[Petr Pavlis]

Hi,
is there any possibility to change decimal separator in vfpoledb
provider? By default it is '.'. I need to set it according to current
windows settings.
thank for answer
Petr

[Anders Altberg]

Send "SET SEPARATOR TO ',' " to VFOLEDB, just like you send a query.

Hi,
is there any possibility to change decimal separator in vfpoledb provider?
By default it is '.'. I need to set it according to current windows
settings.
thank for answer
Petr

[Fred Taylor]

I'm not sure if the OLEDB provider supports this, but try sending SET
SYSFORMATS ON to it like you would a query.
--
Fred
Microsoft Visual FoxPro MVP

Hi,
is there any possibility to change decimal separator in vfpoledb provider?
By default it is '.'. I need to set it according to current windows
settings.
thank for answer
Petr

[Petr Pavlis]

Post by Fred Taylor
I'm not sure if the OLEDB provider supports this, but try sending SET
SYSFORMATS ON to it like you would a query.

Many thanks for your answers, but it is not working. Both 'SET
SYSFORMATS' and 'SET SEPARATOR' are unsupported commands with the
vfpoledb provider :-(.