Ok !

> > 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 !?!?!?!
Tiago Gouvêa

----- Original Message -----
From: "Martijn Tonies" <m.tonies@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, June 24, 2004 9:25 AM
Subject: Re: [firebird-support] INTO variable


> Hi,
>
> > I'm trying to put the result set of an 'execute statement' into a output
> variable thats are changeable.. like
> >
> > execute statement 'SELECT MAX(CODIGO) FROM TABELA' into :MAT_1
>
> This should work fine - what is the error you're getting?
>
> > I need to be
> >
> > execute statement 'SELECT MAX(CODIGO) FROM TABELA' into :MAT_||:NUM
>
> What should this do?
>
> Can you explain in more detail?
>
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
> Server.
> Upscene Productions
> http://www.upscene.com
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>

[Non-text portions of this message have been removed]