No Valdir, the value stored in dNasc is retrieved from a date field
from another table at the begining of the stored proc :-(

[]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/