4 Replies Latest reply: Dec 9, 2012 7:18 AM by Andreas Weiden RSS

    inserting in a block and displaying in another one

      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 ?