Subject SQL or Array Rowset ? From Robbie Nott <robnott@mweb.co.za> Date Mon, 5 Apr 2021 10:59:54 +0200 Newsgroups dbase.getting-started Quoting program does lots of calcs, then as a side window shows the items in the quote vs the latest inventory figures. All the quote and inventory data is stored in tables. All good.... Then, a few months later, client comes back to the quote but now the inventory "snapshot" is out of date. Looking for assistance please with creating an SQL statement where the No-On-Hand and balance columns can be "live" Have thought of 2 possibilities 1) The new array rowset 2) An SQL statement where the # on hand and balance could be calculated fields. Have no experience with either of the above... As the program is already doing a bunch of calcs speed is the deciding factor. Please advise as to which one would be faster and how to get started with it. Regards and thanks Robbie Nott