InfoPath Dev

User name is available to full trust forms. Otherwise, you will need to use a Web service to accomplish this.

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 ...

Hi Dean and I deeply apologize for the late reply! Were you able to get your forms working with DBXL?  It will definitely be the easiest option for you since all of the web service code is written and thoroughly tested.  I would be happy to do a demo for you if you can schedule some time to talk.

Hi moojjoo and sorry for the late reply! Yes, you can get the returned ID.  I assume you are using a "Submit" data connection in InfoPath, which makes it impossible to see the return statement unless you are using code to submit the data connection.  If you want to add code, look at the .OutputLocation property on the ...

Hi vervoorttom, This is very weird and I have no idea how this would happen.  Maybe it is something strange with the view refreshing.  Did you ever figure it out?

Hi Hans, Depending on the load on the server, the web service might be taking longer than expected to serve the pages.  Also, if it is the first time to load the web service since it was updated, it will take a time to compile the code with the JIT compiler and serve it to the client. You could try increasing the timeout on the web service ...

Hi thunderstorm, Sorry for the delayed response.  Yes, you can do this with code.  Disable the "normal" methods of inserting rows in the table properties dialog, then create a custom button that looks exactly like the links you just disabled.  In the OnClick of that button, create the nodes and insert them into the ...

If they are not in the current row, where are they?  You should be able to reference them with XPath in the Infopath designer.  Can you provide more information on your Main DOM schema and the layout of the table and drop-downs?

Hi Brad, I need to know a little bit more about your schema here, but this seems like it should work without much trouble. If you have a table like this: Item -- Items ----Name ----Rating Where the Items is a repeating table that is populated from the SharePoint list, then you will just bind the 5 option buttons to each of the rating nodes.

Try these links: http://msdn2.microsoft.com/en-us/library/bb250906.aspx http://msdn2.microsoft.com/en-us/library/bb229764.aspx XDocument.View.ExecuteAction( )