arrays/1Darray/Unit1.lfm

object Form1: TForm1
  Left = 570
  Height = 620
  Top = 225
  Width = 882
  Caption = '1D Array Example'
  ClientHeight = 620
  ClientWidth = 882
  DefaultMonitor = dmPrimary
  OnCreate = FormCreate
  OnShow = FormShow
  Position = poScreenCenter
  LCLVersion = '1.8.1.0'
  object DBControlGrid1: TDBControlGrid
    Left = 20
    Height = 543
    Top = 32
    Width = 833
    AlternateColor = 16640469
    AltColorStartNormal = True
    Anchors = [akTop, akLeft, akRight, akBottom]
    Color = clWindow
    DataSource = DataSource1
    DefaultPositionAtEnd = False
    DrawPanel = Panel1
    Options = [dgpIndicator]
    TabOrder = 0
    ColWidths = (
      12
      819
    )
    object Panel1: TPanel
      Left = 12
      Height = 96
      Top = 0
      Width = 819
      ClientHeight = 96
      ClientWidth = 819
      TabOrder = 0
      object DBEdit1: TDBEdit
        Left = 8
        Height = 24
        Top = 32
        Width = 264
        DataField = 'TITLE'
        DataSource = DataSource1
        CharCase = ecNormal
        MaxLength = 0
        TabOrder = 0
      end
      object Label1: TLabel
        Left = 8
        Height = 14
        Top = 16
        Width = 73
        Caption = 'Department'
        ParentColor = False
      end
      object Label2: TLabel
        Left = 296
        Height = 14
        Top = 16
        Width = 67
        Caption = 'Sales Value'
        ParentColor = False
      end
      object Panel2: TPanel
        Left = 297
        Height = 44
        Top = 30
        Width = 496
        BevelOuter = bvNone
        Caption = 'If you can see this, goto http://bugs.freepascal.org/view.php?id=30892'
        ClientHeight = 44
        ClientWidth = 496
        TabOrder = 1
        object IBArrayGrid1: TIBArrayGrid
          Left = 0
          Height = 44
          Top = 0
          Width = 496
          DataField = 'MYARRAY'
          DataSource = DataSource1
          ColumnLabels.Strings = (
            'Jan'
            'Feb'
            'Mar'
            'Apr'
            'May'
            'Jun'
            'Jul'
            'Aug'
            'Sep'
            'Oct'
            'Nov'
            'Dec'
          )
          ColumnLabelFont.Height = -13
          ColumnLabelFont.Style = [fsBold]
          RowLabelColumnWidth = 64
          TextAlignment = taRightJustify
          Align = alClient
          AutoFillColumns = True
          FixedColor = clHighlightText
          Options = [goFixedHorzLine, goVertLine, goHorzLine, goRangeSelect, goEditing, goSmoothScroll]
          ScrollBars = ssNone
          TabOrder = 0
          ColCount = 12
          RowCount = 4
          ColWidths = (
            41
            41
            41
            41
            41
            41
            41
            41
            41
            41
            41
            43
          )
        end
      end
    end
  end
  object SaveBtn: TButton
    Left = 776
    Height = 30
    Top = 584
    Width = 75
    Anchors = [akRight, akBottom]
    Caption = 'Save'
    OnClick = SaveBtnClick
    TabOrder = 1
  end
  object CancelBtn: TButton
    Left = 696
    Height = 30
    Top = 584
    Width = 75
    Anchors = [akRight, akBottom]
    Caption = 'Cancel'
    OnClick = CancelBtnClick
    TabOrder = 2
  end
  object Button1: TButton
    Left = 21
    Height = 30
    Top = 584
    Width = 75
    Anchors = [akLeft, akBottom]
    Caption = 'Insert'
    OnClick = Button1Click
    TabOrder = 3
  end
  object Button2: TButton
    Left = 104
    Height = 30
    Top = 584
    Width = 75
    Anchors = [akLeft, akBottom]
    Caption = 'Delete'
    OnClick = Button2Click
    TabOrder = 4
  end
  object IBDatabase1: TIBDatabase
    Connected = False
    AfterConnect = IBDatabase1AfterConnect
    CreateIfNotExists = True
    AllowStreamedConnected = False
    DatabaseName = '$DATADIR$1Dtest.fdb'
    Params.Strings = (
      'user_name=SYSDBA'
      'lc_ctype=UTF8'
    )
    DefaultTransaction = IBTransaction1
    IdleTimer = 0
    TraceFlags = []
    UseDefaultSystemCodePage = False
    OnCreateDatabase = IBDatabase1CreateDatabase
    left = 283
    top = 244
  end
  object IBTransaction1: TIBTransaction
    Active = False
    DefaultDatabase = IBDatabase1
    AfterTransactionEnd = IBTransaction1AfterTransactionEnd
    left = 327
    top = 244
  end
  object IBDataSet1: TIBDataSet
    AllowAutoActivateTransaction = True
    Database = IBDatabase1
    Transaction = IBTransaction1
    AfterDelete = IBDataSet1AfterEdit
    AfterEdit = IBDataSet1AfterEdit
    AfterInsert = IBDataSet1AfterEdit
    AfterOpen = IBDataSet1AfterOpen
    BufferChunks = 1000
    CachedUpdates = False
    DeleteSQL.Strings = (
      'Delete From TESTDATA A'
      'Where A.ROWID = :ROWID'
    )
    InsertSQL.Strings = (
      'Insert Into TESTDATA(ROWID, TITLE, MYARRAY)'
      'Values(:ROWID, :TITLE, :MYARRAY)'
    )
    RefreshSQL.Strings = (
      'Select A.ROWID, A.TITLE, A.MYARRAY From TESTDATA A'
      'Where A.ROWID = :ROWID'
    )
    SelectSQL.Strings = (
      'Select A.ROWID, A.TITLE, A.MYARRAY From TESTDATA A'
      'order by 1 asc'
    )
    ModifySQL.Strings = (
      'Update TESTDATA A Set '
      '  A.ROWID = :ROWID,'
      '  A.TITLE = :TITLE,'
      '  A.MYARRAY = :MYARRAY'
      'Where A.ROWID = :OLD_ROWID'
    )
    GeneratorField.Generator = 'ROWNUMBER'
    GeneratorField.Field = 'ROWID'
    GeneratorField.ApplyOnEvent = gaeOnNewRecord
    GenerateParamNames = False
    DataSetCloseAction = dcSaveChanges
    left = 408
    top = 244
    object IBDataSet1ROWID: TIntegerField
      FieldKind = fkData
      FieldName = 'ROWID'
      Index = 0
      LookupCache = False
      ProviderFlags = [pfInUpdate, pfInWhere]
      ReadOnly = False
      Required = True
    end
    object IBDataSet1TITLE: TIBStringField
      FieldKind = fkData
      FieldName = 'TITLE'
      Index = 1
      LookupCache = False
      ProviderFlags = [pfInUpdate, pfInWhere]
      ReadOnly = False
      Required = False
      Size = 32
    end
    object IBDataSet1MYARRAY: TIBArrayField
      FieldKind = fkData
      FieldName = 'MYARRAY'
      Index = 2
      LookupCache = False
      ProviderFlags = [pfInUpdate, pfInWhere]
      ReadOnly = False
      Required = False
    end
  end
  object DataSource1: TDataSource
    DataSet = IBDataSet1
    left = 368
    top = 244
  end
end
Revision:	143
Committed:	Fri Feb 23 12:11:21 2018 UTC (6 years, 2 months ago) by tony
File size:	6352 byte(s)
Log Message:	Fixes Merged
#	User	Rev	Content
1	tony	45	object Form1: TForm1
2	tony	105	Left = 570
3	tony	45	Height = 620
4	tony	105	Top = 225
5	tony	45	Width = 882
6			Caption = '1D Array Example'
7			ClientHeight = 620
8			ClientWidth = 882
9	tony	68	DefaultMonitor = dmPrimary
10	tony	45	OnCreate = FormCreate
11			OnShow = FormShow
12	tony	88	Position = poScreenCenter
13			LCLVersion = '1.8.1.0'
14	tony	45	object DBControlGrid1: TDBControlGrid
15			Left = 20
16			Height = 543
17			Top = 32
18			Width = 833
19			AlternateColor = 16640469
20			AltColorStartNormal = True
21			Anchors = [akTop, akLeft, akRight, akBottom]
22			Color = clWindow
23			DataSource = DataSource1
24			DefaultPositionAtEnd = False
25			DrawPanel = Panel1
26			Options = [dgpIndicator]
27			TabOrder = 0
28			ColWidths = (
29			12
30			819
31			)
32			object Panel1: TPanel
33			Left = 12
34			Height = 96
35			Top = 0
36			Width = 819
37			ClientHeight = 96
38			ClientWidth = 819
39			TabOrder = 0
40			object DBEdit1: TDBEdit
41			Left = 8
42	tony	68	Height = 24
43	tony	45	Top = 32
44			Width = 264
45			DataField = 'TITLE'
46			DataSource = DataSource1
47			CharCase = ecNormal
48			MaxLength = 0
49			TabOrder = 0
50			end
51			object Label1: TLabel
52			Left = 8
53	tony	68	Height = 14
54	tony	45	Top = 16
55			Width = 73
56			Caption = 'Department'
57			ParentColor = False
58			end
59			object Label2: TLabel
60			Left = 296
61	tony	68	Height = 14
62	tony	45	Top = 16
63			Width = 67
64			Caption = 'Sales Value'
65			ParentColor = False
66			end
67			object Panel2: TPanel
68			Left = 297
69			Height = 44
70			Top = 30
71			Width = 496
72			BevelOuter = bvNone
73			Caption = 'If you can see this, goto http://bugs.freepascal.org/view.php?id=30892'
74			ClientHeight = 44
75			ClientWidth = 496
76			TabOrder = 1
77			object IBArrayGrid1: TIBArrayGrid
78			Left = 0
79			Height = 44
80			Top = 0
81			Width = 496
82			DataField = 'MYARRAY'
83			DataSource = DataSource1
84			ColumnLabels.Strings = (
85			'Jan'
86			'Feb'
87			'Mar'
88			'Apr'
89			'May'
90			'Jun'
91			'Jul'
92			'Aug'
93			'Sep'
94			'Oct'
95			'Nov'
96			'Dec'
97			)
98			ColumnLabelFont.Height = -13
99			ColumnLabelFont.Style = [fsBold]
100			RowLabelColumnWidth = 64
101			TextAlignment = taRightJustify
102			Align = alClient
103			AutoFillColumns = True
104			FixedColor = clHighlightText
105			Options = [goFixedHorzLine, goVertLine, goHorzLine, goRangeSelect, goEditing, goSmoothScroll]
106			ScrollBars = ssNone
107			TabOrder = 0
108			ColCount = 12
109	tony	143	RowCount = 4
110	tony	45	ColWidths = (
111			41
112			41
113			41
114			41
115			41
116			41
117			41
118			41
119			41
120			41
121			41
122			43
123			)
124			end
125			end
126			end
127			end
128			object SaveBtn: TButton
129			Left = 776
130			Height = 30
131			Top = 584
132			Width = 75
133			Anchors = [akRight, akBottom]
134			Caption = 'Save'
135			OnClick = SaveBtnClick
136			TabOrder = 1
137			end
138			object CancelBtn: TButton
139			Left = 696
140			Height = 30
141			Top = 584
142			Width = 75
143			Anchors = [akRight, akBottom]
144			Caption = 'Cancel'
145			OnClick = CancelBtnClick
146			TabOrder = 2
147			end
148			object Button1: TButton
149			Left = 21
150			Height = 30
151			Top = 584
152			Width = 75
153			Anchors = [akLeft, akBottom]
154			Caption = 'Insert'
155			OnClick = Button1Click
156			TabOrder = 3
157			end
158			object Button2: TButton
159			Left = 104
160			Height = 30
161			Top = 584
162			Width = 75
163			Anchors = [akLeft, akBottom]
164			Caption = 'Delete'
165			OnClick = Button2Click
166			TabOrder = 4
167			end
168			object IBDatabase1: TIBDatabase
169			Connected = False
170			AfterConnect = IBDatabase1AfterConnect
171			CreateIfNotExists = True
172			AllowStreamedConnected = False
173	tony	143	DatabaseName = '$DATADIR$1Dtest.fdb'
174	tony	45	Params.Strings = (
175			'user_name=SYSDBA'
176			'lc_ctype=UTF8'
177			)
178			DefaultTransaction = IBTransaction1
179			IdleTimer = 0
180			TraceFlags = []
181			UseDefaultSystemCodePage = False
182			OnCreateDatabase = IBDatabase1CreateDatabase
183			left = 283
184			top = 244
185			end
186			object IBTransaction1: TIBTransaction
187			Active = False
188			DefaultDatabase = IBDatabase1
189			AfterTransactionEnd = IBTransaction1AfterTransactionEnd
190			left = 327
191			top = 244
192			end
193			object IBDataSet1: TIBDataSet
194			AllowAutoActivateTransaction = True
195			Database = IBDatabase1
196			Transaction = IBTransaction1
197			AfterDelete = IBDataSet1AfterEdit
198			AfterEdit = IBDataSet1AfterEdit
199			AfterInsert = IBDataSet1AfterEdit
200			AfterOpen = IBDataSet1AfterOpen
201			BufferChunks = 1000
202			CachedUpdates = False
203			DeleteSQL.Strings = (
204			'Delete From TESTDATA A'
205			'Where A.ROWID = :ROWID'
206			)
207			InsertSQL.Strings = (
208			'Insert Into TESTDATA(ROWID, TITLE, MYARRAY)'
209			'Values(:ROWID, :TITLE, :MYARRAY)'
210			)
211			RefreshSQL.Strings = (
212			'Select A.ROWID, A.TITLE, A.MYARRAY From TESTDATA A'
213			'Where A.ROWID = :ROWID'
214			)
215			SelectSQL.Strings = (
216			'Select A.ROWID, A.TITLE, A.MYARRAY From TESTDATA A'
217			'order by 1 asc'
218			)
219			ModifySQL.Strings = (
220			'Update TESTDATA A Set '
221			' A.ROWID = :ROWID,'
222			' A.TITLE = :TITLE,'
223			' A.MYARRAY = :MYARRAY'
224			'Where A.ROWID = :OLD_ROWID'
225			)
226			GeneratorField.Generator = 'ROWNUMBER'
227			GeneratorField.Field = 'ROWID'
228			GeneratorField.ApplyOnEvent = gaeOnNewRecord
229			GenerateParamNames = False
230			DataSetCloseAction = dcSaveChanges
231			left = 408
232			top = 244
233			object IBDataSet1ROWID: TIntegerField
234			FieldKind = fkData
235			FieldName = 'ROWID'
236			Index = 0
237			LookupCache = False
238			ProviderFlags = [pfInUpdate, pfInWhere]
239			ReadOnly = False
240			Required = True
241			end
242			object IBDataSet1TITLE: TIBStringField
243			FieldKind = fkData
244			FieldName = 'TITLE'
245			Index = 1
246			LookupCache = False
247			ProviderFlags = [pfInUpdate, pfInWhere]
248			ReadOnly = False
249			Required = False
250			Size = 32
251			end
252			object IBDataSet1MYARRAY: TIBArrayField
253			FieldKind = fkData
254			FieldName = 'MYARRAY'
255			Index = 2
256			LookupCache = False
257			ProviderFlags = [pfInUpdate, pfInWhere]
258			ReadOnly = False
259			Required = False
260			end
261			end
262			object DataSource1: TDataSource
263			DataSet = IBDataSet1
264			left = 368
265			top = 244
266			end
267			end