In the newer versions, when the system creates a report or form download file, the first line of the *.RPT or *.FRM file is:
DROP REPORT YourReportName Or DROP Form YourFormName So, this is automatically done for you, and you don’t need to add a DROP command. Javier, Javier Valencia, PE 14315 S Twilight Ln Olathe, KS 66062 913-915-3137 From: [email protected] <[email protected]> On Behalf Of Doug Hamilton Sent: Sunday, February 16, 2025 3:36 PM To: [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 --- 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> . <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 --- 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/8bc408ec-9848-4c6b-bdb9-2adc75dad95c%40wi.rr.com <https://groups.google.com/d/msgid/rbase-l/8bc408ec-9848-4c6b-bdb9-2adc75dad95c%40wi.rr.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/009b01db80f6%24e36b1ec0%24aa415c40%24%40vtgonline.com.
