OraFAQ Forum: Forms » Adding rows dynamically to the tabular view

Home » Developer & Programmer » Forms » Adding rows dynamically to the tabular view (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Adding rows dynamically to the tabular view [message #663490]

Tue, 06 June 2017 07:01

Hatik
Messages: 12
Registered: June 2017

Junior Member

I am wondering is it possible to set up a button trigger, so that on button press, it would add a single row to the end of the tabular table that is with scroll bar.
What I mean is, at the last row to have a button "ADD", when pressed this row looses its button "ADD" and new last row should have "ADD" button.

Report message to a moderator

Re: Adding rows dynamically to the tabular view [message #663519 is a reply to message #663490]

Tue, 06 June 2017 14:18

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I can't test it, and I don't remember whether you can do that or not; however, see whether it is possible to conditionally display the button using SET_ITEM_PROPERTY. Something like this:

if :system.last_record = 'TRUE' then
   set_item_property('your_button', displayed, property_true);
else
   set_item_property('your_button', displayed, property_false);
end if;

Or, perhaps the VISIBLE property should be used (note that you might need to modify ENABLED, NAVIGABLE and some more properties when making it visible - it is described in Forms Help so - have a look).

Report message to a moderator

Re: Adding rows dynamically to the tabular view [message #663521 is a reply to message #663519]

Tue, 06 June 2017 22:28

Hatik
Messages: 12
Registered: June 2017

Junior Member

I see, will give a try thanks for advise

Report message to a moderator

Re: Adding rows dynamically to the tabular view [message #663528 is a reply to message #663519]

Wed, 07 June 2017 03:56

Hatik
Messages: 12
Registered: June 2017

Junior Member

yes it works although not completely, it stands at the very end of the table as in pic, because I put it there through layout editor, is there a way to show it exactly on the last row with data?
One more question is is possible to add rows dynamically on button press?

/forum/fa/13542/0/

[mod-edit: message inserted into message body by bb]

Attachment: gr.PNG
(Size: 12.72KB, Downloaded 3009 times)

[Updated on: Sat, 10 June 2017 20:59] by Moderator

Report message to a moderator

Re: Adding rows dynamically to the tabular view [message #663638 is a reply to message #663528]

Mon, 12 June 2017 03:12

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

You would need to change the buttons y position using set_item_property. You would work out the correct value by adding n-1 * number of rows to the y position of group name.

Report message to a moderator

Previous Topic:	Write Data into Excel from Oracle Forms 11g
Next Topic:	Oracle Forms 6i with Oracle DB 11g. Does it work?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 01:03:31 CDT 2025