procedure TForminicio.ClientesListar;
var
Cliente_foto: TBitmap;
foto_stream: TStream;
begin
lvClientes.BeginUpdate;
lvClientes.Items.Clear;
with UniQueryVisita do
begin
Active := false;
SQL.Clear;
SQL.Add('select * from Visitas');
Active := true;
while NOT eof do
begin
Cliente_Foto := nil;
if not FieldByName('Foto').IsNull then
begin
foto_stream := CreateBlobStream(FieldByName('Foto'), TBlobStreamMode.bmRead);
Cliente_Foto:= TBitmap.Create;
Cliente_Foto.LoadFromStream(foto_stream);
foto_stream.DisposeOf;
end;
ClienteAddListView(FieldByName('Cliente_RUT').AsString,
FieldByName('Cliente_Nombre').AsString,
FieldByName('Cliente_email').AsString,
FieldByName('Cliente_Apellido').AsString,
FieldByName('Aceptacion_visita').AsString,
FieldByName('Cliente_comentario').AsString,
Cliente_Foto);
Next;
end;
end;
lvClientes.EndUpdate;
end;