Working in a 13.5 C/S app on Windows. When I change the storage location of a BLOB field and a 4D Write picture field from "in the data file" to "Outside the data file", it appears that I'm not able to get 4D to move the BLOB's or 4D Write picture fields out of the data file.
I've run a routine to update a field (and then remove the update) in each record as well as running the data file through Advanced Compact. Both of these efforts were carried out per the advice in the Tech Tip entitled "Moving contents of blob outside datafile" (KB asset 76911). One table has a few dozen records with BLOB's while the table with the 4D Write picture fields has 62k recs. When I ran Advanced Compact, my expectation was that the BLOB's and Picture fields would be located in a folder adjacent to the data file. After doing the Advanced Compact, the data file size was reduced from 19.01 to 18.55 GB but there were no other files in the folder containing the 4DD, 4DIndx, and Match files. The application will be updated to V15.x in the near future but I'd like to support this architectural change while the app is still in V13.5 Any insights into this or advice would be greatly appreciated. -- Douglas von Roeder 949-336-2902 ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
