Hi, You could also do like this:
While select InventTable Where (InventTable.ItemId == _itemid || !_itemid) This will limit the query to get a single item if the parameter has been filled out, and all items will be fetched if it has not been set. Regards, Anders Sorensen This posting is provided "AS IS" with no warranties, and confers no rights. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Syner P Sent: 13. december 2007 09:20 To: [EMAIL PROTECTED]; development-axapta@yahoogroups.com Subject: [Axapta-Knowledge-Village] Select statement 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] [Non-text portions of this message have been removed]