Yes, definitely break this into smaller components and endeavor to keep ONLY those variables in play that are needed to complete the entire procedure. I know it is difficult in the RBase programming environment to think of compartmentalizing (encapsulating in the OO world) your code into smaller WorkProcedures, but it makes debugging and maintaining code less of a chore. It is unusual in the VB environment for a Sub or Function to grow to more than 20 or 30 lines of code unless there is a lengthy Select Case / End Select (RB Switch EndSw) statement. If it starts growing bigger than that, then I start breaking it down in to a separate procedure and in a lot of cases, a Stored Procedure. I was mostly alarmed that you said you had a couple hundred variables declared and active at one time....
----- Original Message ----- From: "Sami Aaron" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, February 18, 2003 1:16 PM Subject: [RBASE-L] - Re: Crashing > Dan - > > Here is what I would do in your situation: > > 1. Reload the database (just in case ...) > > 2. Run the commands thru RStyle to see if you have any syntax errors or > unbalanced quotes or parens. > > 3. Break the code up into smaller sections, commenting out whole sections > to see if you can see what sections ARE working and eliminate those. > > 4. Use the F-10 key with the tracer and see how far you get. > > ----------------------------------------------------------------- > Sami Aaron > Software Management Specialists > 19312 W 63rd Terr > Shawnee KS 66218 > mailto:[EMAIL PROTECTED] > 913-915-1971 > > > ----- Original Message ----- > From: "Dan Champion" <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> > Sent: Tuesday, February 18, 2003 11:24 AM > Subject: [RBASE-L] - Crashing > > > > > > > > >Hi, > > > > I have an application that started crashing on occasion a few months > > ago. It is very deep in the process of the code, and I cannot seem to > > determine the cause. > > I have used trace, but it always stops tracing before it gets to that > > point. I have tried to determine if there are variables being re-typed > > improperly, but don't see that either. > > Any ideas what else I might look for? The process always crashes (dumps > > the user back out to the R:> instead of returning to a menu, after the > same > > set of events, At that point there are nearly 200 variables that are in > > use, and are all typed correctly. > > > > Thanks in advance, > > Dan > > > > > > > > > > Dan Champion > > P.O. Box 223 > > Grandville, MI. 49428-0223 > > www.championsolutions.net > > > > > > > > > >
