Subject Re: SQL or Array Rowset ?
From Robbie Nott <>
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

This is new and unchartered territory - fun !