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