A view might get the results your after with a procedure to update your inventory levels . As you mentioned nested cursors will achieve what your after and their performance if correctly used is lightning fast.
On Tue, 15 Dec 2020, 8:13 am 'Jim Belisle' via RBASE-L, < [email protected]> wrote: > Background: We ship out products that are unassembled. That means what we > ship out are individual parts and assemblies we make. > > Problem: We want to look at a form I am creating so that any part looked > at for any product on an open order, the user will be able to see if our > existing inventory has that part covered. This is based upon the date we > plan we ship it. > > Goal: I am trying to update usable inventory based upon part numbers used > in a product and promised ship dates. > > > > So the code I need is code that will look at the table where this info is > located, find each part, find the promised date (ascending), find the > product the part belongs to, then update the needed amt to 0 (for > scheduling the hours needed) if we have the parts available. The actual > inventory amount will not change, but the variable used during the process > will update to take the actual inv amt, subtract the amt needed to fill the > next promised date for that part belonging to the product. > > > > So we want to be able to look at the form in this manner. > > Part product promised qty > need need to make start inv amt inv left var > > Part A 8BLA15 01/05/2021 > 15 0 100 85 > > Part A 8BLA16 01/05/2021 > 15 0 70 > > Part A 8BLA17 01/08/2021 > 75 5 0 > > > > I was looking at using CURSORS to do the job but not sure if that is the > most efficient way. Nor was I sure of how to set up a multiple cursor code. > > I think I would need a nested or maybe a double nested cursor. > > > > Any thoughts? > > > > James Belisle > > > > *Making Information Systems People Friendly Since 1990* > > > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB339480EDA63A37780DC9E045A0C70%40CY4PR0201MB3394.namprd02.prod.outlook.com > <https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB339480EDA63A37780DC9E045A0C70%40CY4PR0201MB3394.namprd02.prod.outlook.com?utm_medium=email&utm_source=footer> > . > -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CABnhDASETdBoYPBBchw%3DRXaVU2vZm8WF80gZ5avU8JcUT3%2BjYw%40mail.gmail.com.
