SQL command doesn't work in "database update tool"

 
1
0
-1

As below screenshot, I configured one database update tool in one form. And use below SQL command. it doesn't work. But before I enter database update tool, I try to run this command in SQL server, it can work. And I found the key word "begin" can't be identified. Is it error  in Joget ?

    CommentAdd your comment...

    2 answers

    1.  
      2
      1
      0

      Database Update Tool lets you perform update/insert/delete queries on your selected database.

      If you want to use stored procedures you need to write them in SQL workbench and call them. But for that you need to use JDBC binder where you can write select query.

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

        If you are using MySQL, please read https://stackoverflow.com/questions/10797794/multiple-queries-executed-in-java-in-single-statement#answers-header . This is an optional MySQL connection property and has nothing to do with Joget, I believe.

          CommentAdd your comment...