How can i delete the previous inserted rows, automatically ?

 
1
0
-1

So, I have a form that generates a datalist and i'm making a API REST GET call to that form so he stores the data from the json. But everytime i make a call he duplicates the rows. How can i delete the previous inserted rows, automatically ?


    CommentAdd your comment...

    2 answers

    1.  
      2
      1
      0

      Hi - you run a job with across the  SQL update tool to clear the table... Unless you have other data you want to retain

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

        Hi, perhaps you can try to prevent duplicating the row in the first place? There is not much information on how the data is being stored, but you could check for an existing row before inserting a new one.

          CommentAdd your comment...