-
One table is always so much easier to work with!
Unfortuntately, I don't have a deep knowledge of SQL syntax. I'm still learning. The first question I would have is whether your SQL statement works in a Query window inside SQL Server Management Studio? If so, then it is possible that InfoPath just can't handle that complexity--or ...
-
You can directly edit the SQL Command in your SQL data connection to add your WHERE clause.
-
If you inserted a Picture control into your view, and set it up to be saved "As A Link", then all you need to do is update the value of the node to which the control is bound. Set it to the path of a valid image, and the image in the view will change to that image.
For example, set the node value to something ...
-
Your form needs to be full trust to use that feature via code:
thisXDocument.View.Export("C:\\MyView", "MHT");
-
You can do this -- in the reverse. In otherwords, you can't force a required field to no longer be required... but you can use custom data validation (see field properties dialog) to make a non-required field now required. You will need to use this approachto accomplish what you want to do.
-
Maybe session cookies are turned off in ASP.NET?
-
The problem is that control-to-DOM binding is different for a section and a repeating section.
Sometimes when I get stuck like this I like to get down to the metal and do things manually. If you are so daring, I would create a separate blank form, add in a section and a repeating section. Add a node in each. Extract the form files and compare the ...
-
You can use the round() function. Keep in mind that round() only works to whole numbers, so to get your 2 decimal places, you have to do some multiplying and dividing by 100:
round(my:field1 * 100) / 100
-
Cool! Glad you got it figured out. What was your solution?
-
Thanks for sharing this David... as I do make use of named node properties frequently enough... its good to know this ahead of time so that I'm not bitten by it!