What is ADO and can it be used in Navision?

ADO (ActiveX Data Objects) is a Microsoft technology and is a interface to access data in a database.

So what can ADO be used for in Navision?

  • Execution of SQL Strings (Scripts og Stored Procedures)
  • Creating data in a Queue table
  • Creating views
  • etc….

Essentially it all comes down to execute SQL Scripts / SP – and when you can do that, nothing is impossible 😉

So where could it be usefully to use? I have been using it for big calculations, where I didn’t want to build at specific key with Sum indexes. This is generally because of performance. If the calculated numbers is only used once in a while, and the table contains a lot of records, the performance costs for keys are too high. Also my experience tells me, that executing SQL Scripts / SP is faster the using CalcFields & Flowfields in Navision.

Be the first to comment

Leave a Reply

Your email address will not be published.


This site uses Akismet to reduce spam. Learn how your comment data is processed.