Thanks Karen. I get the same result. When I trace the run file, it deletes the old version of the report but fails to load the new version from the .LOB file. I don't understand this at all. If unload all the reports it works fine but not for a selected one. Ron
________________________________ From: 'Karen Tellef' via RBASE-L <[email protected]> Sent: Saturday, February 15, 2025 4:08 PM To: [email protected] <[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]> 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/DS0PR84MB34198ECD8EED794EFE84E6D7C8F82%40DS0PR84MB3419.NAMPRD84.PROD.OUTLOOK.COM.
