INTERNET APPLICATION DEVELOPMENT
MID MARKET ERP DEVELOPMENT
by Kristi Feng
Last week, I came across a discussion in the Sage 300 ERP VBA forum with a very interesting view of CS0120.
When creating customization projects, I often find the need to search for a field in a record that is not originally part of the index key or requires me to use a complex SQL query statement.
While I usually retrieve data by connecting to the database using MS ADO, I also learned I can accomplish this same function by using the CS0120 view.
This is a sample of code returning the top three highest balance customers by using CS0120.
CS0120 eliminates the need to compose the connection string and connect to the Sage 300 ERP company database.
I hope you find this information as helpful as I did. Thank you for taking time to read the blog.