That would work as long as the actual message in the popup was the same each time. But really, the short few lines to make up a popup doesn't scale very well compared the the lenght of the RUN SELECT command.
----- Original Message ----- From: "Dennis McGrath" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Friday, October 28, 2011 3:43 PM Subject: [RBASE-L] - Re: procedures in table Forget my previous message. Instead, create a variable that contains your complete command, i.e. vPopupWhatever Then you say &vPopupWhatever to display the popup. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Friday, October 28, 2011 2:33 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: procedures in table Mike, I thought that is what I was doing. I am only trying to replace the code in forms where the POP UP box is exactly the same for, in this case, a pause message that I want to say the exact same thing wherever I use it. The rest of the code in the form stays the same. I just wanted to know if within an IF THEN statement I cannot use this method to bring up the pause box. If I can, what should I do differently. James Belisle Making Information Systems People Friendly Since 1990 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Mike Byerley Sent: Friday, October 28, 2011 2:23 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: procedures in table Jim, This isn't an answer to your problem, but replacing form code with code run from a table on a wholesale level is not an improvement, but that is up to you. Places where it is opportune to do so is where the "exact" same code block is used across many forms or in places where you cannot place much code, like table level and row level eeps. ----- Original Message ----- From: "Jim Belisle" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Friday, October 28, 2011 3:04 PM Subject: [RBASE-L] - procedures in table I am trying to replace code in my forms with code placed in a table. I have been partially successful. If I run this line of code OUTSIDE of an IF THEN statement, all works well. RUN SELECT Code_File FROM CMDTable WHERE Code_Number = 210 This is the code in Code_File above: -- Pause 3 with Gauge. JPB PAUSE 3 USING 'Calculating ... Please Stand By ...' + CAPTION .vgaugemsg + ICON WINDOWS OPTION GAUGE_VISIBLE ON + |GAUGE_COLOR RED + |GAUGE_INTERVAL 10 + |MESSAGE_FONT_NAME VERDANA + |MESSAGE_FONT_SIZE 10 + |MESSAGE_FONT_COLOR WHITE + |THEMENAME Steel Blue RETURN If I run the same code within an IF THEN statement, it does not work. ANY IDEAS? We use 7.6. James Belisle Making Information Systems People Friendly Since 1990
