Simple codeunit enables users to execute an SQL query to populate any NAV (temporary) table using one call
For those times when the new Query objects (as good as they are) just aren’t enough, and you’re desperate for direct SQL access as a last resort. Simple codeunit enables users to execute an SQL query to populate any NAV (temporary) table using one call. Test page is included to demonstrate functionality with a simple query. 2013 version does not use COM (all code runs on NST), but zip file also includes COM version for pre-R2 NAV.