Archive of posts tagged temporary table

Query/QueryRun with temporary tables (AX/F&O)

Posted by on

I noticed that some developers believe that Query* classes can’t be used to query temporary tables. It is possible; it just requires an extra step that isn’t needed with regular tables. When working with temporary tables, each buffer (variable) of the same table can refer to a different set of temporary data. Therefore using the …

Continue reading ‘Query/QueryRun with temporary tables (AX/F&O)’ »

AX, temporary table, Unit Test and DuplicateKeyException

Posted by on

Why do I link AX, temporary table, unit test and DuplicateKeyException? Because if I put them together, it behaves quite strangely. I have a temporary table, I insert some data into it and in an exceptional case, when a duplicity occurs, I catch the DuplicateKeyException and simply ignore such insert. And it works correctly. The …

Continue reading ‘AX, temporary table, Unit Test and DuplicateKeyException’ »