Don't forget to SET NULL '-0-' after connecting and before UNLOAD If null is not -0- your reports will be weird or not work at all
Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Thursday, November 29, 2012 7:23 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Moving a report in Rbase for Dos 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. ================================================
