Boy I can't begin to guess why that would happen
I still have a version of 6.5 here. If you want, personally email me with the
files and let me see if I can load it into an old 6.5 database
Karen
On Tuesday, February 18, 2025 at 08:15:35 AM CST, Ronald C Peterson
<[email protected]> wrote:
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".rptwrite "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
[email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/DS0PR84MB341921A2BE4CC8BAFE6B8DD6C8F92%40DS0PR84MB3419.NAMPRD84.PROD.OUTLOOK.COM.
--
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
[email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/1909871544.522081.1739653723296%40mail.yahoo.com.
--
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.
--
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/125679513.1265453.1739889788174%40mail.yahoo.com.
