General downloads

NAV 2013 SQL Query Codeunit

Author
Dynamic Manufacturing Solutions  
Category
General downloads
Date
25/11/2012
Size
37,02 KB
Downloads
1560
MD5 digest
2F3E1565A80ADC2615376582DF18B34F
Rating
54321
Popularity
Downloaded 15 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