-
If your query returns multiple rows, then max(@ID) will select the highest ID value. nz(@ID) would return the value of ID in the first row of the query results.
Does your SharePoint list query retrieve several rows of results, or just one?
-
I got it now. Here what i have done.
1.After converting to udcx file. Download a copy of it and stored it locally
2.Delete the original one from the data concection library
3.Upload the one you saved locally and at this point the file is ok (al info are there) and the approve/reject option is there now.
-
-
I don't really understand your problem, but if you want your dropdown to hide the same values in the section, then open yor form in design view, right click on the dropdown list and select properties. On the bottom of the properties window, you should see a checkbox "Show only entries with unique display names". Make sure it is ...
-
Bad things about the rules above is that when you change the date for the first time it works but if you change again, lets say you first pick a Friday and then you want to pick a Thursday, nothing happens. If you pick a date for the next month, it works.
-
substitute the quotes and minus sign with the one on your keyboard. Infopath does not like the way it is formated when you copy and paste from the Web page. You have to delete the quotes and minus sign and re-type them.
Mike
-
Thank you, Patrick..
: )
-
I created a form template with a web service and a submit button. The submit button called the web service to do somework on the form. The form and web service worked fine. Then I converted the web service into UDCX file and here are some of the problem i have seen:
The newly created udcx file has been automatically checked out and ...
-
In fact, the onChanged event of a repeating section (or table) will be triggered when ANY of the fields inside it is changed. So if you change your selection in the first row of your repeating section, the calculation will trigger. But you need to put a relative XPath instead of the full XPath (eg : \my:dropdown instead of ...
-
thanks for the help!
i got it working finally!!
instead of using CInt, i used CDbl and i worked with the decimal values!
thanks again