powerbuilder help

[Ravi G]

Can you please help on this small query in power builder :

There is a expression like as below :
sum( cap_exch_money_out for group 2 ) * MAX
( cap_adjcap_as_percent_625 [-1] for group 2 )

In the baove what does cap_adjcap_as_percent_625 [-1] this mean ?
Here 'cap_adjcap_as_percent_625' is column in the database.

[Terry Dykstra [TeamSybase]]

The cap_adjcap_as_percent_625 [-1] is a way of refering to the value of
cap_adjcap_as_percent_625 in the previous row. In a similar way you can
refer to the next row using cap_adjcap_as_percent_625 [1] .
You can refer any number of rows back or forward, e.g. [-9], [5].
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

Post by Ravi G
sum( cap_exch_money_out for group 2 ) * MAX
( cap_adjcap_as_percent_625 [-1] for group 2 )
In the baove what does cap_adjcap_as_percent_625 [-1] this mean ?
Here 'cap_adjcap_as_percent_625' is column in the database.