At 08:06 AM 11/29/2012, Michael J. Sinclair wrote:
Can anybody remember how to back up and restore a report from Rbase for DOS?
Here's how ...
-- To Backup/Unload One Report
CONNECT dbname
OUTPUT filename.rpt
UNLOAD DATA FOR SYS_REPORTS WHERE SYS_REPORT_NAME8 = 'reportname'
OUTPUT SCREEN
-- To Backup/Unload Multiple Reports
CONNECT dbname
OUTPUT filename.rpt
UNLOAD DATA FOR SYS_REPORTS WHERE SYS_REPORT_NAME8 IN
(reportname1,reportname2,reportname3)
OUTPUT SCREEN
-- To Backup/Unload All Reports
CONNECT dbname
OUTPUT filename.rpt
UNLOAD DATA FOR SYS_REPORTS
OUTPUT SCREEN
-- To Restore One Report
CONNECT dbname
DELETE ROWS FROM SYS_REPORTS WHERE SYS_REPORT_NAME8 = 'reportname'
RUN filename.rpt
-- To Restore Multiple Reports
CONNECT dbname
DELETE ROWS FROM SYS_REPORTS WHERE SYS_REPORT_NAME8 IN
(reportname1,reportname2,reportname3)
RUN filename.rpt
-- To Restore All Reports
CONNECT dbname
DELETE ROWS FROM SYS_REPORTS
RUN filename.rpt
Have fun!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--- 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.
================================================
