Question & Answer > View Question

Using HASH Variable in the Database Update tool

Confluence User - 14 Jun, 2022

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...

forms;databaseupdatetool

1

Confluence User •

16 Jun, 2022 •

confluenceUser •

•

confluenceUser •

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})

1

CSV | Excel | XML | PDF

Your answer

Print

Using HASH Variable in the Database Update tool

1

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

1.builder-style-cbc808ae-7b11-4152-b923-7d03ba7ea6c4{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-ea666721-4677-448d-8cf9-be5445a4f870{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

1

Your answer