RE: [RBASE-L] - Stored Procedures
Thanks Karen. I had just come to that conclusion and was about to report my mistake. Have a great day! Claudine From: 'Karen Tellef' via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: Thursday, November 15, 2018 12:58 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Stored Procedures The problem is that you bring up the form in MDI mode. When you do that, the procedure that calls it ALWAYS continues. You cannot bring up a form in MDI unless the rest of the program code doesn't rely on anything in that form. Take out the MDI Karen -Original Message- From: Claudine Robbins To: rbase-l@googlegroups.com Sent: Thu, Nov 15, 2018 12:52 pm Subject: [RBASE-L] - Stored Procedures I have a new issue with a stored procedure routine which goes like this: I call the SP NewCompanies(1) to pass a value of 1 to the SP STEP 1 I use the DIALOG to get the user’s input on the company name they want to add. STEP 2 I then EDIT USING FORMCHOOSE MDI AS ‘PICKONE’ which takes the user value and bring up the form. On the form is a button to (i) set a variable vContinue to Y in order to proceed and (ii) to CLOSEWINDOW PICKONE STEP 3 Back in the SP, I test the vContinue value for further action. The problem is the SP code runs all the way through to the return before the FORMCHOOSE comes up on the screen. It goes STEP 1, STEP 2, tests vContinue which is initialized to N, exits the SP, then shows the FORMCHOOSE… Any ideas? TIA, Claudine -- 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 rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>. For more options, visit https://groups.google.com/d/optout. -- 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 rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>. For more options, visit https://groups.google.com/d/optout. -- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Stored Procedures
The problem is that you bring up the form in MDI mode. When you do that, the procedure that calls it ALWAYS continues. You cannot bring up a form in MDI unless the rest of the program code doesn't rely on anything in that form. Take out the MDI Karen -Original Message- From: Claudine Robbins To: rbase-l@googlegroups.com Sent: Thu, Nov 15, 2018 12:52 pm Subject: [RBASE-L] - Stored Procedures !-- #yiv9876259704 _filtered #yiv9876259704 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} #yiv9876259704 #yiv9876259704 p.yiv9876259704MsoNormal, #yiv9876259704 li.yiv9876259704MsoNormal, #yiv9876259704 div.yiv9876259704MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri", "sans-serif";} #yiv9876259704 a:link, #yiv9876259704 span.yiv9876259704MsoHyperlink {color:blue;text-decoration:underline;} #yiv9876259704 a:visited, #yiv9876259704 span.yiv9876259704MsoHyperlinkFollowed {color:purple;text-decoration:underline;} #yiv9876259704 span.yiv9876259704EmailStyle17 {font-family:"Calibri", "sans-serif";color:windowtext;} #yiv9876259704 .yiv9876259704MsoChpDefault {font-family:"Calibri", "sans-serif";} _filtered #yiv9876259704 {margin:1.0in 1.0in 1.0in 1.0in;} #yiv9876259704 div.yiv9876259704WordSection1 {} --I have a new issue with a stored procedure routine which goes like this: I call the SP NewCompanies(1) to pass a value of 1 to the SP STEP 1 I use the DIALOG to get the user’s input on the company name they want to add. STEP 2 I then EDIT USING FORMCHOOSE MDI AS ‘PICKONE’ which takes the user value and bring up the form. On the form is a button to (i) set a variable vContinue to Y in order to proceed and (ii) to CLOSEWINDOW PICKONE STEP 3 Back in the SP, I test the vContinue value for further action. The problem is the SP code runs all the way through to the return before the FORMCHOOSE comes up on the screen. It goes STEP 1, STEP 2, tests vContinue which is initialized to N, exits the SP,then shows the FORMCHOOSE… Any ideas? TIA, Claudine -- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[RBASE-L] - Stored Procedures
I have a new issue with a stored procedure routine which goes like this: I call the SP NewCompanies(1) to pass a value of 1 to the SP STEP 1 I use the DIALOG to get the user's input on the company name they want to add. STEP 2 I then EDIT USING FORMCHOOSE MDI AS 'PICKONE' which takes the user value and bring up the form. On the form is a button to (i) set a variable vContinue to Y in order to proceed and (ii) to CLOSEWINDOW PICKONE STEP 3 Back in the SP, I test the vContinue value for further action. The problem is the SP code runs all the way through to the return before the FORMCHOOSE comes up on the screen. It goes STEP 1, STEP 2, tests vContinue which is initialized to N, exits the SP, then shows the FORMCHOOSE... Any ideas? TIA, Claudine -- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.