home *** CD-ROM | disk | FTP | other *** search
- unit Unit1;
-
- interface
-
- uses
- Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
- Db, Grids, DBGrids, MemTable, ExtCtrls, DBCtrls, TeeProcs, TeEngine,
- Chart, StdCtrls, Series, DBChart, kbmMemTable;
-
- type
- TForm1 = class(TForm)
- DBChart1: TDBChart;
- Series1: TBarSeries;
- Panel1: TPanel;
- DBGrid1: TDBGrid;
- DBNavigator1: TDBNavigator;
- DataSource1: TDataSource;
- Button1: TButton;
- Button2: TButton;
- Button3: TButton;
- kbmMemTable1: TkbmMemTable;
- kbmMemTable1PERIOD: TIntegerField;
- kbmMemTable1VALUE: TIntegerField;
- kbmMemTable1COLOR: TIntegerField;
- kbmMemTable1CALC: TStringField;
- Memo1: TMemo;
- Button4: TButton;
- Button5: TButton;
- Button6: TButton;
- procedure Button1Click(Sender: TObject);
- procedure Button2Click(Sender: TObject);
- procedure Button3Click(Sender: TObject);
- procedure MemTable1CalcFields(DataSet: TDataSet);
- procedure Button4Click(Sender: TObject);
- procedure Button5Click(Sender: TObject);
- procedure Button6Click(Sender: TObject);
- private
- { Private declarations }
- public
- { Public declarations }
- end;
-
- var
- Form1: TForm1;
-
- implementation
-
- {$R *.DFM}
-
- procedure TForm1.Button1Click(Sender: TObject);
- var
- i:integer;
- begin
- with kbmMemTable1 do
- begin
- Close;
- Open;
- for i:=1 to 100 do
- begin
- Append;
- FieldByName('PERIOD').asinteger:=i;
- FieldByName('VALUE').asinteger:=i*2;
- FieldByName('COLOR').asinteger:=i*4;
- Post;
- end;
- end;
- end;
-
-
- procedure TForm1.Button2Click(Sender: TObject);
- begin
- kbmMemTable1.SaveToFile('c:\test.csv',[mtfSaveData,mtfSaveCalculated]);
- end;
-
- procedure TForm1.Button3Click(Sender: TObject);
- begin
- kbmMemTable1.Open;
- kbmMemTable1.EmptyTable;
- kbmMemTable1.LoadFromFile('c:\test.csv');
- end;
-
- procedure TForm1.MemTable1CalcFields(DataSet: TDataSet);
- begin
- if kbmMemTable1.Fields[0].IsNull then
- kbmMemTable1.Fields[3].AsString:='NULL'
- else
- kbmMemTable1.Fields[3].AsString:='';
- end;
-
- procedure TForm1.Button4Click(Sender: TObject);
- begin
- Memo1.Lines.Text:=kbmMemTable1.CommaText;
- end;
-
- procedure TForm1.Button5Click(Sender: TObject);
- begin
- kbmMemTable1.CommaText:=Memo1.Lines.Text;
- end;
-
- // Dynamically define a set of fields.
- procedure TForm1.Button6Click(Sender: TObject);
- begin
- with kbmMemTable1,kbmMemTable1.FieldDefs do
- begin
- Close;
- Clear;
- Add('Period', ftInteger, 0, false);
- Add('VALUE', ftInteger, 0, false);
- Add('Color', ftInteger, 0, false);
- Add('CALC', ftString, 20, false);
- CreateTable;
- end;
- end;
-
- end.
-