Ajay, I don't know if you solved this or not but I may have run in to it. Here's my guess as to what's happening and a possible solution.
Your OnBeforeDesign starts with the DROP TABLE statement, then you try to recreate the temporary table required for the report, but it has a syntax error which doesn't allow the report to open. Something like: DROP TABLE tmptbl CREATE TEMPORRRRRRRRARY TABLE tmptbl + (SomeCol TEXT 9) If it's the driving table of the report that has the syntax error try this: Go into sys_reports3 and change the SYS_TABLE_NAME to NewTmpTbl CREATE NewTmpTbl from the R> Your report should now open. Just a guess. Duey -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MikeB Sent: Thursday, March 12, 2009 9:50 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Error in Before design EEP Ajay, I put the following in a test report in the OnBeforeDesign PAUSE 2 USING 'before design' SELECT IN WHERE x = z RETURN It throws the syntax error, but still loads the report in the designer. I also created an RMD file with the following: trace pause 2 using 'tracing' Report TestRep ret Which also put RBase into trace mode and opened the report, tracing the OnBeforeDesign eep. Try it and see if you can at least get to the code to see the offending line... ----- Original Message ----- From: <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Thursday, March 12, 2009 10:22 AM Subject: [RBASE-L] - Re: Error in Before design EEP > Hi Bill > > Thanks for your reply. I tried the trace but I still could not open up the > report in the designer. It seems to abort the whole process once it > encounters the syntax error. > Any other ideas? > > Ajay > > > > Bill Downall <[email protected]> > Sent by: [email protected] > 03/11/2009 06:33 PM > Please respond to > [email protected] > > > To > [email protected] (RBASE-L Mailing List) > cc > > Subject > [RBASE-L] - Re: Error in Before design EEP > > > > > > > Ajay, > > What happens if you > > SET TRACE ON > EDIT USING FORMNAME > > And step through your temp view creation? > > Does it give you a chance to edit it? > > Bill > > On Wed, Mar 11, 2009 at 6:24 PM, <[email protected]> wrote: > > Hello List > > I made a big BOO BOO!! I have a complex report which runs on many temp > views and tables. The reports was an is working correctly. However, I put > all the temp view creations in the BEFORE DEIGN EEP in the report. I have > a typo and now my report will not open in the designer. It gives me the > error message and thats it. Is there anyway I can edit my EEP to solve my > problem. > > Any help is greatly appreciated. > > Thanks all > > Ajay > > P > Please consider the environment before printing this e-mail. Thank you. > > > > > > > P > Please consider the environment before printing this e-mail. Thank you. > > > --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
