InfoPath Dev

Hi , I'm really confused ...

when I use a web service to query and submit my database , it makes Some Nullable fileds as Cannot Be Blank !!!!!! (usually DateTime & int fields)

but you know that only the primary key should be mandatory !!!

For example ( look at the attachment ) in the attachment , only the PerNo ( Person number ) is mandatory in DB , but when I use a web service the other fileds are marked as ''cannot be blank' 

why ?! ... I want that user could leave some fileds empty ....

Hi Navid,

This is an annoying habit of InfoPath and I'm not sure why it continues to do this.  You could try editing the XSD yourself to add the xsi:nillable='true' attribute.  That's the best I can think of.  Good luck!

Hi & Thanks Matt !

Now I'm sure that it wasn't my fault !

yes , it's annoying ...

Hi Navid,

You could try our Database Accelerator Web service (free for trial use) that doesn't try to make assumptions about the data it is receiving: http://www.infopathdev.com/files/folders/dbxldownload/entry22386.aspx. Check out this link for more info: http://www.qdabra.com/content/prodinfo/dbxl-benefits.aspx 

Let me know if you'd like a quick demo to show you how it works.

Best,

 I encounter the same problem, I thought it has something to do with the web service, yet it is the infopath fault, oops