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: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61:
| uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, DBTables, DB, Grids,DBCtrls, DBGrids; . . . procedure TForm1.FormCreate(Sender: TObject); begin tb := TTable.Create(Self); with tb do begin AutoCalcFields := True; DatabaseName := 'DBDEMOS'; TableName := 'PrgTest'; TableType := ttParadox; OnCalcFields := CalcFields; with FieldDefs do begin Clear; Add('Id', ftAutoInc, 0, false); Add('Vorname', ftString, 20, false); Add('Nachname', ftString, 20, false); Add('GehaltInEuro', ftCurrency, 0, false);
FieldDefs[0].CreateField(tb); FieldDefs[1].CreateField(tb); FieldDefs[2].CreateField(tb); FieldDefs[3].CreateField(tb); CalcField := TFloatField.Create(tb); with CalcField do begin FieldName := 'GehaltInDM'; Calculated := True; Visible := True; DataSet := tb; DisplayFormat := '#,##0.00 DM'; Name := 'GehaltInDM'; tb.FieldDefs.Add(Name, ftFloat, 0, false); end; end; tb.CreateTable; end;
ds := TDataSource.Create(Self); ds.DataSet := tb; DbNav := TDBNavigator.Create(self); with dbNav do begin Parent := Self; Align := alBottom; DataSource := ds; end; DBGrid := TDBGrid.Create(Self); with DBGrid do begin Parent := Self; Align := alClient; DataSource := ds; end; tb.Active := True; end;
procedure TForm1.CalcFields(DataSet: TDataset); begin DataSet.FieldByName('GehaltInDM').AsFloat := DataSet.FieldByName('GehaltInEuro').AsFloat * 1.95583; end; |