Page 1 of 2

Blob

PostPosted: 04 Jan 2015 10:37
by etwoss
Hi

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

Eric

Re: Blob

PostPosted: 05 Jan 2015 10:56
by Alexander Bulei
Hi Eric,

By using the DataLink?

Best Regards.

Re: Blob

PostPosted: 05 Jan 2015 13:17
by etwoss
Haha

Tried that ofcourse, just showing (Blob)

Eric

Re: Blob

PostPosted: 05 Jan 2015 17:22
by Jorge Sousa
Hi

Is it a binary or a text blob ?

Re: Blob

PostPosted: 06 Jan 2015 11:35
by 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 ?

Re: Blob

PostPosted: 12 Jan 2015 13:59
by etwoss
Hi

Any news on this subject?

Eric

Re: Blob

PostPosted: 12 Jan 2015 15:10
by Jorge Sousa
Hi

What is your Field's property Value ?

Re: Blob

PostPosted: 14 Jan 2015 18:54
by etwoss
Hi

ftBlob

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

Eric

Re: Blob

PostPosted: 14 Jan 2015 19:19
by Jorge Sousa
Eric

What is the value of Field.Value?

Re: Blob

PostPosted: 17 Jan 2015 10:15
by 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