InfoPath Dev

When I set a field's value (inventory item) in a repeating section from a drop down list (inventory items) the same value is set in every inventory item field.  How do I set a value for only 1 inventory item field without changing all inventory item fields to the same value?

Thanks it worked

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 ...

Hi & Thanks Matt ! Now I'm sure that it wasn't my fault ! yes , it's annoying ...

Are you using InfoPath 2007? If so, right click the field in the Data Source task pane, and click "Copy XPath". This will give you the fully qualified XPath (with the namespaces in it).

Are you talking about on submit? If so, don't use the default submit. Write code, and in your code you can walk through the errors collection and report any errors you need to with their details, then cancel the submit. If there's no errors, then do the submit.

Yes, editing the data connection SQL command permanently changes the default query. However, the query command is available to be updated at any time using code before you query. When using LIKE, you need to use the "%"s. The LIKE clause *is* your wildcard... So if you use: SELECT * FROM table WHERE column LIKE '%an%' This ...

You first need to figure out what SQL needs. I believe for a bit it should be a 1 or 0. Get submit working with that first. Then you set up your check boxes accordingly to use the correct values. Then when you set the fields for the check boxes from the secondary DC you perform a conversion if True set to 1 if False set to 0. I think that ...

I cannot change the data type in sql, because I am using web application to generate this table. I am directly binding the data (CustID,reviewreqd,changid....etc )(boolean fields)  using Details view control in that web application. Is there any other way changing it? How to get rid of this 'The string 'True' is not a boolean ...

What is the right syntax to access use for the following Web Service data source in Jscript?   Code...I am getting an error on this var firstName = XDocument.DOM.selectSingleNode("/dfs:myFields/dfs:dataFields/tns:UserInfoResponse/my:UserInfoResult/firstname").text Data Source...  myFields    ...