InfoPath Dev

Thanks Hilary, For the "Name of the Data Source", doesn't that have to be a predefined Data connection in Infopath?  What I find is that these data connections all require a table to be added.  However for my form, I only want to execute a store procedure that already queries a table. I tried using the conventional VB ...

Thanks that solved my problem.

To perform an action only when an object is not null, you can use:If Not object Is Nothing       ' do your thing End If

Hello, Thank you for the prompt reply.  We are using InfoPath2007, though I am not willing to use a code. But I also found previous post; http://www.infopathdev.com/blogs/david/archive/2008/07/21/codeless-way-of-getting-dbxl-document-properties-docid-doctype-and-dbxl-url.aspx It was very easy if we need DocID from the second opening of a ...

Thanks,I did it.But if datasorce has got some NULL values,the xml created by createnavigator is just skipping that field. Ex:lets say, i am Retriving A,B,C values from datasource.If B is Null then,createnavigator is returning only A and C values only.It is not even showing B as empty attribute. My code is still searching for B field.If it is ...

This article is for IP 2003, but may give you some ideas....

I think more along these lines, for VB... Dim myDataObject As ADOAdapterObject = thisXDocument.DataObjects("Name of Data Source") myDataObject.Command = querySQL

So you need your SQL connection to only return the data for the specified supplier number? Or can you return all the data from the SQL table and use XPath filtering to get the correct value to populate the different fields? If you need a filtered query, our web services do that. Or you can write code. If you can return all your SQL data to the ...

Hi,  For a code sample, are you using InfoPath 2003 or 2007? Do you use VB or C#? Thanks!

There may be a clever work around to this limitation that I don't know about. However, can you simply add an expression box or section that will show or hide depending upon the same condition you would use for the message box.