Subject Re: [firebird-support] Datatype unknown
Author Martijn Tonies
Hi,

> I need execute this command
>
> "Select MyColumn from MyTable Where MyUDF(MyColumn) Starting
> MyUDF(@MyParam)";
>
> or
>
> "Select MyColumn from MyTable Where MyColumn Starting
> MyUDF(@MyParam)";

Does MyUDF(CAST :MyParam as <yourdatatype>) (eg: VARCHAR(80) )
work?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com


> but this command raise exception "Data type unknown".
> MyUDF is udf with replace national chars to basic ASCII and convert
> ToUpper();
>
> Thank.
>
> --
> Best regards, TRoland
> http://www.rotursoft.sk
> http://exekutor.rotursoft.sk
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>