Reported By: Terry Swiers Reported On: 5/28/2004 For: Version 4.07 Build 1
# 1738Altering a Table and Removing a Field Before Any BLOB Fields Will Cause an AV After installing the 4.07 update from 4.05, I'm getting error 9494 (too many open blobs) restructuring some tables. If this is not something that you already know about, let me know and I'll see if I can produce a test application since the restructuring that it is failing on is rather complex.
CommentsInternally an AV was being triggered during the AlterTable, but if an OnDataLost event handler was not assigned then the error would be suppressed and BLOBs would be left open, eventually causing the 9494 error if the table had more than 128 records (assuming 1 BLOB field per record), which is the maximum number of open blobs allowed.
ResolutionFixed Problem on 5/29/2004 in version 4.08 build 1