>> > SELECT FIRST 1 ID FROM LOJA INTO EMPRESA;
>>
>> Whenever you use (input/output) parameters or variables, you need to
>> use a : in front of it.
>>
>> INTO :EMPRESA;
>
>Uhm, AFAICT this isn't correct: ':' is needed only within a *SQL*
>statement, while the Firebird PL is tolerant on its usage. The "INTO"
>part falls in the latter specifications.

That is correct, you only need to use : when using them in SQL, I meant
to say that but cut short my sentence, thanks for clarifying this :-)

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com