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?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com