Hi,

Are you using the InterBase or Firebird?

And which dbExpress driver?

Why is the CAST needed?

> 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?

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."