Sami I would think the drop report and delete rows from sys_reports... Are one in the same. I believe the drop report is doing a delete rows from sys_report. So I believe the row with the LOB data is still there until the database is reloaded or packed.
Buddy -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Sami Aaron Sent: Thursday, September 15, 2005 10:15 AM To: RBG7-L Mailing List Subject: [RBG7-L] - DROP vs. DELETE ROWS FROM Steve Sweeney & I are having a discussion on the pros/cons of using: DROP REPORT reportname vs. DELETE ROWS FROM SYS_REPORTS3 WHERE #1 = reportname Since earlier versions of R:BASE for Windows came out, DROP REPORT reportname would delete reports from both the DOS and Windows versions of R:BASE, so I started using DELETE ROWS FROM SYS_REPORTS (or SYS_REPORTS2 or SYS_REPORTS3) depending on the version I wanted to drop. And this always seemed to accomplish what I intended without apparent problems. Steve has posed the question, what happens to the LOB data if you just delete the rows from the SYS_Reports2 or Sys_Reports3 table? Does it stay in the RB4 file forever and ever? Curious minds want to know - Sami ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED] --- RBG7-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
