Okay, I already got it: sqlwhereITEMS.add is doing the magic
(instead of sqlwhere.add I've tried before)...

Regards
Gunther

Am 29 May 2005 um 20:10 hat G. Nau geschrieben:

> I'm trying to feed this SQL into an IB_Query:
> select ref,bestellnr,lagerort,artikelname from lagerkarte where
> upper(artikelname) like '%RT-M%'
>
> but the where part is rejected with "Token unknown upper".
>
> How do change the basic query without where-clause to the above
> where-clause at runtime?
>
> Regards
> Gunther
>
>
>
>
>
> ___________________________________________________________
> Gesendet von Yahoo! Mail - Jetzt mit 1GB Speicher kostenlos - Hier anmelden: http://mail.yahoo.de
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>
>
>

___________________________________________________________
Gesendet von Yahoo! Mail - Jetzt mit 1GB Speicher kostenlos - Hier anmelden: http://mail.yahoo.de