Subject Re: SQL or Array Rowset ? From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Tue, 6 Apr 2021 19:38:38 +0530 Newsgroups dbase.getting-started Good Evening Robbie, > 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. After going through all your responses I will recommend arrayrowset for this task. You take quotation table and insert the values. You calculate the stock and change the required values. And then display in a grid. Regards Akshat