Save secondary source information

[Greg McAllister]

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

 

[Greg McAllister]

Thanks - that was what I need to verify.
"Greg Collins [MVP]" <Greg.Collins_AT_InfoPathDev.com> wrote in message
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.

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