B
B King
I have a web service which submits all the form values to a SQL DB.
However, if one of the optional sections is removed at the time of
submit a data type mismatch error occurs during submit. I trid giving
the default sections default values but no help. It seems like it
should just insert NULL values in the DB as long as the column types
allow NULLS.
TO get around this .. I had to create 2 extra web services for each
optional section. One to add the values to the sectoion if it is
present and one to clear out the values in the DB if it is not. This is
a whole lot of extra overhead for something that shuould be resolved
within infopath.
Any solutions ?
However, if one of the optional sections is removed at the time of
submit a data type mismatch error occurs during submit. I trid giving
the default sections default values but no help. It seems like it
should just insert NULL values in the DB as long as the column types
allow NULLS.
TO get around this .. I had to create 2 extra web services for each
optional section. One to add the values to the sectoion if it is
present and one to clear out the values in the DB if it is not. This is
a whole lot of extra overhead for something that shuould be resolved
within infopath.
Any solutions ?