Subject Re: SQL or Array Rowset ? From Akshat Kapoor <akshat.kapoor@kapoorsons.in> 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) Regards Akshat