InfoPath Dev

hi all,
I have a secondary data connection with a SQL database to retrieve data to be displayed in a repeating table. I need to "copy" the values from the database in nodes of the XML document.Is it possible?

Than you

Hi Tatopitta!
Are you asking whether you can copy the values from your secondary data source to your main data source? If so, yes, but you'll either need a) rules for each field which could be a pain to manage, or b) write some code to do it. I hope this helps.

Yeah Patrick,
I'm trying to use JScript code but I have a problem:
my SQL secondary datya source is named "ProjectManagers" but the following line

var theDataObject = XDocument.DataObjects("ProjectManagers").DOM;

gives me an error becouse the object is null...how can it be possible if the name ProjectManagers is correct?

Can i set parameters for SQL statement in the datasource?

Thank you very much!

Hi Patrick, forget the first question, please :)

How can I use in my SQL statement a parameter which receives values from a XML field in the form?

You might take a look at this HowTo:http://www.infopathdev.com/howto/tutorials/default.aspx?i=0bb37b4de44348408680a53a449f2353 There is some code there that uses value typed into the XML to filter the results of the query.

If you want to use code to create a custom SQL Query, take a look at this code (in C#, but you should be able to convert):

// Get value from XML
string name = thisXDocument.DOM.selectSingleNode( "//my:Name" ).text;

// Set the query
ADOAdapter dbConn = (ADOAdapter)thisXDocument.DataObjects["Project-WorkItems"].QueryAdapter;
dbConn.Command = "SELECT col1, col2 FROM table WHERE Name = \"" + name + "\"";
// Issue the query
thisXDocument.DataObjects["Project-WorkItems"].Query();

Thank you guys, you're great!