This discussion is archived
9 Replies Latest reply: Oct 3, 2012 1:10 AM by sm*290887*m7 RSS

Insert data based on the selected query output from tabular form

sm*290887*m7 Newbie
Currently Being Moderated
Hi all,

I have a main block ( A ) which will prompt to the user based on the selection records from the query search. Records will then displayed in the tabular form and user will like to select further record based on a check box that created for further action. I have created a action button on when_button_pressed to insert the records that checked by the user.

My statement as below :-

GO_BLOCK('A' );

INSERT INTO ACT_INV_GRN_LBL_TMP ( SELECT ITEM_CODE, ITEM_DESC, :A.TEXT_ITEM11 FROM ACT_VW_GRN_LBL WHERE :A.TEXT_ITEM11 = 1 AND GRN_NO = :A.GRN_NO );

But the screen seem like doing nothing after execute the button.

Help me please. Thanks.

Lim

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points