 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / September 2004Save secondary source information
I am creating a change form InfoPath document. I am able to retrieve what I call my 'next dca number' field from SQL. I cannot get the value to store itself in my InfoPath form though. When I reopen the form the field is blank and I must run the query again. Unfortunately this wont work because I need to increment the number after it has been selected. When I use my incrementing procedure I get my last number used - save my form - retrieve my form and the DCA number is blank (as before) and when I query the database and get the incremented number. To summarize - Why does the data retrieved from SQL not store itself in my XML data? Thanks for the help, Greg McAllister The SQL data returned from the query is in a DIFFERENT data source than that of your XML file. If you want the data copied from SQL to XML, you will need to do that wil code. Make sure that you have nodes in your XML for the data and perform the copy in code.  SignatureGreg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com I am creating a change form InfoPath document. I am able to retrieve what I call my 'next dca number' field from SQL. I cannot get the value to store itself in my InfoPath form though. When I reopen the form the field is blank and I must run the query again. Unfortunately this wont work because I need to increment the number after it has been selected. When I use my incrementing procedure I get my last number used - save my form - retrieve my form and the DCA number is blank (as before) and when I query the database and get the incremented number. To summarize - Why does the data retrieved from SQL not store itself in my XML data? Thanks for the help, Greg McAllister Thanks - that was what I need to verify. The SQL data returned from the query is in a DIFFERENT data source than that of your XML file. If you want the data copied from SQL to XML, you will need to do that wil code. Make sure that you have nodes in your XML for the data and perform the copy in code. SignatureGreg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com I am creating a change form InfoPath document. I am able to retrieve what I call my 'next dca number' field from SQL. I cannot get the value to store itself in my InfoPath form though. When I reopen the form the field is blank and I must run the query again. Unfortunately this wont work because I need to increment the number after it has been selected. When I use my incrementing procedure I get my last number used - save my form - retrieve my form and the DCA number is blank (as before) and when I query the database and get the incremented number. To summarize - Why does the data retrieved from SQL not store itself in my XML data? Thanks for the help, Greg McAllister |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.