Browse by Tags

Correct Filtering of Drop-Down Menu to match DB Entry

I've been working on modifying an InfoPath form and I've run into a problem I can't quite solve. I have a drop-down list which takes values from a data list I have stored in InfoPath. Based on the category selected, only certain parts should appear, and that is working. However, when the...

Posted to Database Integration (Forum) by Michael Francis on 11-24-2008
To return query result in SQL

I am new to infopath. I have a sql db as a secondary data source. I want to send a query with a button and add that generated values as the lookup values to dragdown box. Is that possible?

Posted to Database Integration (Forum) by Jollybaba on 09-08-2008
Retruning all rather than matching query

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...

Posted to Database Integration (Forum) by bmcclue on 07-03-2008
Re: SQL Question(Group By)

I created a SQL query with a Group By clause using Toad for SQL Server. It worked great. The query is below. But when I run the query in InfoPath, I get the error message below. Does that mean InfoPath does not support the Group By clause? I could create a view but I need to pass in variables from the...

Posted to Database Integration (Forum) by m181354 on 02-07-2008
SQL Question(Group By)

I have a SQL statement with a Group By clause that get the following error: The following error occurred: The query method on the Document object failed. InfoPath cannot run the specified query. No query fields have been generated because the specified SQL statement is too complex for InfoPath to parse...

Posted to Database Integration (Forum) by m181354 on 02-07-2008
Re: Shape command with Where clause and Order By clause

That worked great! Thanks Now what about the Order By clause? I get an error with the below code on the Order By clause. command += "{select * "; command += "from "; command += "[LaborSummary] as [LaborSummary] "; command += "where (LaborSummary.[CA1] = '"...

Posted to Database Integration (Forum) by m181354 on 01-31-2008
Shape command with Where clause

Does anyone know how to use the where clause with the shape clause? I get a error on the following code at the Where clause.... command += "{select "; command += "[CA1],[HOUR_DOLLAR],[DIST_NONDIST],[MASTER],"; command += "[PROGRAM],[PROG_DESC],[BUY_OFF_MONTH],[CAM],[ANALYST]...

Posted to Database Integration (Forum) by m181354 on 01-30-2008
Re: Is it possible for InfoPath to select a specific row from a database?

Hi lordpuma and welcome to the forums! Check out this blog post to see how to setup a query filter to return a certain subset of rows from a database: http://www.infopathdev.com/blogs/matt/archive/2006/01/09/Create-a-Multi_2D00_View-Master_2F00_Detail-using-a-Query-Filter.aspx We also have this EnumDB...

Posted to Database Integration (Forum) by Matt Faus on 04-25-2007

Page 1 of 1 (8 items)