InfoPath Dev

Hi Alphamax, Does this happen consistently or only sometimes?  Do you have DBXL installed alongside SharePoint, or are you just trying to pull the form template down from SharePoint?  What has changed since yesterday?  Sorry for the questions, I'm just not sure how to begin debugging your problem.  Maybe the following ...

Hi Steve, You need to look at the XML that is stored in the 2DS.  If you type this SQL directly into the wizard that you use to create the connection to your database, then you will have a view of the XML returned, but if you cannot, then you need to get at it programmatically.  For web services this is accessed via the OutputLocation ...

Hi Steve, The error message is troubling and it might mean InfoPath does not understand the Group By clause.  However, you do have a problem with the query. When using the Group By clause, you must include all columns that you select.  So, in your query, you must either remove ECAM from the select statement, or add it in the group by ...

Hi Ulysse and welcome to the forums! Unfortunately, there is no easy answer to this.  You could try making a command-line utility in C# that takes the data as parameters and then sends the e-mail.  However, this would require your form to be Full Trust. A better way to do it would be to create (or maybe find) a web service that ...

Hi Steve,  Here's the solution:    command += "{select * "; command += "from "; command += "[LaborSummary] as [LaborSummary] "; command += "where (LaborSummary.[CA1] = '" + ca1Prefix + "')} "; command += "append "; command += "({select * "; ...

Looks like David has already written a blog post about this!  Check it out. http://www.infopathdev.com/blogs/david/archive/2007/08/24/implementing-cascading-dropdowns-in-forms-server.aspx

Ouch.  If filters don't work, you will have a tough time getting cascading drop-downs to work.  I'll ask our resident IPFS expert to comment on any possible workarounds.

Maybe I am exposing my ignorance here, but why wouldn't the OnSave event work?

Hi tariks and welcome to the forum! If you are using InfoPath 2007 you can use the Design Checker (located in the Tools menu) to determine the areas of your form with compatability problems. Can you give us an error message or more details on what is broken?