RE: [RBASE-L] - proper code

perfectly. James Belisle Making Information Systems People Friendly Since 1990 [cid:image001.jpg@01D6D485.7CCFA450] From: rbase-l@googlegroups.com On Behalf Of BILL MILYARD Sent: Thursday, December 17, 2020 2:55 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - proper code Jim: I'm not s

Re: [RBASE-L] - proper code

:40 PM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - proper code Karen, Thanks for the code. I tried this below and here is where the problem is. SET ERROR MESSAGE 705 OFF DROP CURSOR c1 DROP CURSOR c2 SET ERROR MESSAGE 705 ON DECLARE c1 CURSOR FOR SELECT partnum + FROM topnopuinf

RE: [RBASE-L] - proper code

Tellef' via RBASE-L Sent: Tuesday, December 15, 2020 10:19 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - proper code CAUTION:This is an EXTERNAL EMAIL, STOP! and think before clicking on any links or opening attachments. Don't have any brilliant ideas for you. But if y

Re: [RBASE-L] - proper code

IF SQLCODE =100 THEN   BREAK ENDIF  *(do stuff with 2nd table)   ENDWHILE ENDWHILEDROP CURSOR c1DROP CURSOR C2 Karen -Original Message- From: 'Jim Belisle' via RBASE-L To: rbase-l@googlegroups.com Sent: Mon, Dec 14, 2020 4:13 pm Subject: [RBASE-L] - proper code

Re: [RBASE-L] - proper code

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

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