| Form 6i Last Value [message #570314] |
Wed, 07 November 2012 21:22  |
amit_garg3
Messages: 22
Registered: January 2006
Location: bangalore
|
Junior Member |
|
|
Hi
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?
Thanks
[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  |
 |
Littlefoot
Messages: 21823
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).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
