Query class vs. Select

Finance and Operations/AX Developer Forum
1

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]

Thomas

2

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.