Re: [RBASE-L] - proper code

2020-12-14 Thread Tony Luck
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, < rbase-l@googlegroups.com> wro

[RBASE-L] - proper code

2020-12-14 Thread 'Jim Belisle' via RBASE-L
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