unit AdtForm;
interface
uses
Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
Db, DBClient, Grids, DBGrids, MidasLib;
type
TForm1 = class(TForm)
ClientDataSet1: TClientDataSet;
DataSource1: TDataSource;
DBGrid1: TDBGrid;
ClientDataSet1ID: TIntegerField;
ClientDataSet1Name: TADTField;
ClientDataSet1NameLastName: TStringField;
ClientDataSet1NameFirstName: TStringField;
procedure ClientDataSet1NameGetText(Sender: TField; var Text: String;
DisplayText: Boolean);
procedure DBGrid1TitleClick(Column: TColumn);
procedure FormCreate(Sender: TObject);
private
public
end;
var
Form1: TForm1;
implementation
procedure TForm1.ClientDataSet1NameGetText(Sender: TField;
var Text: String; DisplayText: Boolean);
begin
Text := ClientDataSet1NameFirstName.AsString + ' ' +
ClientDataSet1NameLastName.AsString;
end;
procedure TForm1.DBGrid1TitleClick(Column: TColumn);
begin
if Column.Field.FullName = 'Name' then
ClientDataSet1.IndexFieldNames := 'Name.LastName'
else
ClientDataSet1.IndexFieldNames := Column.Field.FullName;
end;
procedure TForm1.FormCreate(Sender: TObject);
begin
ClientDataSet1.LogChanges := False;
end;
end.
|
object Form1: TForm1
Left = 340
Top = 134
Width = 398
Height = 212
Caption = 'AdtDemo'
Color = clBtnFace
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -11
Font.Name = 'MS Sans Serif'
Font.Style = []
OldCreateOrder = False
OnCreate = FormCreate
PixelsPerInch = 96
TextHeight = 13
object DBGrid1: TDBGrid
Left = 0
Top = 0
Width = 390
Height = 185
Align = alClient
DataSource = DataSource1
Options = [dgEditing, dgTitles, dgIndicator, dgColLines, dgRowLines, dgTabs, dgConfirmDelete, dgCancelOnExit]
TabOrder = 0
TitleFont.Charset = DEFAULT_CHARSET
TitleFont.Color = clWindowText
TitleFont.Height = -11
TitleFont.Name = 'MS Sans Serif'
TitleFont.Style = []
OnTitleClick = DBGrid1TitleClick
Columns = <
item
Expanded = False
FieldName = 'ID'
Visible = True
end
item
FieldName = 'Name'
Visible = True
end
item
Expanded = False
FieldName = 'Name.LastName'
Visible = True
end
item
Expanded = False
FieldName = 'Name.FirstName'
Width = 167
Visible = True
end>
end
object ClientDataSet1: TClientDataSet
Active = True
Aggregates = <>
FileName = 'C:\md6code\14\AdtDemo\data.cds'
FieldDefs = <
item
Name = 'ID'
DataType = ftInteger
end
item
Name = 'Name'
ChildDefs = <
item
Name = 'LastName'
DataType = ftString
Size = 20
end
item
Name = 'FirstName'
DataType = ftString
Size = 20
end>
DataType = ftADT
Size = 2
end>
IndexDefs = <
item
Name = 'Index'
Fields = 'Name.LastName'
end>
Params = <>
StoreDefs = True
Left = 32
Top = 24
Data =
object ClientDataSet1ID: TIntegerField
FieldName = 'ID'
end
object ClientDataSet1Name: TADTField
FieldName = 'Name'
OnGetText = ClientDataSet1NameGetText
object ClientDataSet1NameLastName: TStringField
FieldName = 'LastName'
end
object ClientDataSet1NameFirstName: TStringField
FieldName = 'FirstName'
end
end
end
object DataSource1: TDataSource
DataSet = ClientDataSet1
Left = 32
Top = 80
end
end
|