title: How to get values from a field and assign to a TStringList?
body: <p>How do I get all the username values from the image below and can convert them into <code>TStringList</code>, strings or <code>TMemo</code>?</p>
  
  <p><img src="https://i.stack.imgur.com/2rRf8.png" alt="enter image description here"></p>
  
  <p>I tried the following code but it didn't work.</p>
  
  <pre><code>with q3 do
    var txResul:stringlist
    begin
      Close;
      SQL.Clear;
      SQL.Add('SELECT*FROM user');
      Open;
      Next;
    end;
    txtResult.Add(q1.FieldByName('username').AsString);
  </code></pre>