InfoPath Dev

I have an InfoPath 2007 form that successfully queries a single row via a secondary data source to a web service. When I try to submit the data to the web service, with or without changing any of the data, I get the following error:

Field or group: ns1:BusinessEntityID
Error: Only integers allowed

BusinessEntityID is integer type, it is a primary key. The dataFields text box is read only so the value can't change. Both the field in the data source and the text box that displays the BusinessEntityID show the data type as "int" with the data type dropdown is disabled so the type cannot be changed.

Any ideas how to overcome this would be appreciated.

Regards,
Wil Higdon

Hi Wil and welcome to InfoPathDev forums,

Vexing! My guess is that the Web Service takes a parameter and in the data connection you haven't specified what to map BusinessEntityID to and therefore it's nil and fails. Just a guess though, but take a look at the data connection config window and verify that you set up the parameters to map to fields in your form (or set them in the form before submitting using a rule).

Patrick,

Thanks for the prompt reply.

In this case, the web service takes only the dataset as a parameter, and the dataset being submitted is the one queried from the web service. The dataset consists of just the BusinessEntityID integer field and three varchar fields, so there's nothing complex going on.

Wil