realtime filtering
Posted: Sun 19 Mar 2006 22:41
i have a table with 1000 records and a MyQuery that
SELECT *... LEFT JOIN....GROUP BY... etc
The result table is 500 tables.
I have a checkbox "[ ] Filtering"
and when user check it or not I want to filter all records that a field is equal to a number like. What Im doing now is:
Query.Filter := 'userid = 2';
Query.Filetered := Checkbox1.Checked;
is this the best way or you suggest another better?
SELECT *... LEFT JOIN....GROUP BY... etc
The result table is 500 tables.
I have a checkbox "[ ] Filtering"
and when user check it or not I want to filter all records that a field is equal to a number like. What Im doing now is:
Query.Filter := 'userid = 2';
Query.Filetered := Checkbox1.Checked;
is this the best way or you suggest another better?