Infopath Multiple view data insert issues - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Infopath Multiple view data insert issues

Last post 09-14-2018 04:16 PM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 09-13-2018 09:17 PM

    Infopath Multiple view data insert issues

    I am working with 2 views 1) search and update with Row ID column 2) Insert new record. Submit option:Submit to Database using custom code and rules. (Primary Key: Row_Id , Identity column) Submit button is updating previous search record instead of inserting new record into database when I search & do something in 1st view and navigate to Insert view. e.g. Search row id : 100 and do some update in 1st view, then navigate to Insert view or 2nd view. then click on Submit. It actually updating record for Row_id 100 instead of inserting records with 101 row_id If I directly do insert without searching anything, new record is inserting. I am submitting form using custom code under button click. DataConnection Insconn = DataConnections["submit"]; Insconn.Execute(); Is anyone help me how to achieve this? I also tried using 1 view for Search and Insert, same issue. Thanks
  • 09-14-2018 04:16 PM In reply to

    Re: Infopath Multiple view data insert issues

    It has been a long time since I've worked with a database bound form. But I'd guess that the ID field in the data fields is still populated with the primary key - could that be it?
    Hilary Stoupa

Page 1 of 1 (2 items)
Copyright © 2003-2018 Qdabra Software. All rights reserved.
View our Terms of Use.