Delphi Filter Help for TcxDBBandedGrid

Posted on 2011-10-26
Last Modified: 2012-05-12
This filter code WOULD work if I was using a regular DBgrid... what do I need to change to get it to work on my DB banded grid?

with gvMilling.DataController.Filter do begin
          Root.BoolOperatorKind := fboAND;
          AddItem(Root,gvMillingJobSchedule,foGreaterEqual, '0', 'Department Start Range');
          fci := Root.AddItemList(fboOR);
          fci.AddItem(Root,gvMillingMil_Total_PercentComplete, foLess, '1', '100%');
          fci.AddItem(Root,gvMillingHoursPerJob, foGreater, '0', 'Not Blank');
          Active := True;

Open in new window

Question by:Bianca
    1 Comment

    Accepted Solution

    Nevermind... figured it out myself!

           with gvMilling.DataController.Filter do begin
              Root.BoolOperatorKind := fboOR;
              AddItem(Root,gvMillingJobSchedule,foGreaterEqual, '0', 'Department Start Range');
              fci := Root.AddItemList(fboAND);
              fci.AddItem(gvMillingMil_Total_PercentComplete, foLess, '1', '100%');
              fci.AddItem(gvMillingHoursPerJob, foGreater, '0', 'Not Blank');
              Active := True;

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
    Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now