Re: Retruning all rather than matching query

Clay Fox — Mon, 07 Jul 2008 05:03:35 GMT

Hi.

In InfoPath you enter a value into a query field and it will return only the records which math the query data.

So in your form set ID for example to 1 and then run the query.

The only record returned will be the record with ID1, if it exists.

I am guessing that is your issue.

I alsways recommend createing a new form, based on your tables and then just drag all the fields onto your view and use the query button to play with it.

Retruning all rather than matching query

bmcclue — Thu, 03 Jul 2008 07:31:12 GMT

Hello,

I am new to InfoPath (using the 2003 version) and I have been trying to create master/detail pages from an existing SQL server DB. In trying to learn how to do this I have been using the wonderful example posted by Matt Faus posted at location http://www.infopathdev.com/blogs/matt/archive/2006/01/09/Create-a-Multi_2D00_View-Master_2F00_Detail-using-an-InfoPath-Data-Filter.aspx.

The problem I have is that, not matter how many times I try from scratch to recreate this I can not get the query to return only the specific search critieria. Each time I run the query it returns all records. From my previous experience with Dreamweaver this problem usually pointed to a mismatch in the binding between the entered value adn the returned unique ID, but I can not see what is wrong with this (or what I am doing wrong).

Can anyone assist with the most likely solution or can you point me in the direction of other 'dummies guides' to creating master/detail pages in InfoPath please?

Thanks

bmak

SQL Database Integration

Re: Retruning all rather than matching query

Retruning all rather than matching query