One more info :

If I replace

where (p.brinco = :Brinco) and ((p.data - :dNasc) <= 20)

with the equivalent

where (p.brinco = :Brinco) and (p.data <= (:dNasc+20))

it does not raise the error, so I think this is really a FB bug.

Anyway, now I'm getting the same message in another point of the
stored proc. I'm debuging it now to see where...

[]s

Carlos
WarmBoot Informatica - http://www.warmboot.com.br
FireBase - http://www.FireBase.com.br (Firebird/Interbase HQ)

VSJ>> Carlos. Are you using

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

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

VSJ>> dNasc = '2000-03-20';

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

VSJ>> Valdir.

VSJ>> ----- Original Message -----
VSJ>> From: "Carlos H. Cantu" <warmbooter@...>
VSJ>> To: "mk_delphi" <ib-support@yahoogroups.com>
VSJ>> Sent: Friday, March 14, 2003 1:49 PM
VSJ>> 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/
>>>

VSJ>> To unsubscribe from this group, send an email to:
VSJ>> ib-support-unsubscribe@egroups.com



VSJ>> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/