1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
|
object Form1: TForm1
Left = 389
Height = 740
Top = 156
Width = 416
Caption = 'SQLite DB Demo'
ClientHeight = 740
ClientWidth = 416
OnCreate = FormCreate
LCLVersion = '1.2.4.0'
object btnMakeNewDB: TButton
Left = 144
Height = 25
Top = 88
Width = 120
Caption = 'Make New DB'
OnClick = btnMakeNewDBClick
TabOrder = 0
end
object txtNew: TEdit
Left = 176
Height = 23
Top = 160
Width = 120
TabOrder = 1
end
object btnReKeyDB: TButton
Left = 144
Height = 25
Top = 200
Width = 120
Caption = 'ReKey DB'
OnClick = btnReKeyDBClick
TabOrder = 2
end
object Label2: TLabel
Left = 112
Height = 15
Top = 164
Width = 53
Caption = 'New Pass:'
ParentColor = False
end
object txtPass: TEdit
Left = 176
Height = 23
Top = 16
Width = 120
TabOrder = 3
end
object Label3: TLabel
Left = 88
Height = 15
Top = 20
Width = 77
Caption = 'Database Pass:'
ParentColor = False
end
object Shape1: TShape
AnchorSideLeft.Control = Owner
AnchorSideRight.Control = Owner
AnchorSideRight.Side = asrBottom
Left = 0
Height = 1
Top = 128
Width = 416
Anchors = [akTop, akLeft, akRight]
end
object Shape2: TShape
AnchorSideLeft.Control = Owner
AnchorSideRight.Control = Owner
AnchorSideRight.Side = asrBottom
Left = 0
Height = 1
Top = 240
Width = 416
Anchors = [akTop, akLeft, akRight]
end
object btnViewAppID: TButton
Left = 280
Height = 25
Top = 704
Width = 120
Caption = 'View Application_ID'
OnClick = btnViewAppIDClick
TabOrder = 4
end
object btnViewUserVersion: TButton
Left = 280
Height = 25
Top = 658
Width = 120
Caption = 'View User_Version'
OnClick = btnViewUserVersionClick
TabOrder = 5
end
object btnSetAppID: TButton
Left = 152
Height = 25
Top = 704
Width = 120
Caption = 'Set Application_ID'
OnClick = btnSetAppIDClick
TabOrder = 6
end
object btnSetUserVersion: TButton
Left = 152
Height = 25
Top = 658
Width = 120
Caption = 'Set User_Version'
OnClick = btnSetUserVersionClick
TabOrder = 7
end
object txtUser_Version: TEdit
Left = 24
Height = 23
Hint = 'Must be a 32-bit Signed Integer (LongInt -2147483648 .. 2147483647)'
Top = 658
Width = 120
ParentShowHint = False
ShowHint = True
TabOrder = 8
Text = '0'
end
object txtApplication_ID: TEdit
Left = 24
Height = 23
Hint = 'Must be a 32-bit Unsigned Integer (Longword 0 .. 4294967295)'
Top = 704
Width = 120
ParentShowHint = False
ShowHint = True
TabOrder = 9
Text = '0'
end
object Label4: TLabel
Left = 24
Height = 15
Top = 642
Width = 70
Caption = 'User_Version:'
ParentColor = False
end
object Label5: TLabel
Left = 24
Height = 15
Top = 688
Width = 79
Caption = 'Application_Id:'
ParentColor = False
end
object Label6: TLabel
Left = 16
Height = 50
Top = 584
Width = 384
AutoSize = False
Caption = 'Database Pragma Settings:'#13#10'user_version originally set to 23400001'#13#10'application_id originally set to 1189021115'
ParentColor = False
WordWrap = True
end
object Label7: TLabel
Left = 15
Height = 15
Top = 64
Width = 88
Caption = 'Create Database:'
ParentColor = False
end
object Label8: TLabel
Left = 16
Height = 15
Top = 136
Width = 137
Caption = 'Change the Database Key:'
ParentColor = False
end
object Shape3: TShape
AnchorSideLeft.Control = Owner
AnchorSideRight.Control = Owner
AnchorSideRight.Side = asrBottom
Left = 0
Height = 1
Top = 568
Width = 416
Anchors = [akTop, akLeft, akRight]
end
object Label9: TLabel
Left = 16
Height = 15
Top = 248
Width = 117
Caption = 'Add Info To Database:'
ParentColor = False
end
object txtUser_Name: TEdit
Left = 176
Height = 23
Top = 272
Width = 120
TabOrder = 10
end
object txtInfo: TEdit
Left = 176
Height = 23
Top = 296
Width = 120
TabOrder = 11
end
object btnAddToDB: TButton
Left = 144
Height = 25
Top = 336
Width = 120
Caption = 'Add To DB'
OnClick = btnAddToDBClick
TabOrder = 12
end
object Label10: TLabel
Left = 120
Height = 15
Top = 276
Width = 35
Caption = 'Name:'
ParentColor = False
end
object Label11: TLabel
Left = 120
Height = 15
Top = 300
Width = 24
Caption = 'Info:'
ParentColor = False
end
object Shape4: TShape
AnchorSideLeft.Control = Owner
AnchorSideRight.Control = Owner
AnchorSideRight.Side = asrBottom
Left = 0
Height = 1
Top = 376
Width = 416
Anchors = [akTop, akLeft, akRight]
end
object Label12: TLabel
Left = 15
Height = 15
Top = 384
Width = 83
Caption = 'Query Database'
ParentColor = False
end
object btnUpdateGrid: TButton
Left = 64
Height = 25
Top = 528
Width = 120
Caption = 'Update Grid'
OnClick = btnUpdateGridClick
TabOrder = 13
end
object DBGrid1: TDBGrid
Left = 8
Height = 104
Top = 408
Width = 400
Color = clWindow
Columns = <>
ReadOnly = True
TabOrder = 14
end
object Shape5: TShape
AnchorSideLeft.Control = Owner
AnchorSideRight.Control = Owner
AnchorSideRight.Side = asrBottom
Left = 0
Height = 1
Top = 56
Width = 416
Anchors = [akTop, akLeft, akRight]
end
object btnCountRows: TButton
Left = 224
Height = 25
Top = 528
Width = 120
Caption = 'Count Rows'
OnClick = btnCountRowsClick
TabOrder = 15
end
object DataSource1: TDataSource
DataSet = SQLQuery1
left = 376
top = 8
end
object SQLQuery1: TSQLQuery
FieldDefs = <>
Database = SQLite3Connection1
Transaction = SQLTransaction1
Params = <>
left = 376
top = 72
end
object SQLTransaction1: TSQLTransaction
Active = False
Database = SQLite3Connection1
left = 376
top = 144
end
object SQLite3Connection1: TSQLite3Connection
Connected = False
LoginPrompt = False
KeepConnection = False
Transaction = SQLTransaction1
LogEvents = []
Options = []
left = 376
top = 200
end
end
|
