1 2 Previous Next 18 Replies Latest reply: Mar 8, 2013 11:46 PM by HamidHelal RSS

    make an item inactive in a record

    982158
      Hi,
      I have a problem when displaying the contents of my DB,
      I use a block based contains 3 items (related to DB) and image type item that can display a message, the number of records displayed default is 5!
      and I have in my DB only 2 records.
      the problem that when I click on the 3rd item image will record a message or affcihé this item must be inactive!
      for 4th and 5th record no problems ..
      what should I do?

      this is the code / / when-new-form-instance trigger

      declare
                Cursor cur IS
                SELECT empno AS num,
                     ename AS name,
                     salary as sal,
                FROM emp
           

                ORDER BY empno;
      begin
           

      execute_query;


      for s in cur loop
      read_image_file('C:\button\s.gif','.gif','emp.update');
      next_record;
      end loop;
      first_record;
        1 2 Previous Next