Board index » delphi » getting rid of double-appearing records after filtering

Vic /Bhaskar Beffer

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

getting rid of double-appearing records after filtering

I have a table with a (complex) filter that I set at runtime.
Cause I display only one field of  the remaining records it appears as
though there are double records (which in fact is not so).
How can I get rid of these double-seeming records in my result-dataset
??
maybe OnFilterRecord-event ??

any ideas ?

Bye

Vic

 
Tom

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:getting rid of double-appearing records after filtering


Quote
Vic /Bhaskar Beffers wrote in message <36BA00EC.BA23F...@aoeh.azu.nl>...
>I have a table with a (complex) filter that I set at runtime.
>Cause I display only one field of  the remaining records it appears as
>though there are double records (which in fact is not so).
>How can I get rid of these double-seeming records in my result-dataset
>??
>maybe OnFilterRecord-event ??

>any ideas ?

Use a TQuery component instead of the table. There, you can use the distinct
clause, like

Select distinct Field1 from Table1

This is quicker and offers more options to your filtering purposes.

Tom

Vic /Bhaskar Beffer

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:getting rid of double-appearing records after filtering


Thanks, it works !!
bye
Bhas

Tom schreef:

Quote
> Vic /Bhaskar Beffers wrote in message <36BA00EC.BA23F...@aoeh.azu.nl>...
> >I have a table with a (complex) filter that I set at runtime.
> >Cause I display only one field of  the remaining records it appears as
> >though there are double records (which in fact is not so).
> >How can I get rid of these double-seeming records in my result-dataset
> >??
> >maybe OnFilterRecord-event ??

> >any ideas ?

> Use a TQuery component instead of the table. There, you can use the distinct
> clause, like

> Select distinct Field1 from Table1

> This is quicker and offers more options to your filtering purposes.

> Tom

Other Threads

1. getting the count of records in a filtered query

2. Getting rid of database login prompt

3. Getting rid of the SQL hour glass

4. Answer:Getting rid of the logon prompt

5. Getting rid of ReportSmith login prompt

6. getting rid of Readln;

7. Getting rid of a component in Delphi 4

8. Getting rid of SQL Icon

9. Getting rid of scrollbar in Listbox

10. getting rid of radiobuttons (free doesn't work)