home *** CD-ROM | disk | FTP | other *** search
- unit DemoQueryToMany;
-
- interface
-
- uses
- Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
- Grids, DBGrids, DB, DBTables, StdCtrls;
-
- type
- TFormQueryToMany = class(TForm)
- QryOne: TQuery;
- SrcOne: TDataSource;
- QryMany: TQuery;
- SrcMany: TDataSource;
- DBGrid1: TDBGrid;
- DBGrid2: TDBGrid;
- QryOnePers_LastName: TStringField;
- QryOnePers_FirstName: TStringField;
- QryOnePers_Birthday: TDateTimeField;
- QryOnePers_ID: TIntegerField;
- QryManyAdr_ID: TAutoIncField;
- QryManyAdr_PersID: TIntegerField;
- QryManyAdr_Street: TStringField;
- QryManyAdr_ZIP: TStringField;
- QryManyAdr_Place: TStringField;
- QryManyAdr_Country: TStringField;
- procedure QryManyBeforeOpen(DataSet: TDataSet);
- procedure FormCreate(Sender: TObject);
- private
- { Private declarations }
- public
- { Public declarations }
- end;
-
- var
- FormQueryToMany: TFormQueryToMany;
-
- implementation
-
- {$R *.DFM}
-
- procedure TFormQueryToMany.QryManyBeforeOpen(DataSet: TDataSet);
- begin
- QryMany.Prepare;
- end;
-
- procedure TFormQueryToMany.FormCreate(Sender: TObject);
- begin
- QryOne.Open;
- QryMany.Open;
- end;
-
- end.
-