Web Services and Infopath 2010
Posted on 2010-11-18
I created a stored procedure that is attached to a database in sql. I then created a SOAP endpoint that offers up the stored procedure as a web service. I then create an Infopath form and use the web service as the data connection. In the form there are several fields. All of the fields will not have data when the form is submitted. The data that is entered into the fields on the Infopath form passes to the sql table. The problem is that the fields that are blank on the form are being represented by a zero in the table instead of NULL. All fields are of the float data type. If data is not entered into a field on the Infopath form I need NULL to be passed to the table.