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
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.