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
---
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/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>.
--
This email has been checked for viruses by Avast antivirus software.
www.avast.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/8bc408ec-9848-4c6b-bdb9-2adc75dad95c%40wi.rr.com.
