|Subject||Re: [firebird-support] Error while trying to create stored procedure - invalid request BLR at offset 218|
>> > SELECT FIRST 1 ID FROM LOJA INTO EMPRESA;That is correct, you only need to use : when using them in SQL, I meant
>> 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.
to say that but cut short my sentence, thanks for clarifying this :-)
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Database development questions? Check the forum!