Subject Re: SQL or Array Rowset ?
From Akshat Kapoor <>
Date Tue, 6 Apr 2021 19:43:15 +0530
Newsgroups dbase.getting-started

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
Closing Stock

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)