Article View: borland.public.cppbuilder.database.ado
Article #507Re: Float field format mimatching in query
From: Viatcheslav V. Vassiliev
Date: Fri, 26 Aug 2005 07:21
Date: Fri, 26 Aug 2005 07:21
50 lines
2776 bytes
2776 bytes
Setting DecimalSeparator = '.' will use '.' for convertion. Parameters may be added at runtime too. //------------------------------------------ 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:430d93fd@newsgroups.borland.com... > The problem is that I have to create the text of the query at runtime > since its structure depends on how the user fills the 'search form'! > > "Viatcheslav V. Vassiliev" <support@oledbdirect.com> ha scritto nel > messaggio news:430d5e97$1@newsgroups.borland.com... >> The best way is to use parameters. >> >> //------------------------------------------ >> 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:430c51e0@newsgroups.borland.com... >>> >>> How can I manage locale missmatching from database data and query >>> format? >>> >>> -- >>> Michele Santucci >>> =================== >>> Celin Avio S.r.l. >>> Software Dev. Manager >>> -------------------------------------- >>> tel. +390187564080 >>> Via Fontevivo 21/M >>> 19126 La Spezia >>> =================== >>> >> >> > >
Technical Details
Message-ID:
<430ec2e1$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!feeder.xsnews.nl!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mailReferences:
<430c51e0@newsgroups.borland.com> <430d5e97$1@newsgroups.borland.com> <430d93fd@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,f2763377f03f683f X-Google-Attributes: gid10698b,public X-Google-Language: ENGLISH,ASCII From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com> Newsgroups: borland.public.cppbuilder.database.ado References: <430c51e0@newsgroups.borland.com> <430d5e97$1@newsgroups.borland.com> <430d93fd@newsgroups.borland.com> Subject: Re: Float field format mimatching in query Date: Fri, 26 Aug 2005 11:21:40 +0400 Lines: 52 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2527 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 X-RFC2646: Format=Flowed; Response NNTP-Posting-Host: 85.93.138.132 Message-ID: <430ec2e1$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1125040865 85.93.138.132 (26 Aug 2005 00:21:05 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!feeder.xsnews.nl!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail