i do it like that


create a new lib (unit)
write your sql statement in this lib
i use this type

resourcestring
udfsql1 = 'select myudf(" %s " from rdb$database ';



when you are calling from your form
uses sqllib

query1.close;
query1.sql.text:=format(udfsql1,[edit1.text]);
query1.open






Ibrahim Bulut
Software Developer
Republic of Turkey

----- Original Message -----
From: "Jeges Endre" <jeges@...>
To: <ib-support@yahoogroups.com>
Sent: Tuesday, July 02, 2002 4:26 PM
Subject: Re: [ib-support] UDF argument can't be query-parameter


> Hello again!
>
> On Tue, 2 Jul 2002, ibrahim Bulut wrote:
>
> > you can't use argument with udf
> > i do it with thi stype
> >
> > Query1.close;
> > Query1.sql.text:='SELECT MYUDF "' + edit1.text + '" from rdb$database';
> > Query1.open
>
> Thanks for the answer!
>
> Yeah probably that would do the trick. Finally I did that to make my
> sql work, but is there a more elegant solution where I can keep the
> parameters? Sorry, I beleive in that :).
>
> Regards,
> jeges
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>