🚀 go-pugleaf

"Mark Guerrieri" <mguerrieri@cmsgrp.com> wrote in message
news:40d9f02c$1@newsgroups.borland.com...
> Can you post your exact code?  What components are you using and what
> property are assigning the filter string to?
>
> Mark
>
> "Cary Letsche" <CLetsche@agfirst.com> wrote in message
> news:40d9878d$1@newsgroups.borland.com...
> > I am having a terrible time getting the IDE to accept a Filter String
> > comparing a TDate field from IDE (dBase).  I'm using CBuilder3.0 Pro.
> > Here is basically what I want to compare:

Thanks Mark, here is the actual code:
void __fastcall TMainForm::DateRptButtonClick(TObject *Sender)
{
    String filterstr;
    TDate bdate,edate; // variables to hold TDate data

    GetDateForm->ShowModal(); // get the dates from the user
    // Convert the String Dates into TDate memory variables
    bdate = (double)StrToDate(GetDateForm->fBdate->Text);
    edate = (double)StrToDate(GetDateForm->fEdate->Text);

    // Now we have everything, put the filter string together
    // EFFDATE is a TDate Field in my dBase table
    // It would normally be accessed with Data->LatsEFFDATE->Value,
    // but not here

    filterstr = "(EFFDATE >= " + (double)bdate + ") AND (EFFDATE <= " +
(double)edate + ")";
    // Actual string looks like "(EFFDATE >= 01/01/2004) AND (EFFDATE <=
01/31/2004)"

    Data->Lats->Active = false; // turn off the table
    Data->Lats->IndexName = "EFFDATE"; // Set the Index to EFFDATE order
    Data->Lats->Filter = filterstr; // assign the string above
    Data->Lats->Filtered = true; // turn on filtering
    Data->Lats->Active = true; // turn the table back on

    // Compiles but get the following error: Invalid Fileter Expression
    // Character, "/"
    // If I use the expression "EFFDATE >= " + (double)bdate + ")" ect.,
    // compiler balks about illegal use of floating point.  What gives?

}