<<< 8.8.2004 15:21 - Martijn Tonies "m.tonies@..." >>>
MT> 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)";

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

I tied this:

ib1.SQL.Text:='select * from adresar where upperrts2(meno) starting upperrts2(cast(:MENO as varchar(256)))';
ib1.ParamByName('MENO').AsString:='Tur';
ib1.Open;

But exception is still presents. This is firebird bug?

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

MT> Yahoo! Groups Links









--
Best regards, TRoland
http://www.rotursoft.sk
http://exekutor.rotursoft.sk