Query class vs. Select

Hi Ax friends!

New to AX and new to this forum!

Could someone explain to me the difference beteween using the Query class to retrive data in a report and using
select style like ‘While Select …’

Oh and while i’m at it, is there any why to pass a ANSI sql string to the system much like you can do in C# ASP.NET
using the SqlCommand class?

Tanks!! [:D]


Hi Thomas,

Well… generally, Query can be helpful if you need to allow user to input criteria by themselves… and you can save Query to AOT to reuse it in the future.