I may be naive but why not go into the Database explorer and UNLOAD the report from the test database which will get you the two files. Then copy the files to the active folder for your production database. Open the database and then in Database explorer LOAD the report???
Larry Nemetz, DVM The BIRD Clinic Veterinary Corp 200 S Tustin St, #E Orange, CA 92866 (714) 633-2910 [email protected] From: 'Karen Tellef' via RBASE-L <[email protected]> Sent: Saturday, February 15, 2025 1:09 PM To: [email protected] Subject: Re: [RBASE-L] - 6.5++ WIndows Not sure if this'll help, Ron, but I had created this routine for 6.5 windows that I would use to create my report files. It does look like your syntax (altho I use "#1" instead of the long column name). Try copying this code into a program file and run it? Obviously change my hard-coded directory SET VAR vformname TEXT = NULL SET VAR vfilename TEXT = NULL set null -0- WHILE 1 = 1 THEN SET VAR vformname = NULL, vfilename = NULL DIALOG 'Enter WINDOWS report name:' vformname vendkey 1 IF vformname IS NULL THEN BREAK ENDIF SET VAR vText = (SGET(.vformname,8,1)) SET VAR vfilename = ('c:\temp\tempf\' + .vText + '.REP') DIALOG 'Enter filename:' vfilename vendkey 1 IF vfilename IS NULL THEN BREAK ENDIF OUTPUT .vfilename WRITE 'DROP REPORT', .vformname UNLOAD DATA FOR SYS_REPORTS2 WHERE #1 = .vformname OUTPUT SCREEN TYPE .vfilename pause ENDWHILE dir c:\temp\tempf Karen On Saturday, February 15, 2025 at 12:47:48 PM CST, Ronald C Peterson <[email protected]<mailto:[email protected]>> wrote: How can I move a report from my test database into a production database. Here is the routine I run: OUTPUT "reportname".rpt write "delete rows from SYS_REPORTS2 whe sys_report_name = ""reportname""" ---This will delete the old report if there was one. unload data from SYS_REPORTS2 WHE SYS_REPORT_NAME = "reportname" OUTPUT SCREEN This creates both the "reportname.rpt" and "reportname.lob" files When I go to the production system and run the "reportname.rpt" file from the R> prompt it crashes me out of Rbase and doesn't add the new/replaced report. Thanks for any help you can provide. Ron Peterson -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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]<mailto:[email protected]>. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/DS0PR84MB341921A2BE4CC8BAFE6B8DD6C8F92%40DS0PR84MB3419.NAMPRD84.PROD.OUTLOOK.COM<https://groups.google.com/d/msgid/rbase-l/DS0PR84MB341921A2BE4CC8BAFE6B8DD6C8F92%40DS0PR84MB3419.NAMPRD84.PROD.OUTLOOK.COM?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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]<mailto:[email protected]>. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/1909871544.522081.1739653723296%40mail.yahoo.com<https://groups.google.com/d/msgid/rbase-l/1909871544.522081.1739653723296%40mail.yahoo.com?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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]. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/CY5PR11MB6259E362ADC53293FDD31CA7BAF92%40CY5PR11MB6259.namprd11.prod.outlook.com.
