04-01-2023, 07:52 PM
جرب :
أو
أو
أو
كود :
with DTM.QrySta do
begin
Close;
SQL.Text := 'SELECT Sex, Count(Sex) AS CompteDeSex FROM Enfant where sex like :male GROUP BY Sex';
ParamByName('male').Value := 'ذكر';
Open;
end;
LabHome.Caption := DTM.QrySta.FieldByName('CompteDeSex').AsString;أو
كود :
with DTM.QrySta do
begin
Close;
SQL.Text := 'SELECT Sex, Count(Sex) AS CompteDeSex FROM Enfant where sex like :male GROUP BY Sex';
ParamByName('male').Value := QuotedStr('ذكر');
Open;
end;
LabHome.Caption := DTM.QrySta.FieldByName('CompteDeSex').AsString;أو
كود :
with DTM.QrySta do
begin
Close;
SQL.Text := 'SELECT Sex, Count(Sex) AS CompteDeSex FROM Enfant where sex = :male GROUP BY Sex';
ParamByName('male').Value := QuotedStr('ذكر');
Open;
end;
LabHome.Caption := DTM.QrySta.FieldByName('CompteDeSex').AsString;أو
كود :
with DTM.QrySta do
begin
Close;
SQL.Text := 'SELECT TRIM(Sex), Count(Sex) AS CompteDeSex FROM Enfant where sex = :male GROUP BY Sex';
ParamByName('male').Value := 'ذكر';
Open;
end;
LabHome.Caption := DTM.QrySta.FieldByName('CompteDeSex').AsString;
اللّهمّ فرّج أُموراً ضَاقت بها صُدورنا وعجزت بها حيلتنا وقلّ بها صَبرنا الّلهمّ أَسعِد قلوبنا بما أنتَ أعْلَمُ بِهِ مِنّا

