-
Hello,
I have created an infopath form which uses a webservice. The webservice-request is started by pressing a button. When I received the result, i want to use it. But the problem is the result has single values and also repeating values.
for example:
<Name/>
<Adress/>
<Job/>
<Job/>
With the rules i can set ...
-
thanks.
but where column='123'
'123' is not field name.
-
Hi
Using ‘where#%92 statement to edit SQL the syntax is:
SELECT column FROM table WHERE column operator value
Suppose Column1, column2, Column3 are columns in a table 'Person'
SELECT Column1, column2, Column3 FROM Person WHERE column1='123'
For more detail idea about SQL query view this linkhttp://www.w3schools.com/sql/sql_where.asp
-
Hello,
I am submitting to a Sharepoint Issue list by using the UpdateItems webservice.
Thank you for your fast reply.
Regards,
Monica
-
i have no idea about ''where'' statement in EDIT SQL(data connection).
field1 is infopath text field.
select A, B, C from dbo.sqltable as sqltable
where A=''field1''
this sql is error.
please let this sql correct.
-
Are you using an inline frame or something to render the ASP.NET page in the taskpane?
You will not be able to actually have an ASP.NET page rendered and running in the taskpane.
If you run it in a an inine frame it should work, though.
-
Hi Mary,
Sorry for the delays in responding to you. I guess we need more information about your form. Can you send us the XSN? I'll ask one of our developers to look at it. My guess is that you may bot be setting the namespace in your code and that may be required. Your workarounds are probably not true workarounds. There are many threads that ...
-
Hi Deborah and welcome to our forum from Trinidad and Tobago!
Do new forms work? Unfortunately, schema changes do cause form incompatibilities. We have developed a database accelerator Web service that removes the tight coupling and lets you change the schema on either side without any problems. However, you likely just want to get yours working ...
-
Hi Monica and welcome to our forum!
Are you submitting your form to a database, SharePoint site, or Web service/ You'll likely need to add a button to requery the form and display any new data. That button will have to use a Retrieve Data Connection that you define against the same data source as you are submitting too.
-
Hi Justin,
Well, looks like a very strange construct to have </>. I've never seen that. Can you save the XML, remove that and try to open locally? Does your query not generate the right XML? If yuou can save the XML to your local file system, I'd try to look at the actual text to see if there isn't some strange character (use the command ...