How do I change the message file?

and when I add the : I get this message:

Dynamic SQL Error SQL error code = -104
Token unknown - line 15, column 36

Thats why I was trying to create the procedure without them, but when I take
them off i get that other message :(

On Nov 15, 2007 10:48 AM, Martijn Tonies <m.tonies@...> wrote:

> Hi,
>
> > I'm trying to create a stored procedure from a delphi application and
> I'm
> > getting this error:
> >
> > *invalid request BLR at offset 218
> > undefined message number
>
> Sounds like you're using the wrong message file at the client.
>
> > *This is my stored procedure's code:*
> >
> > CREATE PROCEDURE UPDATE_FATURA
> > AS
> > DECLARE VARIABLE EMPRESA CHAR(38);
> > DECLARE VARIABLE USUARIO CHAR(38);
> > DECLARE CONTA_PADRAO CHAR(38);
> > DECLARE VARIABLE CATEGORIA_PADRAO CHAR(38);
> > DECLARE VARIABLE PAGANTE_ID CHAR(38);
> > DECLARE VARIABLE VENDA_ID CHAR(38);
> > DECLARE VARIABLE DATA_VENDA DATE;
> > DECLARE VARIABLE VALOR NUMERIC(15,2);
> > DECLARE VARIABLE LOJA_ID CHAR(38);
> > DECLARE VARIABLE VENDEDOR_ID CHAR(38);
> > DECLARE VARIABLE FINANCEIRO_ID CHAR(38);
> > BEGIN
> > 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.
>


[Non-text portions of this message have been removed]