It's been a while since I worked with 6.5, and I may be missing part of the thread or code. Accept my apology if I missed something earlier. When I look at your code - and maybe this is only part of it of the code, but it's showing your deleting the rows first, then unloading data that would not exist. If that's on the production db, ok for deleting the rows if they exist, but then you would load the new report.
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 From: "Ronald C Peterson" <[email protected]> To: "rbase-l" <[email protected]> Sent: Sunday, February 16, 2025 6:11:52 PM Subject: Re: [RBASE-L] - 6.5++ WIndows MY quotes setting is the double " quote. this was just recently updated to windows from DOS and that was one edit we didn't do at the time. I've since found out that if I try to unload all the reports, deleting all the existing rows in the production database, it does the delete but not a single one of the moved reports gets loaded. This leaves me with having to add new reports directly in the production files and perform all edits in production files as well. We are looking forward to upgrading to the current version 11 which will save a lot of hassle. From: [email protected] <[email protected]> on behalf of Doug Hamilton <[email protected]> Sent: Sunday, February 16, 2025 4:35 PM To: [email protected] <[email protected]> Subject: Re: [RBASE-L] - 6.5++ WIndows Are your Quotes setting the same in both dbs? Single quotes vs double vs ` (backward quote, a "tilde quote") BTW, I like your idea of putting the delete reportname in the .rpt file. I might do something like that for forms. Doug On 2/15/2025 12:47 PM, Ronald C Peterson 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 | 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 [ mailto:[email protected] | [email protected] ] . To view this discussion visit [ https://groups.google.com/d/msgid/rbase-l/DS0PR84MB341921A2BE4CC8BAFE6B8DD6C8F92%40DS0PR84MB3419.NAMPRD84.PROD.OUTLOOK.COM?utm_medium=email&utm_source=footer | https://groups.google.com/d/msgid/rbase-l/DS0PR84MB341921A2BE4CC8BAFE6B8DD6C8F92%40DS0PR84MB3419.NAMPRD84.PROD.OUTLOOK.COM ] . [ https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient ] Virus-free. [ https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient | www.avast.com ] -- For group guidelines, visit [ http://www.rbase.com/support/usersgroup_guidelines.php | 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 [ mailto:[email protected] | [email protected] ] . To view this discussion visit [ https://groups.google.com/d/msgid/rbase-l/8bc408ec-9848-4c6b-bdb9-2adc75dad95c%40wi.rr.com?utm_medium=email&utm_source=footer | https://groups.google.com/d/msgid/rbase-l/8bc408ec-9848-4c6b-bdb9-2adc75dad95c%40wi.rr.com ] . -- For group guidelines, visit [ http://www.rbase.com/support/usersgroup_guidelines.php | 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 [ mailto:[email protected] | [email protected] ] . To view this discussion visit [ https://groups.google.com/d/msgid/rbase-l/DS0PR84MB34192006591F592FAA6E45AEC8F82%40DS0PR84MB3419.NAMPRD84.PROD.OUTLOOK.COM?utm_medium=email&utm_source=footer | https://groups.google.com/d/msgid/rbase-l/DS0PR84MB34192006591F592FAA6E45AEC8F82%40DS0PR84MB3419.NAMPRD84.PROD.OUTLOOK.COM ] . -- Guy W. Ellenberger Phone: 814.288.7719 [ mailto:[email protected] | Email: [email protected] ] -- 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/1715571134.16495638.1739748539662.JavaMail.zimbra%40gwenetworks.com.
