🚀 go-pugleaf

Martijn, thanks. It was a problem with the checkParam (never thought of
that).
Thanks a lot.
Best Regards

Goncalo

"Martijn Tonies" <m.tonies@upscene_remove.com> wrote in message
news:3dff5dc1@newsgroups.borland.com...
> 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."
>
>