Subject Re: SQL or Array Rowset ? From Robbie Nott <robnott@mweb.co.za> Date Tue, 6 Apr 2021 16:54:29 +0200 Newsgroups dbase.getting-started On 4/6/2021 4:08 PM, Akshat Kapoor wrote: > 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 Hi Akshat Many thanks for your response I will certainly give that a try. Would much rather do the processing up front and then display it. Should be able to drop the inventory status table currently being displayed.... This is new and unchartered territory - fun ! Regards Robbie