1 |
object Form1: TForm1 |
2 |
Left = 2386 |
3 |
Height = 432 |
4 |
Top = 305 |
5 |
Width = 994 |
6 |
Caption = '2D Array Example' |
7 |
ClientHeight = 432 |
8 |
ClientWidth = 994 |
9 |
DefaultMonitor = dmPrimary |
10 |
OnCreate = FormCreate |
11 |
OnShow = FormShow |
12 |
Position = poDefaultSizeOnly |
13 |
LCLVersion = '2.2.0.2' |
14 |
object IBArrayGrid1: TIBArrayGrid |
15 |
Left = 24 |
16 |
Height = 335 |
17 |
Top = 56 |
18 |
Width = 945 |
19 |
DataField = 'MYARRAY' |
20 |
DataSource = DataSource1 |
21 |
ColumnLabels.Strings = ( |
22 |
'Col1' |
23 |
'Col2' |
24 |
'Col3' |
25 |
'Col4' |
26 |
'Col5' |
27 |
'Col6' |
28 |
'Col7' |
29 |
'Col8' |
30 |
) |
31 |
ColumnLabelFont.Height = -13 |
32 |
ColumnLabelFont.Style = [fsBold] |
33 |
RowLabels.Strings = ( |
34 |
'Row 1' |
35 |
'Row 2' |
36 |
'Row 3' |
37 |
) |
38 |
RowLabelAlignment = taRightJustify |
39 |
RowLabelFont.Height = -13 |
40 |
RowLabelFont.Name = 'Sans' |
41 |
RowLabelFont.Style = [fsBold] |
42 |
RowLabelColumnWidth = 80 |
43 |
TextAlignment = taRightJustify |
44 |
Anchors = [akTop, akLeft, akRight, akBottom] |
45 |
AutoFillColumns = True |
46 |
DefaultColWidth = 40 |
47 |
Options = [goFixedVertLine, goFixedHorzLine, goVertLine, goHorzLine, goRangeSelect, goEditing, goSmoothScroll] |
48 |
TabOrder = 0 |
49 |
ColCount = 30 |
50 |
RowCount = 22 |
51 |
ColWidths = ( |
52 |
80 |
53 |
29 |
54 |
29 |
55 |
29 |
56 |
29 |
57 |
29 |
58 |
29 |
59 |
29 |
60 |
29 |
61 |
29 |
62 |
29 |
63 |
29 |
64 |
29 |
65 |
29 |
66 |
29 |
67 |
29 |
68 |
29 |
69 |
29 |
70 |
29 |
71 |
29 |
72 |
29 |
73 |
29 |
74 |
29 |
75 |
29 |
76 |
29 |
77 |
29 |
78 |
29 |
79 |
29 |
80 |
29 |
81 |
37 |
82 |
) |
83 |
end |
84 |
object DBEdit1: TDBEdit |
85 |
Left = 24 |
86 |
Height = 24 |
87 |
Top = 16 |
88 |
Width = 232 |
89 |
DataField = 'TITLE' |
90 |
DataSource = DataSource1 |
91 |
MaxLength = 0 |
92 |
TabOrder = 1 |
93 |
end |
94 |
object DBNavigator1: TDBNavigator |
95 |
Left = 24 |
96 |
Height = 25 |
97 |
Top = 400 |
98 |
Width = 241 |
99 |
Anchors = [akLeft, akBottom] |
100 |
BevelOuter = bvNone |
101 |
ChildSizing.EnlargeHorizontal = crsScaleChilds |
102 |
ChildSizing.EnlargeVertical = crsScaleChilds |
103 |
ChildSizing.ShrinkHorizontal = crsScaleChilds |
104 |
ChildSizing.ShrinkVertical = crsScaleChilds |
105 |
ChildSizing.Layout = cclLeftToRightThenTopToBottom |
106 |
ChildSizing.ControlsPerLine = 100 |
107 |
ClientHeight = 25 |
108 |
ClientWidth = 241 |
109 |
DataSource = DataSource1 |
110 |
Options = [] |
111 |
TabOrder = 2 |
112 |
end |
113 |
object IBDatabase1: TIBDatabase |
114 |
Connected = False |
115 |
AfterConnect = IBDatabase1AfterConnect |
116 |
CreateIfNotExists = True |
117 |
AllowStreamedConnected = False |
118 |
DatabaseName = '$DATADIR$2Dtest.fdb' |
119 |
Params.Strings = ( |
120 |
'lc_ctype=UTF8' |
121 |
'user_name=SYSDBA' |
122 |
) |
123 |
DefaultTransaction = IBTransaction1 |
124 |
IdleTimer = 0 |
125 |
TraceFlags = [] |
126 |
UseDefaultSystemCodePage = False |
127 |
OnCreateDatabase = IBDatabase1CreateDatabase |
128 |
Left = 624 |
129 |
Top = 24 |
130 |
end |
131 |
object IBTransaction1: TIBTransaction |
132 |
TransactionName = '{1B583E8A-EB53-4806-A83F-D07393B2B542}' |
133 |
Active = False |
134 |
DefaultDatabase = IBDatabase1 |
135 |
Params.Strings = ( |
136 |
'read_committed' |
137 |
'rec_version' |
138 |
'nowait' |
139 |
) |
140 |
Left = 624 |
141 |
Top = 86 |
142 |
end |
143 |
object DataSource1: TDataSource |
144 |
DataSet = IBDataSet1 |
145 |
Left = 624 |
146 |
Top = 184 |
147 |
end |
148 |
object IBDataSet1: TIBDataSet |
149 |
AllowAutoActivateTransaction = True |
150 |
Database = IBDatabase1 |
151 |
Transaction = IBTransaction1 |
152 |
BufferChunks = 1000 |
153 |
BufferChunksInFirstBlock = 50 |
154 |
CachedUpdates = False |
155 |
CaseSensitiveParameterNames = False |
156 |
EnableStatistics = False |
157 |
DeleteSQL.Strings = ( |
158 |
'Delete From TESTDATA A' |
159 |
'Where A.ROWID = :ROWID' |
160 |
) |
161 |
InsertSQL.Strings = ( |
162 |
'Insert Into TESTDATA(ROWID, TITLE, MYARRAY)' |
163 |
'Values(:ROWID, :TITLE, :MYARRAY)' |
164 |
) |
165 |
RefreshSQL.Strings = ( |
166 |
'Select A.ROWID, A.TITLE, A.MYARRAY From TESTDATA A' |
167 |
'Where A.ROWID = :ROWID' |
168 |
) |
169 |
SelectSQL.Strings = ( |
170 |
'Select A.ROWID, A.TITLE, A.MYARRAY From TESTDATA A' |
171 |
'order by 1 asc' |
172 |
) |
173 |
ModifySQL.Strings = ( |
174 |
'Update TESTDATA A Set ' |
175 |
' A.ROWID = :ROWID,' |
176 |
' A.TITLE = :TITLE,' |
177 |
' A.MYARRAY = :MYARRAY' |
178 |
'Where A.ROWID = :OLD_ROWID' |
179 |
) |
180 |
GeneratorField.Generator = 'ROWNUMBER' |
181 |
GeneratorField.Field = 'ROWID' |
182 |
GeneratorField.ApplyOnEvent = gaeOnNewRecord |
183 |
GenerateParamNames = False |
184 |
MasterDetailDelay = 0 |
185 |
DataSetCloseAction = dcSaveChanges |
186 |
TZTextOption = tzOffset |
187 |
DefaultTZDate = 43831 |
188 |
SQLFiltered = False |
189 |
Left = 624 |
190 |
Top = 144 |
191 |
end |
192 |
end |