RemoteQuery := TccRemoteQuery.Create;

try
  RemoteQuery.User        := 'Test';
  RemoteQuery.Password    := 'secret';
  RemoteQuery.CreateSession;
  
  try
    RemoteQuery.Connection  := 'EXAMPLE';
    RemoteQuery.CommandText := 'SELECT * FROM myTable';
    RemoteQuery.Open;

    try
      for i:=0 to RemoteQuery.RecordCount-1 do
      begin
        ShowMessage(RemoteQuery.GetFieldValueByName('Name',i));
      end;

    finally
      RemoteQuery.Close;
    end;

  finally
    RemoteQuery.CloseSession;
  end;

finally
  RemoteQuery.Free;
end;