1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| procedure TForm8.EnregistrerClick(Sender: TObject);
var etat:string;
etat1:string;
begin
if sexe.Itemindex=0 then etat:='Masculin' else
if sexe.ItemIndex=1 then etat:='Masculin' else
if etatcivil.checked[0] =true then etat1:='Célibataire' else
if etatcivil.Checked[1]=true then etat1:='Marié(e)' else
if etatcivil.Checked[2]=true then etat1:='Divorcé(e)' else
if etatcivil.Checked[3]=true then etat1:='Veuf(e)' ;
modbase.IBQuery.SQL.Clear;
modbase.IBQuery.SQL.Add('INSERT INTO PATIENT (codpat,nompat,prenpat,daten,age,adrpat,profpat,sexe,etatcivil,notes) VALUES (:codpat,:nompat,:prenpat,:daten,:age,:adrpat,:profpat,:sexe,:etatcivil,:notes)');
modbase.IBQuery.Params[0].AsString:=codpat.Text;
modbase.IBQuery.Params[1].AsString:=nompat.Text;
modbase.IBQuery.Params[2].AsString:=prenpat.Text;
modbase.IBQuery.Params[3].AsString:=daten.Text;
modbase.IBQuery.Params[4].AsString:=age.Text;
modbase.IBQuery.Params[5].AsString:=adrpat.Text;
modbase.IBQuery.Params[6].AsString:=profpat.Text;
modbase.IBQuery.Params[7].AsString:=etat;
modbase.IBQuery.Params[8].AsString:=etat1;
modbase.IBQuery.Params[9].AsString:=notes.Text;
modbase.IBQuery.Open;
end; |
Partager