1:

result := q.fieldbyname('Blobwert').Value;					

1:

 result := q.fieldbyname('Blobwert').Asstring;					

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:

function GetBlob: string;
var
  i: Integer;
  sH: string;
  q: TQuery;
  Blobfield: TBlobField;
begin
  sH := 'select * from Table);
  q := GetTheSQL();
  if q <> nil then begin
    Blobfield := TBlobfield.Create(nil);
    try
      q.first;
      for i := 0 to q.RecordCount - 1 do begin
        result := (q.Fieldbyname('BLOBWERT') as TBlobField).Text;

        break;
      end;
    finally
      Blobfield.Free;
    end;
  end;
end;					

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:

Function BlobToString (aBlobField : TBlobField) : String;
Var
  sStringStream : TStringStream;

Begin
  Result := '';
  sStringStream := TStringStream.Create('');
  Try
    aBlobField.SaveToStream(sStringStream);
    Result := sStringStream.DataString;
  Finally
    sStringStream.free
  End;
End;					

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:

function StreamToOraDatabase(sSql, Alias, sSessionName: string; var bs: TMemoryStream): boolean;
var
  OraQuery: TOraQuery;

begin
  result := false;
  SyncFree.BeginWrite;
  try
    OraQuery := GetOraQuery(Alias, sSessionname);
    try
      try
        with OraQuery do begin
          Active := false;
          SQL.Text := sSql;
          Params[0].SetBlobData(bs.Memory, bs.Size);
          Execute;
          result := true;
        end;
      except
        on e: exception do begin
          showmyerror('StreamToOraDatabase: ' + e.Message);
          showmyerror('StreamToOraDatabase: ' + ssql);
        end;
      end;
    finally
    end;
  finally
    SyncFree.endWrite;
  end;
end;					

1:
2:
3:
4:
5:

procedure TForm2.qryTestAfterScroll(DataSet: TDataSet);
begin
  if qryTest.FindField('EXT').AsString = '.bmp' then
    imgTest.Picture.Assign((qryTest.FindField('PIC') As TBlobField));
end;