Thank you Razzak. I simply forgot to go directly yo the system tables. I will implement this technique to clean up the production database. God Bless, Manuel
On November 12, 2016 10:45:37 AM PST, "A. Razzak Memon" <[email protected]> wrote: >Manuel, > >Here's how ... > >To delete a form ... > >DELETE ROWS FROM SYS_FORMS3 WHERE SYS_FORM_NAME = 'FormNameToDelete' > >'FormNameToDelete' could be a variable > >DELETE ROWS FROM SYS_FORMS3 WHERE SYS_FORM_NAME = .vFormName > >To delete a report ... > >DELETE ROWS FROM SYS_REPORTS3 WHERE SYS_REPORT_NAME = >'ReportNameToDelete' > >'ReportNameToDelete' could be a variable > >DELETE ROWS FROM SYS_REPORTS3 WHERE SYS_REPORT_NAME = .vReportName > >To delete a label ... > >DELETE ROWS FROM SYS_LABEL3 WHERE SYS_LABEL_NAME = 'LabelNameToDelete' > >'LabelNameToDelete' could be a variable > >DELETE ROWS FROM SYS_LABELS3 WHERE SYS_LABEL_NAME = .vLabelName > >That's all there is to it! > >Feel free to reach out to me with any questions. > >Very Best R:egards, > >Razzak > > >At 01:34 PM 11/12/2016, MD wrote: > >>I need to right a script that will delete a form or a report >>programmatically. If there a command that can be used to accomplish >>this task. I appreciate your help. > > > >-- >You received this message because you are subscribed to the Google >Groups "RBASE-L" group. >To unsubscribe from this group and stop receiving emails from it, send >an email to [email protected]. >For more options, visit https://groups.google.com/d/optout. -- Sent from my phone. Please excuse my brevity. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
