OraFAQ Forum: Forms » how get privous row value in grid

Home » Developer & Programmer » Forms » how get privous row value in grid

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

how get privous row value in grid [message #172802]

Thu, 18 May 2006 02:22

mfa786
Messages: 210
Registered: February 2006
Location: karachi

Senior Member

how get pervious row value in grid

hi master
sir
I have grid in my form my user design the balance sheet
Then he want add the last row value in next row

Such as
Row2 amount=1000
Row3 row2+2000
Total row3-row2

How I get last row value

Please give me idea

Report message to a moderator

Re: how get privous row value in grid [message #172863 is a reply to message #172802]

Thu, 18 May 2006 07:16

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Okay, how about you fix up the 'typos'!! Is that '+' really a '+' or should it be '='. Is that '-' really a '-' or should it be a '+'??

Come ON, we can't answer a question if the formula are WRONG!!

David

Report message to a moderator

how I get any cell value of oracle grid [message #173029 is a reply to message #172863]

Fri, 19 May 2006 01:23

mfa786
Messages: 210
Registered: February 2006
Location: karachi

Senior Member

Thank to every body for reply

No no sir

Such as I use In VB
Variablename = gridname.textmatrix(row,column)
Commission = Emp.textmatrix(2,4)

Sir my requirement this
Please give me idea how I get any cell value of oracle grid

Thanking you

aamir

Report message to a moderator

Re: how I get any cell value of oracle grid [message #173046 is a reply to message #173029]

Fri, 19 May 2006 03:09

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

Senior Member
Account Moderator

Although it is possible to "walk" through block records (using "previous_record", "first_record", "last_record" and similar procedures), I guess that this approach might cause unexpected problems.

Perhaps it would be better to select needed value from the database table and then work with it. Of course, it should already be stored in the table. To do so, you might use "post" instead of "commit" if commiting is not appropriate at the moment.

Report message to a moderator