The record in list grid is gone missing from table source once saved.

 
1
0
-1

Hi there,

I have 2 list grids in my form design which point to the same table source (db) with closed and open status to differentiate the lists.  The sample as attached below.  I am managed to retrieve the closed subtasks for the 1st time, anyhow if I save the form, the closed subtask will gone missing from my form and table too.  I am wondering why and how to resolve this issue.  Please advise.  Thanks.

 

 

Regards,

Wah Man

    CommentAdd your comment...

    3 answers

    1.  
      1
      0
      -1

      Your open subtasks list grid will remove the data in the same table with same foreign key and not exist in the grid before save.

      1. Wong Wah Man

        Is there any workaround to resolve this? My closed subtasks - no insert and update whereas the open subtasks allow to edit. Would appreciate for your advise. Thanks

      2. panda

        Hi, the problem is your open subtask list will remove the data. I think this issue can be solved by using JDBC Load/Store binder for your open tasklist. You will need to exclude the closed tasklist record in your load binder.

      CommentAdd your comment...
    2.  
      1
      0
      -1

      Hi Panda, my closed subtasks list grid actually is using the jdbc binder to load data (image as below). My intention just want to display the record with no insert and update. Just wondering why the records will be removed once the Save button is clicked?

       

        CommentAdd your comment...
      1.  
        1
        0
        -1

        Hi,

        I think currently the multirow form load and store binder will remove the record not in the grid before it stores to database. You will need a custom store binder like JDBC Store Binder if you want a different behavior.

         

         

         

        1. Wong Wah Man

          HI Panda, already posted another image to seek your advise. Many thanks ahead.

        CommentAdd your comment...