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