Home » Developer & Programmer » Forms » Form 6i Last Value
Form 6i Last Value [message #570314] Wed, 07 November 2012 21:22 Go to next message
Messages: 22
Registered: January 2006
Location: bangalore
Junior Member

I fetching empno,empname from a table to form block. Now I will give rank to all this emp. I want when I give rank 2 to a emp, rank 1 empno come in a other field automatically. e.g.
empno    empname   rank     aboverankempno

453      a          1
678      b          2          453
555      c          3          678
699      d          4          699
How to do that in form?


[EDITED by LF: applied [pre] tags]

[Updated on: Thu, 08 November 2012 01:21] by Moderator

Report message to a moderator

Re: Form 6i Last Value [message #570335 is a reply to message #570314] Thu, 08 November 2012 01:24 Go to previous message
Messages: 21146
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Research use of the LAG analytic function. It helps you to get value from a previous row; as you said that these rows are ORDERED BY some value, that shouldn't be a problem.

(By the way, I believe that your example isn't correct; the last record's "aboverankempno" value should be 555, not 699).
Previous Topic: Issue in firing of when-create-record trigger
Next Topic: Download link for INTERNET DEVELOPER SUITE
Goto Forum:

Current Time: Thu Aug 17 03:04:29 CDT 2017

Total time taken to generate the page: 0.24666 seconds