||Re: SQL or Array Rowset ?
Akshat Kapoor <firstname.lastname@example.org>
||Tue, 6 Apr 2021 19:43:15 +0530
Good Evening Robbie,
> Many thanks Akshat
> I'm going to try creating field objects and attaching them to my table
> that way I can keep everything fresh.
> Hoping that it won't make much of a performance difference as it's
> already a big program.
> Will let you know.
If you try to implement this then add a column. Donot replace any column
with closing stock.
I always maintain 2 columns
Opening stock is never changed.
Closing stock is update after every transaction
But if there is some error in processing at some time I can always re
calculate the closing stock and update it.
(And this can happen at times eg. network loss)