InfoPath Dev

The column type in SQL is bit. When I turned the checkbox to TextBox, it is receiving True/False from database.    (with the first letter as capital)

When I have changed the checkbox data type to text(string) it looks working, but it is not showing the checkbox as checked when it gets 'true'  value from the database. Also it is raising an exception when I am trying to submit the form to sharepoint server. The error is Server was unable to read request ---> There is an error in ...

I did exactly the same way you said above, now it is giving me error:  Only intergers are allowed. When I changed the values of checkbox as when cleared: 0 and when Selected : 1 (In the checkbox properties), it is giving me error: Only 0 or 1 allowed. so, does it mean that, Infopath is receiving data from sql server in some other format? ...

I have tried these rules before. When I am testing it in preview mode, whenever the rule applies, it is highlighting the checkbox with RED dots and giving me the error : Only 'true' or 'false' allowed. This field is a bit data type in sql server and it is returning 0 or 1 to the infopath. How can I fix this? Thanks

Hi, I have an infopath  form that contains a drop down list and some checkboxes. I am maintianing a table in sql server 2000 with the same fields. (CustID (primary key) and some boolean values). I have created a data connection with sql server to bind the CustID with dropdown list. Now, my requirement is whenever the user selects the CustID ...

Hi, I am trying to submit data to the sharepoint server through a web service. I have deployed web service to the sharepoint server machine.Its path in that machine is as follows: http://server:7080/Service.asmx. It is working well in that machine. I have created a data connection with the Infopath form to submit the data to the above web ...

I tried the following code for my requirement. My requirement is to pass the value as "YELLOW" in a text box if the target date is with in 3 days.XPathNavigator GYR = MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:field154", this.NamespaceManager); XPathNavigator Date1 = ...

Hi, I have two DateTime picker controls Date1 and Date2. How can I compare these two dates in VSTA? I need to pass some data to a text box depending on this comparision. How to do that using code? Thanks    

 I got success in finding out the location where the iteration is taking place. Thanks for your help.

How can I find out the total number of calculations on my form? Can I find out this using Logic Inspector?