Hi Use "like" instead of "*" while select inventTable where inventTable.itemId like _itemId
br Ingus Ziedinsh --- In development-axapta@yahoogroups.com, 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] >
