Subject INVALID BLOB ID - PutVarSlice
Author Johannes Pretorius
Good day all
-=00=-=-0=-0=-0
We have had problems in the past with invalid blob ID's. WE thought that moving the interbase version higher than 5.6 will fix
it , but this seems is not the case.

Then today I found some comments ins

procedure TIB_ColumnArray.PutVarSlice( const Values: variant );

Where it states near the end

SysSetIsNull( false );
// Need to finish the auto re-fetch of the new ARRAY ID after this call is made.
// Otherwise, an Invalid BLOB ID error is generated if a call to get_slice
// is performed using the temporary Array ID that put slice creates.
SysAfterModify;
end;



Now what I want to know if there is a possibility that this is the reason for the Invalid blob Id's that we get every now and again.

It is very hard for us to emulate the problems as it is intermittent at clients, thus we cannot get to the exact line of code that is the problem.

Any help will be appreciated

Interbase version where problem occurs : 5.6 -> 7.5
IBOBjects 4.6

Thanks


Johannes Pretorius