🚀 go-pugleaf

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