Em 12/9/2012 15:28, K Z escreveu: > Hello, > > > Is there a trick to have this? > > CREATE TABLE BANK_ACCOUNT > ( > ID INTEGER NOT NULL, > OCCURRENCE TIMESTAMP, > DESCRIPTION VARCHAR(100), > AMOUNT DECIMAL(10,2) NOT NULL > CONSTRAINT PK_ > BANK_ACCOUNT _1 PRIMARY KEY (ID) > ); > > > > CREATE VIEW BANK_ACCOUNT_STATEMENT (ID, > OCCURRENCE , > DESCRIPTION , AMOUNT, BALANCE) > AS > > SELECT r.*, (Calculated Field) > as BALANCE > FROM > BANK_ACCOUNT r > order by r.OCCURRENCE > desc > ; > > > Calculated Field is the previous record balance plus the current record field > AMOUNT. If there is no previous record, then is the current record field > AMOUNT. > > For example: > ID DESCRIPTION AMOUNT BALANCE > 1 Deposit 10 10 > 2 Check -5 5 > 3 Check -10 -5 > 4 Credit transfer 50 45 > > Thank you in advance for your support. > >
I would implement it on the client side... It depends on the date range selected, the order of the records stored, and so on... IMHO it's a dynamic thing that must be calculated on the fly.
