Blob

[etwoss]

Hi

I have Interbase Blob fields, how to get the text into a MemoEx?

Eric

[Alexander Bulei]

Hi Eric,

By using the DataLink?

Best Regards.

[etwoss]

Haha

Tried that ofcourse, just showing (Blob)

Eric

[Jorge Sousa]

Hi

Is it a binary or a text blob ?

[Jorge Sousa]

The code to update memoex value, from the field, is as follows:

Code: Select all

procedure TIWCGJQCustomMemoEx.UpdateCtrl;
begin
  if DataLink.CanModify then
  begin
    case DataLink.Field.DataType of
      DB.ftMemo: Text:= CheckCharCase(string((DataLink.Field as TMemoField).Value));
      {$IFDEF VER2005UP}
      DB.ftWideMemo: Text:= CheckCharCase((DataLink.Field as TWideMemoField).Value);
      {$ENDIF}
      else Text := CheckCharCase(DataLink.Field.Text)
    end;
  end
  else
  begin
    Text:= CheckCharCase(DataLink.Field.DisplayText);
  end;
end;



What is your Field's property Value ?

[etwoss]

Hi

Any news on this subject?

Eric

[Jorge Sousa]

Hi

What is your Field's property Value ?

[etwoss]

Hi

ftBlob

Also tested with Interbase Blob type Text, which gives a ftMemo datatype.
Also no data

Eric

[Jorge Sousa]

Eric

What is the value of Field.Value?

[etwoss]

Hi

UserSession.cdsClient.fieldByName('HISTORIE') .AsString:


'04-06-2014 JVT'#$D#$A'1e afspraak na intake. Icares besproken'#$D#$A'Focus met werken/ taken, maar toch flexibel in taakuitvoering. Kan wisselen van taken. '#$D#$A#$D#$A'Zou wellicht goede teamleider kunnen zijn.: Uit test blijkt: leiidngeven, sturing gevenj, toezicht houden, corrigeren.'#$D#$A#$D#$A'CL maakt fysieke criteria opnieuw en ik plaats vertegenwoordiger in dossier, daarna rapport maken. '


Eric