Registriert seit: 9. Jul 2004
Ort: Kärnten
17 Beiträge
Delphi 10.3 Rio
|
AW: select anweisung
15. Jan 2013, 14:26
versuchs mal so:
Code:
ADOQuery1.SQL.Text := 'SELECT user, sum(poso) as sum FROM history group by user';
ADOQuery1.Active := TRUE;
iCount := 1;
while (ADOQuery1.Eof = FALSE) do begin
stringgrid1.Cells[3, iCount] := ADOQuery1.Fieldbyname('user').asstring;
stringgrid1.Cells[2, iCount] := floattostr(ADOQuery1.Fieldbyname('sum').asfloat);
ADOQuery1.Next;
inc (iCount);
end;
Peter (EDV = Ende der Vernunft)
|