OraFAQ Forum: Forms » Create record above?

Home » Developer & Programmer » Forms » Create record above? (Oracle Forms)

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

Create record above? [message #566658]

Tue, 18 September 2012 07:15

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?

Report message to a moderator

Re: Create record above? [message #566661 is a reply to message #566658]

Tue, 18 September 2012 07:19

Littlefoot
Messages: 21813
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.

Report message to a moderator

Re: Create record above? [message #566662 is a reply to message #566661]

Tue, 18 September 2012 07:27

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.

Report message to a moderator

Re: Create record above? [message #566663 is a reply to message #566662]

Tue, 18 September 2012 07:39

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

Senior Member
Account Moderator

I see ... well, I wouldn't know how to do that, sorry.

Report message to a moderator

Re: Create record above? [message #566666 is a reply to message #566662]

Tue, 18 September 2012 08:16

joy_division
Messages: 4963
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.

Report message to a moderator

Re: Create record above? [message #566675 is a reply to message #566666]

Tue, 18 September 2012 09:07

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 830 times)

Report message to a moderator

Re: Create record above? [message #566686 is a reply to message #566675]

Tue, 18 September 2012 12:37

joy_division
Messages: 4963
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.

Report message to a moderator

Previous Topic:	ORA-12203
Next Topic:	Change the language of the textbox

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 10:48:52 CDT 2024