I want to update status of selected items "Created" to "Assigned" using JDBC

 
1
0
-1

Now, I want to update status when I will click on assign button then selected checkbox's status value will be update to Assigned.



Thank you.

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      You'll need to use the SQL Update statement. Ensure the columns has a prefix "c_" and the table name has the prefix "app_fd_"

      example: You have a form with the table named "projects", and in it you have a field called "status". Hence your SQL update statement should look something like:

      UPDATE app_fd_projects SET c_status='Assigned' WHERE <whatever conditions set>;

      more info at JDBC Form Binder

        CommentAdd your comment...