Insert Row, then immediately query new row? - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Insert Row, then immediately query new row?

Last post 09-22-2011 06:22 PM by Chris Martin (MQS). 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 09-22-2011 06:22 PM

    Insert Row, then immediately query new row?

    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.
Page 1 of 1 (1 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.