That did the trick! A thousand thank yous!! What I have learned is that when I did the Unload all to create a new database in Rbase 9.5 32, my old DOS reports don't work, which makes sense. Soon I won't need them. But for now there were a few DOS reports that I was still using. Now I have the best of both worlds! Mike Sinclair
________________________________ From: A. Razzak Memon <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Thu, November 29, 2012 8:24:13 AM 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
