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