> 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
