InfoPath Dev

I'm using a SQL server stored procedure which generates XML to populate a repeating table.  When infopath reads the XML, all data types are showing up as type string which is causing problems in my table with int, dates, etc.   I'm unable to change the data type via the IP UI to override.  How can this be set via ...

Hi, I'm new here and have a simple question about designing forms. We will probably have numerous forms here, and we would like to keep them with the same look in the header and footer. I would like to be able to design a header and a footer in 2 separate files and call them templates. And then, inside my newly made forms, create a ...

I have a Full Trust/Signed form with code that I would also like to map to SharePoint in DBXL 2.4. I've followed the documentation for "How to use full trust form templates" and "How to create SharePoint mapping for a solution that contains code" to accomplished these tasks on separate form templates, but ...

You're welcome :)

I noticed that if you use :DECLARE @return_value int EXEC @return_value = [dbo].[prInsertInvoice] @pInsuredID = 2090, @pDueDate = '05/01/2010' SELECT 'Return Value' = @return_value   as a data source to insert data into sql - you will get 2 rows inserted here...not one...only thing I can see doing it is the SELECT ...

 Duh!  Yes that was easy.  Thanks.

This is Great.  Thanks for posting.  I was curious, how would you modify it to accomodate country codes.  Like +1 (800) 555-1212 

If i publish the form with no user rules and i login as another user i fill in the form and save it, it does not save in the "my expenses" of the loged in user, it saves in the administrator's "my expenses"

Hi Sailor, you can add a new field, and create rules on your option button to set this new field. For example, if 2 is selected in your option button set your new field to "Resolved -2". After that you publish this new field instead of your current option field.  

Hi ZhenYuan, try this: XPathNavigator test = Me.DataSources["DATACONNECTION"].CreateNavigator(); test.SelectSingleNode("dfs:myFields",Me.NamespaceManager).DeleteSelf();