Hi All,

In delphi I can clear blob field with field.clear but it seems i cannot
do the same in EWB?

  Database.StartTransaction;
  try
      with myDataSet do begin
      Update;
      Columns['Picture'].clear;
      Save;
      end;
      Database.Commit;
      Showmessage('Picture gone!');
      except
      Database.Rollback;
      raise;
   end;

I've also tried with Columns['Picture'].asString := '';
Same effect. Anyone have an idea?

Regards,
Hüseyin

Huseyin,

<< In delphi I can clear blob field with field.clear but it seems i cannot do the same in EWB? >>

In EWB, BLOB columns are just string columns with links to the underlying BLOB data.  Because of this, EWB does not allow one to clear a BLOB column by simply clearing the EWB column.

However, I will take a look at this and see if there are any downsides to allowing this type of operation.  If not, then I will enable this functionality (currently, EWB just ignores updates to BLOB columns).

Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim,

Thanks for info. So currently only server (module) exists for clearing
the blob.

Regards,
Hüseyin

Den 09-12-2019 kl. 19:32 skrev Tim Young [Elevate Software]:
> Huseyin,
>
> << In delphi I can clear blob field with field.clear but it seems i cannot do the same in EWB? >>
>
> In EWB, BLOB columns are just string columns with links to the underlying BLOB data.  Because of this, EWB does not allow one to clear a BLOB column by simply clearing the EWB column.
>
> However, I will take a look at this and see if there are any downsides to allowing this type of operation.  If not, then I will enable this functionality (currently, EWB just ignores updates to BLOB columns).
>
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Huseyin,

<< Thanks for info. So currently only server (module) exists for clearing the blob. >>

Correct.

Tim Young
Elevate Software
www.elevatesoft.com