-
Can you try just using the value true (all lowercase letters) for setting the checkbox's value? You also may want to look at the checkbox's properties to make sure the the checked value is true (and not yes, or something like that).
-
You are saying you want to round up to the nearest hundredth, but what you are describing is rounding up to the nearest hundred [no th] so you should be using the second formula I gave you.
You need to type div not /, and you need to add a reference to the field (use the Insert field or group... button), not type the word "field."
-
There isn't a way to change a data connection's address without using code.
Might you be able to make a simple web service that returns the XML based on an input parameter?
That would be a best practice as opposed to putting code inside your InfoPath form to do this.
-
Here's how to do this without using code:
http://www.infopathdev.com/forums/p/9146/32391.aspx#32391
-
Round up to the nearest hundredth -> ceiling(field * 100) div 100
Round up to the nearest hundred -> ceiling(field div 100) * 100
-
That error typically means that the queryXml parameter is not valid (well-formed) XML.
Can you try displaying the queryXml value in a TextBox on your form (just drag the field into your form and display it as a text box) so you can see what value it has when the query is being run, then copy and paste it into this forum?
-
If the trigger fails, then the whole transaction will be rolled back and the insert will fail as a result. Is the trigger attempting to use the CCN field value as an int in some way?
-
Are you entirely sure that it's not the ledger column that's causing the overflow? Is its value in any way related to the CCN field?
The maximum value for an int is 2147483647, which explains why 1234567890 works and 7430500002 doesn't.
-
I don't know the details of your workflow or whether the workflow would work if the documents were in DBXL from the start, but if there is a field in your form that indicates that it has been approved by accounting, you can set up your database mapping so that the data only gets stored into the database when that field takes on a certain ...
-
Can you check that you don't have Work Offline checked under the File menu?