Home » Developer & Programmer » Forms » Create record above? (Oracle Forms)
icon9.gif  Create record above? [message #566658] Tue, 18 September 2012 07:15 Go to next message
Ribeiroluke
Messages: 3
Registered: September 2012
Location: Brasil
Junior Member

Hello, good day .. I'm new to the forum need some help, how do I insert a new record in a DataBlock, and the standard is always insert a line below, you could add a record above?
Re: Create record above? [message #566661 is a reply to message #566658] Tue, 18 September 2012 07:19 Go to previous messageGo to next message
Littlefoot
Messages: 19786
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What improvement would it make? What's wrong with inserting it at the end of the list? Sorting is, anyway, determined by data block's ORDER BY property, not inserting sequence.
Re: Create record above? [message #566662 is a reply to message #566661] Tue, 18 September 2012 07:27 Go to previous messageGo to next message
Ribeiroluke
Messages: 3
Registered: September 2012
Location: Brasil
Junior Member

thanks for the reply, but let explain, I am a systems analyst here at TAM aviations of sao paulo - Brazil, being asked to check for a solution that can make the insert in each block was above, ie when you click insert the record would be inserted displayed at the top of the block.
Re: Create record above? [message #566663 is a reply to message #566662] Tue, 18 September 2012 07:39 Go to previous messageGo to next message
Littlefoot
Messages: 19786
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I see ... well, I wouldn't know how to do that, sorry.
Re: Create record above? [message #566666 is a reply to message #566662] Tue, 18 September 2012 08:16 Go to previous messageGo to next message
joy_division
Messages: 4545
Registered: February 2005
Location: East Coast USA
Senior Member
I see ambiguous descriptions from you. Top of block or above current record? Which one? These are two different things.
In any event, what's wrong with PREVIOUS_RECORD X number of times and then INSERT_RECORD/CREATE_RECORD?
Unless I just don't understand your question.
Re: Create record above? [message #566675 is a reply to message #566666] Tue, 18 September 2012 09:07 Go to previous messageGo to next message
Ribeiroluke
Messages: 3
Registered: September 2012
Location: Brasil
Junior Member

sure, I may have expressed myself wrong, would create the new record at the top of the block. Create Record.
  • Attachment: tam.JPG
    (Size: 76.54KB, Downloaded 104 times)
Re: Create record above? [message #566686 is a reply to message #566675] Tue, 18 September 2012 12:37 Go to previous message
joy_division
Messages: 4545
Registered: February 2005
Location: East Coast USA
Senior Member
What about FIRST_RECORD and then CREATE_RECORD? It's not quite the top of the block, but as close as you can get.
Previous Topic: ORA-12203
Next Topic: Change the language of the textbox
Goto Forum:
  


Current Time: Tue Nov 25 18:53:07 CST 2014

Total time taken to generate the page: 0.10620 seconds