Hi Syner,
You can use like in your while statement.
Syner P <[EMAIL PROTECTED]> wrote: Hi,
I have problem with a report query. In fetch method, I used 'while select'
statement with several criterion. But when the user passes blank criteria, I
want to use this like '*' in queries. But it doesn't work.
Ex:
If (!_ItemId) _ItemId='*';
while select InventTable
where ItemId==_ItemId
...
Any help appreciated.
Syner
__________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search.
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
[Non-text portions of this message have been removed]
---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search.
[Non-text portions of this message have been removed]