KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: When are blobs moved to be 'in the record' ?
PRODUCT: 4D | VERSION: 13.0 | PLATFORM: Mac & Win
Published On: January 15, 2013

After making a change to the structure and choosing to store blobs 'in the record'; the blobs will not be moved from their previous location to be 'in the record' automatically. Blobs are not moved until the record is saved.

Simply running the MSC to do a verify or repair will not move the records because no save is taking place.

In Previous versions of 4D (such as v11 and v12) the developer needed to write code to save the record in order to trigger the moving of the blob to be 'in the record'.

However, there is a new feature in v13 that is built-in to the MSC Data Compact (advanced options) to Force Updating of every record! There is no need to run 4D code anymore. This option was added to do exactly this, re-save (touch) every record.

This is also true when making changes to where a Picture field is stored (in the record, outside the record, outside the data file).