Search - InfoPath Dev Sign in | Join | Help InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads Search More Search Options Page 1 of 1 (6 items) Re: The number of calculations used for a single action exceeded the maximum limit Hi Jimmy Thanks for your response, I have read that the error means that a rule is being fired repeatedly and I can see it is but I don't understand why or how I can avoid it. This only ever occurs when there's a carriage return / line feed in the text box. It's also very easy to replicate. Add a text box to a new ... Posted to General (Forum) by Dremandred on 10-21-2010 The number of calculations used for a single action exceeded the maximum limit I have an multi line address field in my form, which I would like to convert to upper case. the formula is: translate(AddressField, "abcdefghijklmnopqrstuvwxyz", "ABCDEFGHIJKLMNOPQRSTUVWXYZ") However if it doesn't seem to like the enter button (CR/LF) and throws the warning: "A calculation in the form has not ... Posted to General (Forum) by Dremandred on 10-20-2010 Re: Reset form fields Finaly after much frustration, I got this code to work correctly. It seems this function needs xmlDoc.validateOnParse = false; before the initialData is loaded into xmlDoc. What I don't understand is why would the DTD validation check on an XML segment change xmlDoc.documentElement to an invalid argument when if the check is ... Posted to Code (Forum) by Dremandred on 09-30-2010 Reset form fields I came across a site that shows how reset the forms data however when trying to impliment this I get an "Invalid procedure call or argument" exception on the final line of code. var initialData; function XDocument::OnLoad(eventObj) { initialData = ... Posted to Code (Forum) by Dremandred on 09-09-2010 Re: Data Connection to a SQL View Thanks, based on your reply I created a new test DB on my PC and I can see the view perfectly. I suspect that I was having SQL permissions issues on our test server. Many thanks. Posted to SQL Database Integration (Forum) by Dremandred on 03-03-2009 Data Connection to a SQL View Hi all I have a view in a SQL database which is the result of a Join between to tables. I would like to connect to this view in InfoPath, however it seems that when I run the Data Connection wizard and connect to the database, InfoPath only allows me to connect to the databases tables. Am I missing something simple to be able to connect ... Posted to SQL Database Integration (Forum) by Dremandred on 03-02-2009 Page 1 of 1 (6 items) Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.