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 37 38 39 40 41 42 43 44 45 46 47 48 49 50
| Procedure TNewCity_Form.BtnEnregistrerclick (Sender : TObject); Var
S : String;
L : Integer;
SQLQuery1_country_id: Integer;
begin
Main_Form.SQLQuery2.Close;
Main_Form.SQLQuery2.SQL.Clear;
ShowMessage ('1');
Main_Form.SQLQuery2.SQL.Text := 'insert into cities(city_name, country_id) values (:city_name, :country_id)';
ShowMessage ('2');
Main_Form.SQLQuery2.Prepare;
S := City_Edit.Text;
L := length(s);
S := UpperCase(copy(s,1,1)) + LowerCase(Copy(s,2,L-1));
Try
ShowMessage ('3');
Main_Form.SQLQuery2.Params.ParamByName('city_name').AsString := S;
ShowMessage ('4');
Main_Form.SQLQuery2.Params.ParamByName('country_id').AsInteger := Main_form.SQLQuery1.FieldByName('country_id').AsInteger;
ShowMessage ('5');
Main_Form.SQLQuery2.ExecSQL;
ShowMessage ('6');
Main_Form.SQLQuery2.SQLTransaction.Commit;
ShowMessage ('7');
except
on e: Exception do
begin
e.Message := e.Message + 'Insertion annulée.';
Main_Form.SQLQuery2.SQLTRansaction.Rollback;
raise e;
end;
end;
//Refesh de la grille
Main_Form.SQLQuery2.SQL.Clear;
Main_Form.SQLQuery2.SQL.Text := 'select * from cities where cities.COUNTRY_ID = :COUNTRY_ID';
Main_Form.SQLQuery2.Prepare;
//Cellule_sqlQuery.Active := True;
Main_Form.SQLQuery2.open;
Main_Form.SQLQuery2.last;
City_Edit.Text:= '';
Close;
end; |
Partager