Home » Developer & Programmer » Forms » Adding rows dynamically to the tabular view (oracle 10g)
Adding rows dynamically to the tabular view [message #663490] Tue, 06 June 2017 07:01 Go to next message
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.
Re: Adding rows dynamically to the tabular view [message #663519 is a reply to message #663490] Tue, 06 June 2017 14:18 Go to previous messageGo to next message
Littlefoot
Messages: 21690
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).
Re: Adding rows dynamically to the tabular view [message #663521 is a reply to message #663519] Tue, 06 June 2017 22:28 Go to previous messageGo to next message
Hatik
Messages: 12
Registered: June 2017
Junior Member
I see, will give a try thanks for advise
Re: Adding rows dynamically to the tabular view [message #663528 is a reply to message #663519] Wed, 07 June 2017 03:56 Go to previous messageGo to next message
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 908 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 Go to previous message
cookiemonster
Messages: 13894
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.
Previous Topic: Write Data into Excel from Oracle Forms 11g
Next Topic: Oracle Forms 6i with Oracle DB 11g. Does it work?
Goto Forum:
  


Current Time: Tue Nov 30 14:38:38 CST 2021