I understand. I am trying new things based on what I see in these threads. A few months back (or maybe weeks) people were talking about putting code in a table and using it. It looked like an easy way to streamline the code in my forms. Since I am trying to use more than one type of box, it seemed the perfect use for what they were talking about.
James Belisle Making Information Systems People Friendly Since 1990 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Friday, October 28, 2011 2:38 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: procedures in table Why not Create a text variable in your startup code that contains the message? Then you use that variable in the popups. 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
