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 29 30 31 32 33 34 35 36
| procedure TForm3.Button1Click(Sender: TObject);
var requete, NomClient, PrenomClient, AdrClient: string;
CodeClient, TelClient, CodePostal: Integer;
begin
//variable pour allimenter les parametres de la requete
codeclient:= strtoint(edit1.text);
nomclient:= edit2.Text;
prenomclient:= edit3.Text;
adrclient:= edit4.Text;
telclient:= strtoint(edit5.Text);
codepostal:= strtoint(edit6.Text);
requete := 'insert into Table_Client(Code_Client,Nom_Client,Prenom_Client,Adress_Client,Tel_Client,Code_Postal) Values(:codeclient,nomclient,prenomclient,adrclient,telclient,codepostal)'
with form2.query1 do
begin
// definition de la raquete
close;
sql.clear;
sql.add(requete);
//alimentation des parametres
parambyname('codeclient').asinteger := strtoint(edit1.Text);
parambyname('nomclient').asstring := edit2.text;
parambyname('prenomclient').asstring := edit3.text;
parambyname('adrclient').asstring := edit4.text;
parambyname('telclient').asinteger := strtoint(edit5.Text);
parambyname('codepostal').asinteger := strtoint(edit6.Text);
try
//execution
prepare;
execsql;
exept
//gerer les erreurs
showmessage('linsertion annuler veuillez reessayer svp');
end;
end;
end; |
Partager