InfoPath Dev

Hi all,
I have a button query that search for a code into an access db. I need to know if this query return some records or not. If return one or more records I should change view, if no records return I should display a message. Can you help me?
Thanks in advance.
Raoul

This shouldn't be too hard. What language are you using? Below is some psuedo-code for achieving this:

IssueQuery();

NodeList = SecondaryDom.selectNodes( "/my:xpath/my:toNodes" );
if( NodeList.length > 0 )
ChangeView();
else
DisplayMessage();

I hope this helps, if you provide the language that you are using I will be able to provide a more tailored code snippet.

Hi Matt,
thank you for help. Language of code is js, but actually button query start a "query action" with secondary connection , not a "coded query" into onclick event.
I'm waiting for your reply.
Thank you. Raoul

Oh, ok. You should be able to translate the code above into three rules.

Rule 1: no condition, fire query to secondary dom
Rule 2: if rows on secondary dom > 0, change view
Rule 3: if rows on secondary dom = 0, display message

Hi Matt,
thank you for your hint. My problem now is that I don't know what kind of expression I should use to test rows in the rule condition. Can you help me?
Thank you. Raoul