home *** CD-ROM | disk | FTP | other *** search
- unit ex1;
-
- interface
-
- uses
- Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
- DBTables, Db, ExtCtrls, DBPanel, DBxNav, FrmDSrce;
-
- type
- TForm1 = class(TForm)
- dbExample: TDatabase;
- taOrders: TTable;
- taItems: TTable;
- dsOrders: TDataSource;
- dsItems: TDataSource;
- RaDBPanel1: TRaDBPanel;
- taOrdersOrderNo: TFloatField;
- taOrdersCustNo: TFloatField;
- taOrdersSaleDate: TDateTimeField;
- taOrdersShipDate: TDateTimeField;
- taOrdersEmpNo: TIntegerField;
- taOrdersShipToContact: TStringField;
- taOrdersShipToAddr1: TStringField;
- taOrdersShipToAddr2: TStringField;
- taOrdersShipToCity: TStringField;
- taOrdersShipToState: TStringField;
- taOrdersShipToZip: TStringField;
- taOrdersShipToCountry: TStringField;
- taOrdersShipToPhone: TStringField;
- taOrdersShipVIA: TStringField;
- taOrdersPO: TStringField;
- taOrdersTerms: TStringField;
- taOrdersPaymentMethod: TStringField;
- taOrdersItemsTotal: TCurrencyField;
- taOrdersTaxRate: TFloatField;
- taOrdersFreight: TCurrencyField;
- taOrdersAmountPaid: TCurrencyField;
- taItemsOrderNo: TFloatField;
- taItemsItemNo: TFloatField;
- taItemsPartNo: TFloatField;
- taItemsQty: TIntegerField;
- taItemsDiscount: TFloatField;
- taOrdersCustName: TStringField;
- rtaCustomers: TRaTable;
- rtaEmployees: TRaTable;
- taOrdersEmpName: TStringField;
- paBottom: TPanel;
- RaDBNavigator1: TRaDBNavigator;
- rtaParts: TRaTable;
- taItemsPartDescription: TStringField;
- private
- { Private declarations }
- public
- { Public declarations }
- end;
-
- var
- Form1: TForm1;
-
- implementation
- uses StdUtils, RaReport;
-
- function GetWindowsUserName: String;
- var
- NameLen : DWord;
- Name: array[0..255] of Char;
- begin
- NameLen := SizeOf(Name);
- if not GetUserName(Name, NameLen) then
- StrCopy(Name, 'NONAME');
- Result := Name;
- end;
-
- {$R *.DFM}
- initialization
- // is used to print lookup datasets
- OrgName := 'Noname Inc.';
- UserName := GetWindowsUserName;
- FullUserName := UserName;
- end.
-