🚀 go-pugleaf

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 ...
>>>
>>>
>>
>>
>
>