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 DATE.
p.data is a field defined as DATE too.

Any ideas ?

PS: Anyway, it's very interesting the error message. Why FB is trying
to convert the date from a string when the variable is already defined as
DATE type ?

[]s

Carlos
WarmBoot Informatica - http://www.warmboot.com.br
FireBase - http://www.FireBase.com.br