CALCFIELDS clears blob

lightning

Why is that, when i run calcfields on a blobfield it is instantly cleared.

I load a text file into a blob, and it's there, but when i call CALCFIELDS it gets emptied

also when i try to transfer the BLOB value to other table by: "Mytable.blob := TempBlob.blob" it is there before the insert, but after i read the blob from mytable again it is empty

Slawek_Guzek

HI,

CALCFIELDS "clears" a BLOB field when there is noting in there in the first place.

Make sure you used MODIFY after you assigned the value to the BLOB field in your table. Just like this (error handling ommitted):

ImportName := FileManagement.BLOBImport(TempBlob, DefaultName);
//if you do TempBlob.CALCFIELDS(BLOB) here the BLOB field on TempBlob will be cleared 
//as the BLOBImport does not store the record in with imported content in the passed TempBlob 
Mytable.blob := TempBlob.BLOB;
Mytable.MODIFY; //or Mytable.INSERT

Slawek

EvR

CALCFIELDS will not 'clear' a blob field.
Do you have a code example?

Slawek_Guzek

HI,

CALCFIELDS "clears" a BLOB field when there is noting in there in the first place.

Make sure you used MODIFY after you assigned the value to the BLOB field in your table. Just like this (error handling ommitted):

ImportName := FileManagement.BLOBImport(TempBlob, DefaultName);
//if you do TempBlob.CALCFIELDS(BLOB) here the BLOB field on TempBlob will be cleared 
//as the BLOBImport does not store the record in with imported content in the passed TempBlob 
Mytable.blob := TempBlob.BLOB;
Mytable.MODIFY; //or Mytable.INSERT

Slawek