Carlos. Are you using

dNasc = '20-MAY-2000'; Or something near this like trying to put this value
as the SP parameter?

I'm asking because i solved every problem with dates here after using the
format 'yyyy-mm-dd'. So you should use

dNasc = '2000-03-20';

If you wish i can try to help you in portuguese outside the list.

Valdir.

----- Original Message -----
From: "Carlos H. Cantu" <warmbooter@...>
To: "mk_delphi" <ib-support@yahoogroups.com>
Sent: Friday, March 14, 2003 1:49 PM
Subject: Re: [ib-support] Re: Is this a firebird bug ?


> Unfortunatelly it didnt work :-(
>
> Any more ideas ?
>
> []s
>
> Carlos
> WarmBoot Informatica - http://www.warmboot.com.br
> FireBase - http://www.FireBase.com.br (Firebird/Interbase HQ)
>
> m> Hi Carlos,
> m> Can you try a backup/restore and then redo the test?
> m> Sometime I got this kind of error, "conversion error from string
> m> xxxx"
> m> on application working fine for months, the message seem
> m> without any sense..... after backup/restore the same command work
> m> fine!
> m> Ciao!
>
>
> m> --- In ib-support@yahoogroups.com, "Carlos H. Cantu"
> m> <warmbooter@w...> wrote:
> >> I'm getting :
> >>
> >> Incompatible column/host variable data type.
> >> Dynamic SQL Error.
> >> SQL error code = -303.
> >> conversion error from string "30-MAY-2000".
> >>
> >> inside a stored procedure that is executing the following command :
> >>
> >> select first 1 p.peso,p.altura
> >> from peso p
> >> where (p.brinco = :Brinco) and ((p.data - :dNasc) <= 20)
> >> order by p.brinco,p.data
> >> into :Peso0, :Altura0;
> >>
> >> 30-may-2000 is the content of dNasc variable that is defined as
> m> DATE.
> >> p.data is a field defined as DATE too.
> >>
> >> Any ideas ?
> >>
> >> PS: Anyway, it's very interesting the error message. Why FB is
> m> trying
> >> to convert the date from a string when the variable is already
> m> defined as
> >> DATE type ?
> >>
> >> []s
> >>
> >> Carlos
> >> WarmBoot Informatica - http://www.warmboot.com.br
> >> FireBase - http://www.FireBase.com.br
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>