stored procedures have nothing to do with whether or not your code is compiled. I really think as long as you are not using the restricted commands that Mike B made reference to, the best solution would be to use a stored procedure. You would just make a new stored procedure and feed it the path of your command file, and then it is stored in the database for you, and instead of using run to execute the command file you use call to execute your internally stored command file. check out the stored procedures and call in the help files.
Jeff Watson [EMAIL PROTECTED] Tube Methods, Inc. 610-279-7700 From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Emmitt Dove Sent: Thursday, January 03, 2008 11:04 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: storing code in the database Jeffrey, I want to move all disk-based code into the forms/reports/database so all that is required on disk is a startup file. Yes, we could compile, but as we have to access the app from multiple versions of R:BASE, I want to delay that. Even compiled, I like the ability to change code without having to recompile. Emmitt Dove Manager, DairyPak Business Systems Blue Ridge Paper Products, Inc. [EMAIL PROTECTED] [EMAIL PROTECTED] (203) 643-8022 From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jeffrey M. Watson Sent: Thursday, January 03, 2008 10:47 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: storing code in the database Emmitt I would imagine the best way would be to incorporate those on-disk files as stored procedures or if they are only used local to one form, as a form action. But you know your needs best, perhaps you have a reason to want to do it this way? Jeff Watson [EMAIL PROTECTED] Tube Methods, Inc. 610-279-7700 From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Emmitt Dove Sent: Thursday, January 03, 2008 10:43 AM To: RBASE-L Mailing List Subject: [RBASE-L] - storing code in the database Has anyone undertaken a large-scale effort to store code in the database? Not the code in forms or eeps, but command file code that otherwise would reside on disk, and when stored in a table is executed with a RUN SELECT ... I'm particularly interested in your table structure to accomplish this. Emmitt Dove Manager, DairyPak Business Systems Blue Ridge Paper Products, Inc. [EMAIL PROTECTED] [EMAIL PROTECTED] (203) 643-8022
