James,
Yes, you can!
Very Best R:egards,
Razzak
At 11:06 AM 11/13/2016, Jim Bentley wrote:
Razzak,
What about the simpler:
DROP FORM formname
DROP LABEL labelname
DROP REPORT reportname
or
as variable
DROP FORM .FORMTODROP
DROP LABEL .LABELTODROP
DROP REPORT .REPORTTODROP
From: MD <[email protected]>
To: [email protected]
Sent: Saturday, November 12, 2016 8:24 PM
Subject: Re: [RBASE-L] - DELETE a form or report programatically
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.
