Subject Re: SQL or Array Rowset ? From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Mon, 5 Apr 2021 17:27:11 +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" I am making some assumptions. 1. When a quoting is done you store the quot in a table. 2. In this table you store the inventory data also of that time. So that whenever you have a look at the quote you have the exact figures. My recommendations : Do not store the inventory figures as they will keep on changing. Or Just before viewing update them. (Will be required if you are using arrayrowset) With proper sql retreiving data from 2 tables linked using a key field can be accomplished very easily using joins. But with local sql I was unable to find how to link two tables into a single rowset. Will try to find some old code where I had accomplished this but it will take some time. Meanwhile I would request you to post empty tables with details of how to link rows i.e. key field and I will try to find a sql for you. (Table with few dummy rows will be of immense help) I do not have 2019 and hence cannot test arrayrowset. I did try using them and was successful in displaying values in a grid but my trial period expired and I did not do much. Regards Akshat