Cannot get update data from SQL Server

[Ray]

I have designed an InfoPath form which have some fields to retrieve data
from a table in SQL Server. After I opened the form to fill in, I inserted
some new records into the table in SQL Server. However, I found that I
cannot get the new records in the opened form until I re-open the form to
fill in. Any solution for this problem?

 

[Clay Fox]

Hi Ray.

I am guessing it may be a matter of the data being hidden in the view. If
you insert records they are in the forms data and submitting to SQL just
syncs them. It will not remove them from the form but possibly other controls
are excluding the data.

You can always requery your main data source via an action to get the latest
data if others are also updating.

Maybe give some more details of your form layout and what you are trying to
do.
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

 

[Ray]

Hi Clay,

My problem is solved after adding an requery action before setting values to
the fields .

Thank you for your help.

Regards,
Ray