I have an infopath 2007 form using Visual Basic.
I am using a submit button to insert into, or update, SQL Server 2008. Here is what I am doing:
1. User fills out the form
2. Data is submitted to the database
3. View is switched
4. Data is queried and repeating tables are populated
Currently, I can correctly query the data only AFTER I have closed and re-opened the form. I would like to be able to immediately query the newly submitted rows. The data is being inserted into the database before the SQL connections are opened and before the queries are run. When I step through the code I can switch to the database server and view the new rows long before I try to query them. So, I know that the data is being inserted correctly, it is just not available to the form until it has been re-opened.
All of the SQL connections are done using VB, I have not make any Data Connections using the Infopath interface.