--- In firebird-support@yahoogroups.com, Christian Waldmann <Christian.Waldmann@...> wrote:
>
> Hello Iwan
>
> Here is a optimsed select in the stored procedure with a order clause to
> get the correct order:
>
> for select mut.id, mut.TRANSDATE, mut.DEBET, mut.KREDIT
> from TBL_MUTASI mut
> order by mut.TRANSDATE
> into :ID, :TRANSDATE, :DEBET, :KREDIT
>
>
> > 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
> >>
> >>
> >>
> >
> >
> >
> > ------------------------------------
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > 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
> >
> >
> >
>