Searching on double precision fields

Article View: borland.public.cppbuilder.database.ado

Article #1386

Back to borland.public.cppbuilder.database.ado Previous Next

#1386

From: Michele Santucci
Date: Mon, 02 Aug 2004 14:37

22 lines
1671 bytes

I have a field of a record (MS Access MDB file) defined as double precision
I need to query it at runtime using the Filter Adodataset property
If I do something of this kind

double Value;
DataSet1->Filter = "FloatField<=" + AnsiString( double );
DataSet1->Filtered=true;

I always got no result since the decimal separator in my local (italian) is
different from the default one of AnsiString.
And then if Value=10.3 the Filter property is set to "FloatField<=10,3"
If I try to execute the query manually using the original 10.3 notation the
query give the expected results.

-- 
================================
Michele Santucci
Software Development Manager
Celin Avio S.r.l.
Via Fontevivo, 21/M 19100 La Spezia
tel. +39-0187564080
================================

Technical Details

Message-ID: <410e51f0@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!fr.ip.ndsoftware.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,5515ed52d6570b06,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Michele Santucci" <michele.santucci.nospam@nospam.celinavio.it>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Searching on double precision fields
Date: Mon, 2 Aug 2004 16:37:14 +0200
Lines: 24
Organization: Celin Avio S.r.l.
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 62.94.122.178
Message-ID: <410e51f0@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1091457520 62.94.122.178 (2 Aug 2004 07:38:40 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!fr.ip.ndsoftware.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail