InfoPath Dev

Here's what I've used: Go to the data connection for a sql table.  Click on modify table and edit sql.  You will see the sql that has been generated when the data connection was established.  You can edit the sql.  To get unique values for a pull down.  I substituted the following sql statement: select ...

There are a lot of restrictions.  Go to the file page in InfoPath and run the "Design Checker" and that will tell you if it is compatible with the web. Alternatively can you do a link by copying the full address of the form library where you would normally click on add, and change AllItems.aspx to template.xsn.

You need to do it using code behind the submit button.  Below is what I did in jscript.  Changing it to C+ should be easy.    function CTRL21_7::OnClick(eventObj) {     var error_message = ...

We had the same certificate error when going from 2003 to 2010.  The short answer is no.  As an aside, if you access any other office file (.docx,.xlsm, etc.) from your form,  that file needs to be in a trusted location.  Also, I'm going directly to sql, which has been working ok in 2010, but I would like to move to web ...

We had a similar problem.  Does your infopath apps have security certificates?

We have also upgraded to office 2010.  I found that the jscript code will work without any problems.  In order to change the code, you need to do the following:  Directions for changing Jscript code or changing xml code in an InfoPath 2010 program.The template.xsn file is a compressed file that contains multiple xml files.  ...

We had the same problem when we went from xp and office 2003 to win7 and office 2010.  Another element is that we use sql extensively.  In office 2010, there is much more authentication going on.  In any office that doesn't have their own domain controller, our users may not get a response fast enough when infopath ...

Thanks for the reply.  This is my 20th? Infopath application using sql and I haven't had any problems yet.  It appears to only be a problem in office 2010 and Win7.  I've requested a MS expert to come in and that will probably happen in the next couple of weeks.  Where can I find a good primer on using web services to ...

I have an application running in InfoPath 2010.  It has a very complicated relational setup and more than 50,000 current records.  I recently started having a problem where data in fields change when I submit them to the sql 2008 database.  You can see it happen.  Also, some recurring sub records are added automatically.  ...