SQL Database Integration

Re: Copy of data from DB

tatopitta — Fri, 01 Sep 2006 06:51:33 GMT

Thank you guys, you're great!

Re: Copy of data from DB

Matt Faus — Thu, 31 Aug 2006 19:49:38 GMT

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();

Re: Copy of data from DB

tatopitta — Thu, 31 Aug 2006 07:43:14 GMT

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?

Re: Copy of data from DB

tatopitta — Thu, 31 Aug 2006 07:22:36 GMT

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!

Re: Copy of data from DB

Patrick Halstead — Thu, 31 Aug 2006 07:13:29 GMT

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.

Copy of data from DB

tatopitta — Tue, 29 Aug 2006 14:58:09 GMT

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