How to empty BLOB and Binary with FieldRef

mgm

Is it possible to empty a BLOB field with FieldRef?

An example for Text or Integer is:

Field.Type::Integer:FieldRef.VALUE := 0;
Field.Type::Text:FieldRef.VALUE := '';

Slawek_Guzek

mgm wrote:

Is it possible to empty a BLOB field with FieldRef?

Yes, but indirectly. Import some picture to the first item in Item table, then try this:

rref.open(27);
rref.findfirst; //find first item - this is for demonstration purpose only

//prepare empty BLOB field
clear(tempitem);  //tempitem is Record 27 declared as temporary
tempitem.insert;
rref2.gettable(tempitem);
fref2 := rref2.field(92); // field 92 = Picture, BLOB field in Item table
fref2.calcfield;

fref := rref.field(92);
fref.value := fref2.value;
rref.modify;

Hope this helps.

Slawek

mgm

\:D/ Thanx Slawek!

Just didn't manage to use this for fieldtype TableFilter and Binary.
But these fieldtypes are rarely used.