I am a beginner in delphi and using the following command to get the count of records based on SQL query:

Query1.Close;
Query1.SQL.Clear;
Query1.SQL.Add('Select COUNT(*) AS total_count from myDBName where myField = 999');
Query1.Open;


now I need to read total_count value and put it into an Edit textBox, how can I do that?


Many Thanks,
Jassim Rahma

edit.text := query1.FieldByName('total_count').AsString;