"Select" statement is not dynamic, you cannot add filtering conditions at runtime whereas, using "Query" you can prompt the user to add/change filtering criteria at runtime. Regards Diwakar
________________________________ From: pranam mukher <pranam_shub...@yahoo.co.in> To: axa knwoldge <axapta-knowledge-vill...@yahoogroups.com> Cc: dev ax <development-axapta@yahoogroups.com> Sent: Thu, 29 July, 2010 4:39:51 AM Subject: [development-axapta] Queries VS Select hi guys When its feasible to use select and when we need to use Query classes to fetch data from DB. any answers with examples are much appreciated. Thanks Pradeep.si [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]