how to empty BLOB Datatype

selva1990

i have one variable called "ClearPic" with datatype of BLOB. assume that the variable is holding some value of BLOB datatype. now i need to empty that variable and assign null value(i mean it should not have any value in that variable). so need to empty blob datatype.

vijay_g

You can use Clear() function to empty the field.

P.S.: There is some difference between field and variable.

selva1990

companyTL is record variable of company information table

Fields.Type::BLOB:
BEGIN
FieldR.CALCFIELD;
FieldR1.VALUE:=FieldR.VALUE;
RecordR1.MODIFY;
Clear(CompanyTL);
CompanyTL.INIT;
FieldR.VALUE:=CompanyTL.Picture;
RecordR.MODIFY;
END;

i used that but no use

vijay_g

You can not assign BLOB data type, anyway which field you want empty in this code?

selva1990

Fields.Type::BLOB:
BEGIN
FieldR.CALCFIELD;
FieldR1.VALUE:=FieldR.VALUE;
RecordR1.MODIFY;
Clear(CompanyTL);
CompanyTL.INIT;
FieldR.VALUE:=CompanyTL.Picture; // here i need to make the blob data empty
RecordR.MODIFY;
END;

fieldr is fieldref datatype in that i need to make all the value of blob datatype to empty