• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 655
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

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