Thu, 24 Sep 2026
Login

Database Tool related question

Confluence User - 02 Apr, 2020

Hi, I read over the forum and tried different things it still did not work for me. Trying to put all data from table test_list to test_program. The two tables have almost identical structure.


INSERT INTO app_fd_test_program (c_program_name, c_customerName, c_field7_test_id)

SELECT c_program_name, c_customerName, c_field7_test_id

FROM app_fd_test_list 

WHERE (app_fd_test_list.c_field7_test_id IS NOT NULL)


However it just does not work. I am using the Joget Docker image v6 enterprise.


Any suggestion is welcome.


database

4

Confluence User •
02 Apr, 2020 •
confluenceUser •
•
confluenceUser •

Hi BG, do you fullfill the requirement below?

  • INSERT INTO SELECT requires that data types in source and target tables match
Confluence User •
02 Apr, 2020 •
confluenceUser •
•
confluenceUser •

Hi, thank you; but the data types are identical, all text.

Confluence User •
02 Apr, 2020 •
confluenceUser •
•
confluenceUser •

tried all different ways, still not working...each time I run the "update" process, only a "197_test_gateway_process5" shows up in the ID of the test_program list.

Confluence User •
03 Apr, 2020 •
confluenceUser •
1 •
confluenceUser •

Found the issue. It turned out to be "id missing value" on the test_program table when inserting new data.

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
How can I set dedicated datasource for each app ?
Select Box
Issue Saving AJAX Subform Data to Datalist in Joget
How to transfer all files and users data from on-premise to on-demand server?
SQLI ERROR
Error while connecting to Snowflake DB.
loginAs={currentUser} not working ?
Connect to Database - Db2
Run external stored procedure using a date parameter and show results
Fill Grid Columns From JSON String in Beanshell
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print