InfoPath Dev

In manifest.xsf, there is a ruleSets element. If you open manifest.xsf with at text editor, and search for rulesets, you'll find it. The ruleSets element may contain one or more ruleSet elements, which contain one or more rule elements. The rule element will have a caption attribute -- that will be the name you gave your rule when you created ...

The main submit doesn't work?  What is the main submit connection set to submit to, that is, when you look at it in the data connections window (Tools > Data Connections), what information is in the bottom half of the window when you have the main submit connection selected? Usually, if 'Enable Submit' is greyed out in the ...

Hi, Tammy: Welcome to the forum. When you created your form from the data base, do you remember if 'Submit' functionality was enabled? When you walk through the data connection wizard, it will usually tell you on the final screen if there are any issues with the data base that would keep you from being able to submit your data, which is, ...

Hi, Phil: In your mapping for your form, are you trying to shred form data to that Identity column? Open your DocType configuration in DAT, check the Database tab and see if you have a column mapped to the column.....

What is the error? What version of IP are you using? Are you using the 2007 object model or the 2003 object model? (look under Form Options, Programming, and see what the language is -- if you are using 2003, it will say so...)

I think that after changing your columns in SQL, you might have to 'refresh' your dataconnection in the form, so that the form 'knows' you now allow a longer number of characters. Have you tried selecting your main data connection in the Data Connections window, clicking 'Modify' and just walking through it again? Though ...

Often queries get sent twice because the first call is used to generate / validate the schema.....

Is the summary table a read-only thing? If so, couldn't you create a SQL view with the data you want, using aggregate functions like SUM(), and then add another data connection to your form to pull the data back?

Sorry I was slow getting back to you on this. What happens when you try the formula above?