Search for partial values

[David J.]

I have an InfoPath form linked to a SQL Server 2005 database. The form is to
be used a search, then modify/add form. So, we will say there are 2 sections:
1. Top Section: User can input into any field from the database to run a
search query.
2. Bottom Section: Results display and user can then edit results if desired.

So, I want the user to be able to go into section 1, and let's say they want
to find part number that contain XYZ, they will all display below. Right now
I can't find any options to do that. It's easy to do if I make a VB or SRS
form, but I would prefer to use InfoPath.

My other question is how to add a search range. Say I want to search all
products entered into the system between two dates, how do I create fields to
do so? Everytime I try and make an object in the form, it REQUIRES me to link
to a datasource. Any ideas how to get around this?

Thanks for any help.

 

[Clay Fox]

Hi David.

There are some hacks to get something that would simulate your requests but
I would recommend you investigate using web services instead.
As you have found the standard data connection do not support dynamic
queries. With webservices you can plus much more. If you are working on
enterprise Infopath solutions against SQL that is the way to go and the
intent of InfoPath development.

 

[S.Y.M. Wong-A-Ton]

You can try a trick that someone in the group once proposed. See this post:
http://groups.google.com/group/micr...en&lnk=gst&q="Like"+Queries+#f17dc616bf44e10b

For the date range, you can do something similar to what I did in this
article:
http://enterprise-solutions.swits.net/infopath2003/filter-repeating-table-date-range-rules.htm
You should be able to substitute the Access Query with a SQL Server View.