||Re: SQL or Array Rowset ?
Akshat Kapoor <firstname.lastname@example.org>
||Tue, 6 Apr 2021 19:38:38 +0530
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
> Have no experience with either of the above...
> As the program is already doing a bunch of calcs speed is the deciding
> 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
You take quotation table and insert the values.
You calculate the stock and change the required values.
And then display in a grid.