Using HASH Variable in the Database Update tool

 
1
0
-1

INSERT INTO Table (c_field) VALUES ("#form.Table1.field#");

I'm using this query to insert a value using data base update tool, but I couldn't get the expected result.

Help me to resolve this...

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Any Joget JDBC database INSERT needs to include the "id" which is a primary key (Sample applies to SELECT). The example below used the "{uuid}" function to tell the DB to assign a random value:

      INSERT app_fd_table_child
   (id,
    c_name,
    c_emailAddress,
    c_contactTel)
VALUES ({uuid},
    {name},
    {emailAddress},
    {contactTel})
        CommentAdd your comment...