General downloads

NAV 2013 SQL Query Codeunit

Author
Dynamic Manufacturing Solutions  
Category
General downloads
Date
25/11/2012
Size
37,02 KB
Downloads
1309
MD5 digest
2F3E1565A80ADC2615376582DF18B34F
Rating
54321
Popularity
Downloaded 5 times in the last two weeks
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 allows you 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.

Note that users will be required to have select access to the tables in SQL Server to run this code.
Download this file