🚀 go-pugleaf

Since this's a Microsoft product it's not very suprising ... damn...

"Viatcheslav V. Vassiliev" <support@oledbdirect.com> ha scritto nel 
messaggio news:431337b7@newsgroups.borland.com...
> If I am not wrong Access will expect dot as decimal separator inside 
> queries not depending on Windows locale.
>
> //------------------------------------------
> Regards,
> Vassiliev V. V.
> http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + 
> ADO.Net
> http://www.oledbdirect.com - The fastest way to access MS SQL Server,
> MS Jet (Access) and Interbase (through OLEDB)
>
> "Michele Santucci" <michele.santucci@celinavio.it> �������/�������� � 
> �������� ���������: news:4312c450@newsgroups.borland.com...
>> I'm not using MS SQL Server but just an Access Database... do you think 
>> is the same ?
>>
>> "Viatcheslav V. Vassiliev" <support@oledbdirect.com> ha scritto nel 
>> messaggio news:430f16de@newsgroups.borland.com...
>>> AFAIK, MS SQL Server always expects dot as decimal separator in queries. 
>>> For time/date, you may use CONVERT function in query, it has parameter 
>>> to specify date style. Other DBMS may work another way.
>>>
>>> //------------------------------------------
>>> Regards,
>>> Vassiliev V. V.
>>> http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + 
>>> ADO.Net
>>> http://www.oledbdirect.com - The fastest way to access MS SQL Server,
>>> MS Jet (Access) and Interbase (through OLEDB)
>>>
>>> "Michele Santucci" <michele.santucci@celinavio.it> �������/�������� � 
>>> �������� ���������: news:430ecb7e@newsgroups.borland.com...
>>>>> Setting DecimalSeparator = '.' will use '.' for convertion. Parameters 
>>>>> may be added at runtime too.
>>>>
>>>>
>>>>
>>>> This's exactly what I would like to avoid since I cannot be sure of 
>>>> what type
>>>> of separator the system locale and the database engine are using.
>>>>
>>>> How can I get what separator or more generally what float format is 
>>>> used into
>>>> a database ?
>>>>
>>>> How can I get what time separator or more generally what time/date 
>>>> format i
>>>> used into a database ?
>>>>
>>>> I tried to set the locale of the application with this:
>>>>
>>>>                 setlocale( LC_ALL, "Italian_Italy.1252" );
>>>>
>>>> but this's not enough ...
>>>>
>>>>
>>>
>>>
>>
>>
>
>