Razzak,What about the simpler:DROP FORM formnameDROP LABEL labelnameDROP REPORT
reportnameoras variable
DROP FORM .FORMTODROPDROP LABEL .LABELTODROPDROP REPORT .REPORTTODROP
Jim Bentley, American Celiac Society 1-504-305-2968
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.
--
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.
--
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.
