• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 649
  • Last Modified:

Filter with dataEnvironment

Is it possible to apply a filter on a child recordset using the dataEnvironment?

You can do dataEnv1.rscmdCommand1.Filter = ...

But can you do something like:

dataEnv1.rscmdCommand1.Fields("CommandChild2").Filter...

?
0
jeanfrancoismelancon
Asked:
jeanfrancoismelancon
1 Solution
 
wensinkgCommented:
I'd like to say no.  The reason for having a child record is to filter the child set down according to the current record of the parent.  I see where you are going with this but the only way I have been able to do this is to apply the filter in code.  
0
 
Éric MoreauSenior .Net ConsultantCommented:
You can but you cannot filter all the children in one shot:

set rstChild = dataEnv1.rscmdCommand1.Fields("CommandChild2")
rstChild.Filter ...
0
 
stupendo44Commented:
jeanfrancoismelancon, coukd you get rid of this question? Like give the points to someone?

Stephen
0
 
DanRollinsCommented:
Hi jeanfrancoismelancon,
It appears that you have forgotten to close this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Accept emoreau's comment(s) as an answer.

jeanfrancoismelancon, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you.  DO NOT accept THIS comment as an answer.

EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now