Filter the filter adodc

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ingrid - 24 Mar 2006 12:53 GMT

hi everybody,

i am new in vb so take it easy:)..and dont laugh..

Can we filter the filter with adodc ? In fact i am filtering data with
adodc.RecordSource = "SELECT * FROM tael WHERE "Name='test'"
and it's working, but when I refilter the result generated it dosent execute
on the 1st result but over the hall table.

So can we filter the filter ?

thanks
Ingrid from paris

Reply to this Message

Paul Clement - 24 Mar 2006 15:04 GMT

¤ hi everybody,
¤
¤ i am new in vb so take it easy:)..and dont laugh..
¤
¤ Can we filter the filter with adodc ? In fact i am filtering data with
¤ adodc.RecordSource = "SELECT * FROM tael WHERE "Name='test'"
¤ and it's working, but when I refilter the result generated it dosent execute
¤ on the 1st result but over the hall table.
¤
¤ So can we filter the filter ?

Not really no. But you can include the criteria from both *filters* which would accomplish the same
thing as "filtering the filter".

Paul
~~~~
Microsoft MVP (Visual Basic)

Reply to this Message

Ingrid - 24 Mar 2006 15:36 GMT

merci paul

"Paul Clement" a écrit :

> ¤ hi everybody,
> ¤
[quoted text clipped - 13 lines]
> ~~~~
> Microsoft MVP (Visual Basic)

Reply to this Message

sanjeev nil - 31 Mar 2006 09:35 GMT

Hi
why dont u try a nested query
try filtering your data using first filter and then filter the required
data from it using second filter
eg...
select * from (select * from table where condition=criteria1) where
condition=criteria2

I think this will solve yr problem....

Sanjeev

Reply to this Message

VB Forum / Database Access / March 2006

Filter the filter adodc