If table1.State in [dsInsert,dsEdit]then
table1.Cancel;
end;
procedure TForm2.Button5Click(Sender: TObject);
begin
If table2.State = dsBrowse then
table2.insert;
procedure TForm2.Button6Click(Sender: TObject);
If Messagedlg('',mtconfirmation,[mbYes,mbNo],0)=mrYes then
table2.delete;
procedure TForm2.Button8Click(Sender: TObject);
table2.edit;
procedure TForm2.Button7Click(Sender: TObject);
If table2.State in [dsInsert,dsEdit]then
table2.post;
procedure TForm2.BitBtn1Click(Sender: TObject);
Form1.show;
Form2.hide;
procedure TForm2.BitBtn2Click(Sender: TObject);
Form3.show;
procedure TForm2.OnActivate(Sender: TObject);
DBGrid2.Columns.Items[1].PickList.Clear;
with Table1 do begin
first;
While not eof do Begin
DBGrid2.columns.Items[1].Picklist.add(FieldByName('Kod_pred').value);
next;
end.
unit Unit3;
interface
uses
Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
StdCtrls, ExtCtrls, Db, DBTables, Grids, DBGrids, ComCtrls, Buttons,
Mask, DBCtrls;
type
TForm3 = class(TForm)
GroupBox1: TGroupBox;
DBGrid1: TDBGrid;
DataSource1: TDataSource;
Table1: TTable;
Label1: TLabel;
Label2: TLabel;
GroupBox2: TGroupBox;
Panel1: TPanel;
Button1: TButton;
Button2: TButton;
Button3: TButton;
Button4: TButton;
GroupBox3: TGroupBox;
DBGrid2: TDBGrid;
DataSource2: TDataSource;
Table2: TTable;
GroupBox4: TGroupBox;
Button5: TButton;
Button6: TButton;
Button7: TButton;
Button8: TButton;
StatusBar1: TStatusBar;
GroupBox5: TGroupBox;
BitBtn1: TBitBtn;
BitBtn2: TBitBtn;
DBEdit1: TDBEdit;
DBEdit2: TDBEdit;
DBEdit3: TDBEdit;
DBEdit4: TDBEdit;
DBEdit5: TDBEdit;
DBEdit6: TDBEdit;
DBEdit7: TDBEdit;
DBEdit8: TDBEdit;
DBEdit9: TDBEdit;
DBEdit10: TDBEdit;
DBEdit11: TDBEdit;
procedure Button1Click(Sender: TObject);
procedure Button4Click(Sender: TObject);
procedure Button3Click(Sender: TObject);
procedure Button2Click(Sender: TObject);
procedure Button5Click(Sender: TObject);
procedure Button6Click(Sender: TObject);
procedure Button7Click(Sender: TObject);
procedure Button8Click(Sender: TObject);
procedure BitBtn1Click(Sender: TObject);
procedure BitBtn2Click(Sender: TObject);
procedure OnActivate(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
var
Form3: TForm3;
implementation
uses Unit1, Unit2;
{$R *.DFM}
procedure TForm3.Button1Click(Sender: TObject);
procedure TForm3.Button4Click(Sender: TObject);
procedure TForm3.Button3Click(Sender: TObject);
procedure TForm3.Button2Click(Sender: TObject);
procedure TForm3.Button5Click(Sender: TObject);
If table1.State = dsBrowse then
table1.insert;
procedure TForm3.Button6Click(Sender: TObject);
table1.delete;
procedure TForm3.Button7Click(Sender: TObject);
table1.edit;
procedure TForm3.Button8Click(Sender: TObject);
table1.post;
procedure TForm3.BitBtn1Click(Sender: TObject);
Form3.hide;
procedure TForm3.BitBtn2Click(Sender: TObject);
Form2.show;
procedure TForm3.OnActivate(Sender: TObject);
DBGrid2.Columns.Items[3].PickList.Clear;
with Form1.Table1 do begin
DBGrid2.columns.Items[3].Picklist.add(FieldbyName('Kod_lek').value);
with Form2.Table2 do begin
DBGrid2.columns.Items[1].Picklist.add(FieldbyName('Nom_naklad').value);
DBGrid2.Columns.Items[2].PickList.Clear;
with Form2.Table1 do begin
DBGrid2.columns.Items[2].Picklist.add(FieldbyName('Kod_pred').value);
DBGrid1.Columns.Items[1].PickList.Clear;
DBGrid1.columns.Items[1].Picklist.add(FieldbyName('Kod_lek').value);
unit Unit4;
StdCtrls, Db, DBTables, Grids, DBGrids, ExtCtrls;
TForm4 = class(TForm)
Query1: TQuery;
Edit1: TEdit;
RadioGroup1: TRadioGroup;
procedure Query1FilterRecord(DataSet: TDataSet; var Accept: Boolean);
Form4: TForm4;
pole :shortstring;
procedure TForm4.Button1Click(Sender: TObject);
Query1.Filtered:=false;
Query1.Active:=true;
procedure TForm4.Button2Click(Sender: TObject);
Query1.Active:=false;
procedure TForm4.Button3Click(Sender: TObject);
Case Radiogroup1.itemindex of
0:pole:='Name_lek';
1:pole:='Kolvo_p_lek'
Query1.Filtered:=true;
procedure TForm4.Query1FilterRecord(DataSet: TDataSet;
var Accept: Boolean);
Accept:=Dataset[pole]=edit1.text;
unit Unit5;
StdCtrls, ExtCtrls, Buttons;
TForm5 = class(TForm)
Image1: TImage;
Label3: TLabel;
Label6: TLabel;
Form5: TForm5;
procedure TForm5.Button1Click(Sender: TObject);
Form5.close;
procedure TForm5.BitBtn1Click(Sender: TObject);
Form5.Close;
Страницы: 1, 2, 3, 4, 5