Database Tool related question

 
1
0
-1

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.


    CommentAdd your comment...

    3 answers

    1.  
      2
      1
      0

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

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

        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.

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

          Hi BG, do you fullfill the requirement below?

          • INSERT INTO SELECT requires that data types in source and target tables match
          1. BG

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

          CommentAdd your comment...