Browse by Tags

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

Page 1 of 1 (3 items)

InfoPath Dev