> Hi,
>
> > > > execute statement 'SELECT MAX(CODIGO) FROM TABELA' into :MAT_1
> >
> > Work fine realy..
> >
> > But, this output variable (MAT_1) need be changed in my while, it will
> start in MAT_1 and stop in MAT_14..
> >
> > Then the into :MAT_1 need to be into MAT_||:NUM , NUM are the integer
> count of the while.
> >
> > > > execute statement 'SELECT MAX(CODIGO) FROM TABELA' into :MAT_||:NUM
> >
> > The result will be like this:
> > execute statement 'SELECT MAX(CODIGO) FROM TABELA' into :MAT_1
> > execute statement 'SELECT MAX(CODIGO) FROM TABELA' into :MAT_2
> > execute statement 'SELECT MAX(CODIGO) FROM TABELA' into :MAT_3
> >
> > What can I do !?!?!?!
>
> Do what you do above. There's no other way.
>
> But why do you want to have the MAX value multiple times?

The MAX value here are just a example, a sample.. :) In the real case I will
use in each time one field.. :)

But.. If it's not possible.. I will need to be one CASE.

Are one sugestion to the next version of Firebird.. In this list have
someone of Firebird foundation ? If yes, it's a sugestion ! :)

Thanks Martijn Tonies !!

> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL & MS

SQL

> Server.
> Upscene Productions
> http://www.upscene.com
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>