Hi

I suspect a bug in cast function.

I have problem with following sql:

select f_ageindays (birth_dt, cast (:period_end as date))
from my_table

* birth_dt is of type date,
* :period_end to be set in Delphi program (via dbx driver and
TSQLClientDataset)

I set parameter type to date and value to a date and then try to open
dataset. this causes error with message "Data type unknown"

I guess this is not Delphi nor dbExpress problem because when I leave
out cast like this:

select f_ageindays (birth_dt, :period_end)
from pigs

everything works fine.

Am I missing something or is it a bug or is it a feature?

thank you

Aivar Annamaa