Try this : While select InventTable
Where (InventTable.ItemId == _itemId || !_itemId) Regards Palle Mølgaard ________________________________ From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Syner P Sent: 13. december 2007 09:20 To: [EMAIL PROTECTED]; development-axapta@yahoogroups.com Subject: [development-axapta] 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 <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]
