-
Hello,
Can you try once below statement for creating the view,
Create view newView as
select TOP 5 * from [TABLE] where [FIELD1]='{0}' and [FIELD2]='{1}' order by [YEAR] DESC, [MONTH] DESC";
-
Yes, but for some reason this does not work when I query against a view and no results are returned. However, when I use this same statement for a table, it works wonderfully. Any ideas?
-
Hello,
We don't have any option like take the reference for UI design section in InfoPath. Adding template part also we have insert the same section in all views. After completing the UI changes in one view you have to copy that section from that view and paste in all views.
-
Hello,
Glad to have provided some help in the right direction. We look forward to your participation.
-
Hello,
Here is the link,
http://www.vbcity.com/forums/topic.asp?tid=105907&#RID380236.
You need to follow these steps,
1. Open solution explorer-->Click Project Properties--> Click Security tab-->Tick 'Enable Click One Security settings'.
2. Ensure you have selected 'This is a full trust application', or ...
-
Hi,
One work around is place all the text boxes in the repeating table. And select the same format controls by holding the ctrl button and then set the properties.
-
Hi,
Are there any data connections with ‘Automatically retrieve data check box checked'? If that data connection has more data or the access to that data connection is slow then the form may be opened slowly. But this is for any view not specifically one view.
-
Hello,
Here is another way to do on Save,
If we write OnSaveRequest in code we can avoid saving the form if user click on Cancel using below code,
[InfoPathEventHandler(EventType = InfoPathEventType.OnSaveRequest)]
public void OnSaveRequest(SaveEvent e)
{
e.IsCancelled = e.PerformSaveOperation();
if(e.IsCancelled)
{
e.ReturnStatus = ...
-
Hello,
After taking the web service connection you have to write the below code to submit the form,
try
{
IXMLDOMDocument2 submitDocument = (IXMLDOMDocument2)GetDom("Connection Name", "Web Service Namespace");
setDocumentWithPIDom.selectSingleNode("XPath of xml node in your web service", ...
-
Hi,
In IP 2007 we use XPathNavigator to access the nodes.
In IP 2007, there is a method called InternalStartup(). In this method, write the following code.
XPathNavigator XDocument = this.MainDataSource.CreateNavigator();