This discussion is archived
4 Replies Latest reply: Dec 9, 2012 5:18 AM by Andreas Weiden RSS

inserting in a block and displaying in another one

newbi_egy Explorer
Currently Being Moderated
hi all ,
i've two blocks "patients and inserted_patients" , the first for inserting patients data , and the second for showing data for patients in this day (sysdate) , so i changed the where clause of the "inserted_patients" table to
trunc(test_date) = trunc(sysdate)

2-when button pressed "insert" > insert the data in the first block"patients" , then go to the second block "inserted_patients" and
execute_query .

and this what i want to know if i am doing it the right way or not ? because every click on the button "insert" performs the query . every click do this , does this affect the performance , do i choose the wrong way to do this ? , is there another way ?

thanks

Legend

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