adoQuery Filter

Question

Could you please provide me with a simple example of using the Filter Property of ADOQuery in Delphi 7?

Thanks.

score 3 · Accepted Answer · edited May 23 '17 at 12:18

3

as looking into histroy question i got into this question:

which said by RRUZ that:

AdoQuery1.close;
AdoQuery1.filter := 'your condition goes here';
AdoQuery1.filtered := true;
AdoQuery1.Open;

Edit: or just :

AdoQuery1.filter := 'your condition goes here';
AdoQuery1.filtered := true;

edited May 23 '17 at 12:18

Community

answered Oct 17 '10 at 15:30

none

3

It is not necessary to close, set the filter and then open the query. Just set the condition (e.g. somefield=1) even on an open query and then Filtered := true;. – avenmore Oct 17 '10 at 21:35

1 Answers1