InfoPath Dev

Hi Greg, I went ahead and created a view and bound it to my form: CREATE VIEW [Top500Products] AS SELECT TOP(500) product_id,SHORT_TEXT,selected FROM Products but then I thought, hey, that's not gonna give me what I want. My user types in a SHORT_TEXT, and the query issued will look like this: SELECT ...

Hi all, in my form I am trying to limit the number of hits the user gets when searching for products. As my product db will contain 40000+ entries, I do not want to display those in my form if the user doesn't limit the search results. So, I went ahead and followed this guide http://support.microsoft.com/kb/826992 to enable wildcards in my ...

Got it, I guess you just have to have a coffee break once in a while ;-)     var allTheNodes = objSource.selectNodes("//d:Products"); for (var i=0; i<allTheNodes.length; i++) {Item = allTheNodes.item(i);         objSource.removeChild(Item); } 

Hi all, after digging into the various online sources my first infopath form does nearly everything I wanted it to do, except for one thing. My for mallows the user to seearch for products from a database. The query result list (repeating table RT1) allows the user to select one or more products, press a button upon which the selected rows will ...

Hi Clay,   thanks for the quick response. If I get you write, I need to add an additional column to my Products table called "Selected" or something. Then I need to write the "X" to the database ? Could you paste your XPath search string to get the row which the user selected. I am struggling with the XPath syntax (or. ...

Hi all, I have a form which allows the user to search in a products db. The query result is currently displayed in a repeating table control. Now, what I want to do is: - Let the user select one of the lines of the repqeating table control - Let the user press a button "add", upon which I want to programmatically get the values of ...

Hey,  thanks  for the quick response. I already ordered the MS InfoPath book; I guess I need to invest a little more time to understand the IP concepts, so far I only followed the path of least resistance and maximum intuitivity ;-) It is good to hear that my task is feasible. Cheers, moestavern

Hi all, I am totally new to Infopath, and I am actually not quite sure if InfoPath is actually able to help me solve my problem. So let me outline what I want to do, and maybe you can comment on the feasibility in Infopath. I have a local SQL Server Express which holds one database table "Products". My form should be ...