How to run SQL quary using NAV ?

Hi Expert ,

I want to run SQL quary(“select sum(Quantity) as Stock from [CRONUS International Ltd_$Item Ledger Entry] where [Item No_] =‘1968-S’”) using NAV Service/Object. is it possible ? if yes then how it can be possible ?

Thanks

Surajit

Which version are you using?

Using ADO connection you can run SQL Queries.

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

Hi expert,

i am using NAV 2009 R2

Thanks

Surajit

Did you try above link?

Is it working?

From what environment are you trying to run this statement?