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
