SoWesley

Consulta Imagens (Server-side)

Oct 8th, 2013
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Delphi 0.73 KB | None | 0 0
  1. //Função do Servidor que faz a consulta de imagens e retorna para o cliente como texto
  2. function TServer.ConsultaImagens(ACampo, ATabela, ACondicao: string): string;
  3. var
  4.   StringStream: TStringStream;
  5. begin
  6.   with ContextParam.Conn.CreateQuery do
  7.   begin
  8.     try
  9.       SQL.Add('SELECT ');      SQL.Add(ACampo);
  10.       SQL.Add('FROM ');        SQL.Add(ATabela);
  11.       SQL.Add(ACondicao);
  12.  
  13.       Open;
  14.  
  15.       if not IsEmpty then
  16.       begin
  17.         StringStream := TStringStream.Create;
  18.         try
  19.           TBlobField(Fields[0]).SaveToStream(StringStream);
  20.           Result := StringStream.DataString;
  21.         finally
  22.           StringStream.Free;
  23.         end;
  24.       end;
  25.     finally
  26.       Close;
  27.     end;
  28.   end;
  29. end;
Advertisement
Add Comment
Please, Sign In to add comment