| Subject | TIB_Query.SQLWhere: How to feed "where upper(artikelname) like '%RT-M%'" into it? |
|---|---|
| Author | G. Nau |
| Post date | 2005-05-29T18:10:04Z |
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
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