🚀 go-pugleaf

In BCB6, the AnsiString(double) constructor internally calls FloatToStr,
which uses the value of the global variable DecimalSeparator to represent
the decimal point.  Try something like this:

double Value;
char OldDecimalSeparator = DecimalSeparator;
DecimalSeparator = '.';
DataSet1->Filter = "FloatField<=" + AnsiString( Value );
DecimalSeparator = OldDecimalSeparator;
DataSet1->Filtered=true;

Mark

"Michele Santucci" <michele.santucci.nospam@nospam.celinavio.it> wrote in
message news:410e51f0@newsgroups.borland.com...
> 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
> ================================
>
>