real solutions for real problems
Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Query   (RSS)
Friday, July 10, 2009 12:20 PM

Disabled columns are sometimes included in SQL Queries created by the Dynamics AX Kernel

Over the last month we were facing a situation where the Dynamics AX 2009 Kernel was generating incorrect SQL Queries in a specific constellation: You have one or more fields (columns) on a table that are based on an Extended Data Type (EDT) This EDT
Posted by EMEAAXTec | 0 Comments
Wednesday, July 08, 2009 6:21 PM

About locking and blocking in Dynamics AX and how to prevent it

The locking of records is necessary to ensure transactions are processed accurately and with a high level of concurrency. Unfortunately the more records are locked the higher is the chance other transactoins are getting blocked resulting in peformance
Posted by EMEAAXTec | 0 Comments
Thursday, April 23, 2009 8:31 AM

The grid filter is doing strange things when filtering for decimal numbers

Dynamics AX has a real nice powerful column / grid filter, and that for many versions. However when you try to filter a column having decimal values for a decimal number you might seeing strange things happen - when you are living in a country having
Posted by EMEAAXTec | 1 Comments
Monday, November 03, 2008 9:59 AM

AOT Query Browser - same as Table Browser

There is a really handy tool available from the axaptapedia site, it allows you to run a table browser type form against AOT query objects: If you’re creating queries in the AOT,it’s useful to be able to see the data they return before you go to the trouble
Posted by EMEAAXTec | 1 Comments
Filed under: , ,
 
Page view tracker