🚀 go-pugleaf

Hi,

> Hello all. I've create the following procedure in IBConsole and runned ok.
> Here's the procedure
>
> SET TERM !!;
> CREATE PROCEDURE UPDATE_TARAMEDIA
> AS
> DECLARE VARIABLE CHAVE INTEGER;
> DECLARE VARIABLE TARA NUMERIC(8,2);
> BEGIN
> FOR
> SELECT TARAMEDIA,CHAVE_LOTE FROM LOTE INTO :TARA, :CHAVE
> DO
> UPDATE AMOSTRA SET TARAMEDIA=(:TARA) WHERE CHAVE_LOTE_TME=(:CHAVE);

Where did you read the (:variable) syntax? Simple using :varname would do it.

> EXIT;
> END !!
> SET TERM !!;
>
> This works fine.
> I'm trying to do this in Delphi running an IBSQL query.
> First, the
> SELECT TARAMEDIA,CHAVE_LOTE FROM LOTE INTO :TARA, :CHAVE
> gives an error on the INTO. If I take the : before the variables it runs
> fine.

What are you running, the CREATE PROCEDURE? If so, do you set
ParamCheck to False?

> Second I run the query and it's ok, but when commit the transaction I get
> this error:
> invalid request BLR at offset 99 undefined message number
>
> Any tips? I'm kind of lost here...
>
> Ah, one last thing. If I replace the SET TARAMEDIA=(:TARA) with SET
> TARAMEDIA=10 it works!!! the problem is in the variables.

There's no problem with variables - there's a problem with your code.


--

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."