NAV 2013 SQL Query Codeunit

///NAV 2013 SQL Query Codeunit
NAV 2013 SQL Query Codeunit2017-11-06T18:13:02+00:00

Simple codeunit enables users to execute an SQL query to populate any NAV (temporary) table using one call

NAV 2013 SQL Query Codeunit

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.

Download NAV 2013 SQL Query Codeunit