🚀 go-pugleaf

aarghh.... too late to work... :-(

in table:
start period 14.12.2003, end period 11.12.2004, record should show up.
start period 14.12.2003, end period 05.01.2004, record should show up.
start period 05.01.2004, end period 11.12.2004, record should show up.
start period 05.01.2004, end period 10.01.2004, record should show up.
changed line:
start period 14.12.2003, end period 31.12.2003, record should NOT show up.
start period 25.01.2004, end period 11.12.2004, record should NOT show up.



"Richard Plokhaar" <richardplokhaar@hotmail.com> schrieb im Newsbeitrag
news:404e33fa$1@newsgroups.borland.com...
> and a nice typo of course...
>
>  in table:
>  start period 14.12.2003, end period 11.12.2004, record should show up.
>  start period 14.12.2003, end period 05.01.2004, record should show up.
>  start period 05.01.2004, end period 11.12.2004, record should show up.
>  start period 05.01.2004, end period 10.01.2004, record should show up.
>  start period 14.12.2003, end period 31.12.2004, record should NOT show
up.
> <- changed line...
>  start period 25.01.2004, end period 11.12.2004, record should NOT show
up.
>
>
> "Richard Plokhaar" <richardplokhaar@hotmail.com> schrieb im Newsbeitrag
> news:404e31aa@newsgroups.borland.com...
> > Hi, can somebody help me on a tiny problem?
> >
> > I have following problem:
> > I have a table with a PrintOut option (text) and a "start of period" and
> > "end of period".
> > the filter should show all records that have the right PrintOut field
> string
> > and are within the period.
> >
> > Example: user period = 01.01.2004 until 20.01.2004
> >
> > in table:
> > start period 14.12.2003, end period 11.12.2004, record should show up.
> > start period 14.12.2003, end period 05.01.2004, record should show up.
> > start period 05.01.2004, end period 11.12.2004, record should show up.
> > start period 05.01.2004, end period 10.01.2004, record should show up.
> > start period 14.12.2003, end period 11.12.2004, record should NOT show
up.
> > start period 25.01.2004, end period 11.12.2004, record should NOT show
up.
> >
> > in this example various pointers have been replaced to make it more
> generic
> > readable:
> >
> > -----------------------------------------------
> > AnsiString a="01.01.2004";
> > AnsiString e="20.01.2004";
> > AnsiString text;
> >
> > ADOTable1->Filtered=false;
> >
> > text="( PrintOut = "+QuotedStr("SomeText");
> >
> > text+=" ) AND ( ( Periode_start >= '" +StrToDate(a)+"'";
> > text+=" AND Periode_end <= '" +StrToDate(e)+"' )";
> >
> > text+=" OR ( Periode_start <= '" +StrToDate(a)+"'";
> > text+=" AND Periode_end >= '" +StrToDate(e)+"' )";
> >
> > text+=" OR ( Periode_end >= '" +StrToDate(a)+"'";
> > text+=" AND Periode_end <= '" +StrToDate(e)+"' )";
> >
> > text+=" OR ( Periode_start >= '" +StrToDate(a)+"'";
> > text+=" AND Periode_start <= '" +StrToDate(e)+"' ) )";
> >
> > ADOTable1->Filter=text;
> >
> > ADOTable1->Filtered=true;
> > --------------------------------------------------------
> >
> > so basically it is a () AND (  (()AND()) OR (()AND()) OR (() AND ())  )
> >
> > if I write it as () AND () AND () OR () AND () OR () AND () it is
working
> > right for the dates (which makes sense, but is wrong coded)
> > if I write it as () AND (() AND () OR () AND () OR () AND ()) cpp
builder
> > starts to moan around that values are invalid...
> > Can't the filter handle the nested brackets?
> >
> > how to solve it?
> >
> >
> >
> > -- 
> > SIGNALSOFT Rail Consultancy Ltd.
> > Richard Plokhaar
> > 24 Park Road
> > Godalming
> > Surrey
> > GU7 1SH
> > United Kingdom
> > Tel: 00 44 1483 861 320
> > Mobile: 00 44 7867 503 908
> > Email: signalsoft@tiscali.co.uk
> > Private: Plokhaar@tiscali.co.uk
> >
> >
>
>