This issues arises because of the way that Interbase accesses blob fields. Interbase Blob handles are not guaranteed to stay consistent across transactions and therefore the record buffer that is cached may contain a Blob handle that is no longer valid (BLOB NOT FOUND). There are a few workarounds you can try:

. Use a live query instead of cached updates 2. Use a TTable instead of cached updates 3. Use MIDAS 4. Refresh the query after each post (not recommended--too expensive) 5. Force an update of all blob fields when posting:

Example of #5:

TForm .Query BeforePost(DataSet: TDataSet); var i: Integer; temp: String; begin for i := 0 to Query .FieldCount- do if (Query .Fields[i].IsBlob) then begin temp := Query .Fields[i].AsString; Query .Fields[i].AsString := temp; end; end;

This will force an update of all blob fields and refresh their handles. 3/26/99 :00:00 AM