Home » Developer & Programmer » Forms » Why I cannot get the item value on tabular layout? (Forms [32 bit]Version 9.0.4.0.19 + WinXP)
Why I cannot get the item value on tabular layout? [message #401294] Sun, 03 May 2009 22:02 Go to next message
kevin_ye
Messages: 37
Registered: December 2007
Location: Shanghai,China
Member
I have create a tabular layout, and I inserted 3 records in [WHEN-NEW-FORM-INSTANCE], then I created a button for testing.
But when I press the button, I cannot get the item value on tabular layout.

Can anyone tell me why? any suggestion appreciated.
  • Attachment: 2.JPG
    (Size: 9.44KB, Downloaded 89 times)
Re: Why I cannot get the item value on tabular layout? [message #401295 is a reply to message #401294] Sun, 03 May 2009 22:05 Go to previous messageGo to next message
kevin_ye
Messages: 37
Registered: December 2007
Location: Shanghai,China
Member
the source code:
  • Attachment: test3.fmb
    (Size: 60.00KB, Downloaded 112 times)
Re: Why I cannot get the item value on tabular layout? [message #401296 is a reply to message #401294] Sun, 03 May 2009 22:09 Go to previous messageGo to next message
kevin_ye
Messages: 37
Registered: December 2007
Location: Shanghai,China
Member
[WHEN-NEW-FORM-INSTANCE]:
go_block('selected_stock_list');
first_record;
:selected_stock_list.stock_id   := '1001';
:selected_stock_list.stock_desc := 'AAA';
next_record;
:selected_stock_list.stock_id   := '1002';
:selected_stock_list.stock_desc := 'BBB';
next_record;
:selected_stock_list.stock_id   := '1003';
:selected_stock_list.stock_desc := 'CCC';
first_record;


[WHEN-BUTTON-PRESSED]:
go_block('SELECTED_STOCK_LIST');
first_record;
loop
   if :selected_stock_list.stock_id is not null then
     --message('abc');
     message('stock_id:'||nvl(:selected_stock_list.stock_id,'XXX')); pause;
  end if;
  if :system.last_record = 'TRUE' then
    exit;  -- reached last record so exit loop
  else
    next_record;
  end if;
end loop;
Re: Why I cannot get the item value on tabular layout? [message #401298 is a reply to message #401294] Sun, 03 May 2009 23:27 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

either remove the pause or see the status bar

kanish
Re: Why I cannot get the item value on tabular layout? [message #401310 is a reply to message #401298] Mon, 04 May 2009 00:52 Go to previous message
kevin_ye
Messages: 37
Registered: December 2007
Location: Shanghai,China
Member
Haha, Kanish, you have replied my topic on otn.
Thank you so much.
Now it works fine.
Previous Topic: multi record block processing
Next Topic: 'Do you want to save the changes you have made?" suppression
Goto Forum:
  


Current Time: Sun Dec 04 04:48:11 CST 2016

Total time taken to generate the page: 0.04198 seconds