Hello Iwan

My prefered solution is a stored procedure.

Here is the Table and the stored procedure:

CREATE TABLE TBL_MUTASI (
ID INTEGER,
TRANSDATE TIMESTAMP,
DEBET NUMERIC(15,2),
KREDIT NUMERIC(15,2)
);

SET TERM ^ ;

create or alter procedure PROC_CALC_SALDO
returns (
ID integer,
TRANSDATE timestamp,
DEBET decimal(15,2),
KREDIT decimal(15,2),
SALDO decimal(15,2))
as
begin
SALDO = 0;
for select mut.id, mut.TRANSDATE, mut.DEBET, mut.KREDIT from
TBL_MUTASI mut
into :ID, :TRANSDATE, :DEBET, :KREDIT
do BEGIN
SALDO = :SALDO + :DEBET - :KREDIT;
suspend;
end
end^

SET TERM ; ^


And the select statment:


select * from PROC_CALC_SALDO


And the result:

ID TRANSDATE DEBET KREDIT SALDO
10 03.11.2009 00:00:00 10'000.00 0.00 0'000.00
30 05.11.2009 00:00:00 0.00 5'000.00 5'000.00
20 04.11.2009 00:00:00 250.00 0.00 5'250.00


send2iwan schrieb:

> hi all,
>
> i want to make query like this.
>
> table name=mutasi
>
> id transdate debet kredit saldo
> == ========== ===== ====== =====
> 10 10/01/2009 10000 10000
> 20 10/05/2009 250 10250
> 30 10/30/2009 5000 5250
>
> how to make the query espesialy for field saldo?
> everyday records increase 50-200 records.
>
> thanks.
> Iwan
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>