Larry - That was my supposition, too, and it is correct - if you delete a bunch of reports or forms using the DELETE ROWS FROM syntax, then pack, the RB4 file gets smaller.
So, if the user is running just one version of R:BASE, it appears to be a six-of-one, half-dozen of another situation. Sami -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Lustig Sent: Thursday, September 15, 2005 10:42 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: DROP vs. DELETE ROWS FROM > 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? The LOB data in RB4 "belongs to" the corresponding row in RB3. When you delete the row, the data in RB4 will likewise be flagged as deleted and no longer available to the user interface. It will not be physical removed until you pack or reload -- just like the RB3 row. This is supposition on my part -- it's possible that the data in RB4 is _never_ physically removed from the file. It would be easy to check by deleting some rows with LOB data, packing the database, and checking to see if the RB4 file shrunk. -- Larry
