SQL Queries in Microsoft NAV?

arunjan387

Hello everyone,

Can we use SQL queries in NAV for Database Operations and for Report writing?

Sog

No, except if you go completely around with a .com object, accessing the database with your own connector.
But using the NAV session, its not possible.

kriki

Using ADO you can. Check http://dynamicsuser.net/blogs/waldo/archive/2008/01/06/using-stored-procedures-in-c-side.aspx