SQLite Data Access Components

569 Pages·2016·6.37 MB·English

Contents I
Table of Contents
Part I What's New 1
Part II General Information 7
1 Overvi.e..w.. .............................................................................................................................. 8
2 Featu.r..e.s.. ............................................................................................................................. 10
3 Requ.i.r.e..m...e..n..t.s.. .................................................................................................................... 14
4 Comp..a..t.i.b..i.l.i.t.y.. ..................................................................................................................... 14
5 Using.. .S..e..v..e..r.a..l. .D..A...C.. .P..r..o..d..u..c..t.s.. .i.n.. .O...n..e.. .I.D..E... ......................................................................... 19
6 Comp..o..n..e..n..t. .L...i.s.t.. ................................................................................................................ 20
7 Hiera.r.c..h..y.. .C..h...a.r..t. ................................................................................................................. 21
8 Editio..n..s.. ............................................................................................................................. 23
9 Licen.s..i.n..g.. ........................................................................................................................... 25
10 Gettin..g.. .S..u..p...p..o..r.t. ................................................................................................................. 29
11 Frequ..e..n..t.l.y.. .A..s..k..e..d.. .Q..u...e.s..t.i.o...n..s.. ............................................................................................ 30
Part III Getting Started 34
1 Instal.l.a..t.i.o..n.. ......................................................................................................................... 40
2 Conn.e..c..t.i.n..g.. .T..o.. .S...Q..L..i.t..e. .D...a..t.a..b..a..s..e.. ...................................................................................... 43
3 Creat.i.n..g.. .D...a.t..a.b...a.s..e.. .O...b..j.e..c..t.s.. ............................................................................................... 48
4 Deleti.n...g.. .D..a..t.a.. ..................................................................................................................... 51
5 Insert.i.n...g.. .D..a..t.a.. .I.n..t.o.. .T...a..b..l.e..s. ................................................................................................. 54
6 Retrie..v..i.n..g.. .D..a..t.a.. .................................................................................................................. 60
7 Modif.y..i.n..g.. .D...a..t.a.. .................................................................................................................. 62
8 Demo.. .P..r.o...j.e.c..t.s.. ................................................................................................................... 66
9 Deplo..y..m...e..n..t. ....................................................................................................................... 70
Part IV Using LiteDAC 72
1 Conn.e..c..t.i.n..g.. .i.n.. .D...i.r.e..c..t. .M...o..d..e.. ............................................................................................... 72
2 Disab.l.i.n...g.. .D..i.r..e.c..t. .M...o..d..e.. ....................................................................................................... 74
3 Upda.t.i.n..g.. .D...a.t..a. .w...i.t.h.. .L..i.t..e.D...A..C... .D..a..t.a..s..e..t. .C...o..m...p..o..n..e..n..t.s.. .......................................................... 75
4 Maste.r../.D..e..t.a..i.l. .R...e..l.a.t..i.o..n..s..h..i.p..s.. .............................................................................................. 75
5 Data T...y..p..e.. .M..a..p..p..i.n..g... ........................................................................................................... 78
6 Data E...n..c..r.y..p..t.i.o..n.. ................................................................................................................. 84
7 Datab..a.s..e.. .F..i.l.e.. .E..n...c.r..y..p..t.i.o..n.. .................................................................................................. 86
8 Disco.n...n..e..c.t..e.d... .M..o..d..e.. ........................................................................................................... 90
9 Batch.. .O..p..e..r..a.t..i.o..n..s.. .............................................................................................................. 91
10 Increa..s..i.n..g.. .P...e.r..f.o..r.m....a..n..c..e. .................................................................................................... 96
© 2022 Devart
I
II SQLite Data Access Components
11 Work.i.n..g.. .i.n.. .a..n.. .U..n...s.t..a.b...l.e. .N...e..t.w...o..r.k.. ...................................................................................... 98
12 Macro..s.. ............................................................................................................................... 99
13 Data.S...e.t.. .M..a..n..a..g..e..r. .............................................................................................................. 100
14 DBM..o..n..i.t.o..r. ........................................................................................................................ 105
15 Writ.i.n..g.. .G..U...I. .A..p..p...l.i.c.a..t.i.o...n..s.. .w..i.t.h.. .L...i.t.e..D..A..C... .......................................................................... 106
16 Con.n..e..c..t.i.o..n.. .P..o..o..l.i.n...g.. ........................................................................................................ 106
17 64-b.i.t. .D...e.v..e..l.o..p..m....e..n..t. .w..i.t..h.. .E..m...b..a..r..c.a..d..e..r..o.. .R..A...D.. .S..t..u..d..i.o.. .X..E..2.. ............................................... 108
18 Data.b..a..s..e.. .S..p..e..c..i.f.i.c.. .A...s.p...e.c..t.s.. .o..f.. .6.4..-.b...i.t. .D..e..v..e..l.o..p..m...e..n..t. ......................................................... 114
Part V Reference 115
1 CRA.c..c..e..s..s.. ........................................................................................................................ 116
Classes .......................................................................................................................................................... 117
TCRCurso..r.. .C..l.a..s..s............................................................................................................................................. 117
Members ......................................................................................................................................... 118
Types .......................................................................................................................................................... 118
TBeforeF.e..t.c..h.P...r.o..c.. .P..r.o..c..e..d..u..r.e.. .R..e..f.e..r..e..n.c..e.......................................................................................................... 119
Enumerations.. ........................................................................................................................................................ 119
TCRIsola.t.io..n..L..e..v..e..l. .E..n..u..m..e..r..a..t.io..n........................................................................................................................ 120
TCRTrans..a..c..t.i.o..n.A...c.t.i.o..n.. .E..n..u..m...e..r.a..t.i.o..n................................................................................................................. 121
TCursorS.t.a..t.e.. .E..n..u..m...e..r.a..t.i.o..n............................................................................................................................... 121
2 CRB.a..t.c..h..M...o..v..e.. .................................................................................................................. 122
Classes .......................................................................................................................................................... 123
TCRBatch..M...o..v..e.. .C..l.a..s..s...................................................................................................................................... 123
Members ......................................................................................................................................... 124
Properties ......................................................................................................................................... 125
AbortOnKeyVio.l. .P..r.o..p..e..r.t.y..................................................................................................................... 127
AbortOnProblem... .P..r.o..p..e..r.t.y.................................................................................................................... 127
ChangedCount .P...r.o..p..e..r.t.y...................................................................................................................... 128
CommitCount P..r.o..p..e..r.t.y........................................................................................................................ 128
Destination Pro..p.e..r..t.y........................................................................................................................... 129
FieldMappingM.o..d..e.. .P..r.o..p..e..r.t.y................................................................................................................ 129
KeyViolCount P..r.o..p..e..r.t.y........................................................................................................................ 130
Mappings Prop.e..r.t.y.............................................................................................................................. 131
Mode Property................................................................................................................................... 131
MovedCount Pr..o..p.e..r..t.y......................................................................................................................... 132
ProblemCount P...r.o..p..e..r.t.y....................................................................................................................... 132
RecordCount P.r.o..p..e..r.t.y......................................................................................................................... 133
Source Propert.y.................................................................................................................................. 134
Methods ......................................................................................................................................... 134
Execute Metho.d.................................................................................................................................. 135
Events ......................................................................................................................................... 135
OnBatchMoveP..r.o..g..r.e..s..s.. .E..v..e..n..t............................................................................................................ 136
Types .......................................................................................................................................................... 136
TCRBatch..M...o..v..e..P..r.o..g..r.e..s..s..E..v..e..n..t. .P..r.o..c..e..d..u..r.e.. .R...e..f.e..r.e..n..c.e....................................................................................... 136
Enumerations.. ........................................................................................................................................................ 137
TCRBatch..M...o..d..e.. .E..n..u..m..e..r..a..t.io..n............................................................................................................................ 137
TCRField.M..a..p..p..i.n..g..M..o..d..e.. .E...n.u..m...e..r.a..t.i.o..n................................................................................................................ 138
3 CRE.n..c..r..y.p...t.i.o..n.. .................................................................................................................. 139
Classes .......................................................................................................................................................... 139
TCREncry..p..t.o..r. .C...la..s..s......................................................................................................................................... 140
© 2022 Devart
Contents III
Members ......................................................................................................................................... 140
Properties ......................................................................................................................................... 141
DataHeader Pr.o..p..e..r.t.y.......................................................................................................................... 141
EncryptionAlgo.r.i.t.h.m... .P..r..o..p.e..r..t.y.............................................................................................................. 142
HashAlgorithm .P..r.o..p..e..r.t.y....................................................................................................................... 142
InvalidHashActi.o..n.. .P..r..o..p.e..r..t.y................................................................................................................. 143
Password Prop.e..r.t.y.............................................................................................................................. 144
Methods ......................................................................................................................................... 144
SetKey Method................................................................................................................................... 145
Enumerations.. ........................................................................................................................................................ 146
TCREncD..a..t.a..H..e..a..d..e..r. .E..n..u..m...e..r.a..t.i.o..n.................................................................................................................... 146
TCREncry..p..t.i.o..n..A..lg..o..r.i.t.h..m... .E..n..u..m..e..r..a..t.io..n............................................................................................................... 147
TCRHash.A..l.g..o..r.i.t.h..m.. .E...n.u..m...e..r.a..t.i.o..n....................................................................................................................... 147
TCRInvali.d..H..a..s..h..A..c..t.i.o..n.. .E..n..u..m..e..r..a..t.io..n.................................................................................................................. 148
4 CRG..r.i.d.. ............................................................................................................................. 148
Classes .......................................................................................................................................................... 149
TCRDBG.r.i.d. .C...l.a..s.s............................................................................................................................................. 149
Members ......................................................................................................................................... 149
Properties ......................................................................................................................................... 151
Columns Prope.r.t.y................................................................................................................................ 153
Filtered Proper.t.y................................................................................................................................. 153
LevelDelimiterC..h..a..r. .P..r..o..p.e..r..t.y............................................................................................................... 154
OnMemoClick P..r.o..p..e..r.t.y........................................................................................................................ 154
OptionsEx Prop..e..r.t.y............................................................................................................................. 154
OptionsMenu P.r.o..p..e..r.t.y......................................................................................................................... 155
Methods ......................................................................................................................................... 156
ActivateFilterEd..i.t. .M...e..t.h..o..d.................................................................................................................... 157
ActivateSearch.E...d.i.t. .M...e..t.h..o..d................................................................................................................. 158
AdjustColumns .M...e..t.h..o..d........................................................................................................................ 158
ApplyFilter Meth..o..d............................................................................................................................... 159
CalcTitleLevel M...e..t.h..o..d......................................................................................................................... 159
ClearFilters Me.t.h..o..d............................................................................................................................. 160
ClearSorting M.e..t.h.o..d............................................................................................................................ 160
DataChanged M...e..t.h.o..d.......................................................................................................................... 160
GetGridSize Me..t.h..o..d............................................................................................................................ 161
GetTitleLevel M..e..t.h..o..d.......................................................................................................................... 161
Events ......................................................................................................................................... 162
OnGetCellPara.m...s. .E...v..e..n.t..................................................................................................................... 162
5 DAA.l.e..r.t..e.r.. ......................................................................................................................... 163
Classes .......................................................................................................................................................... 163
TDAAlerte..r. .C..l.a..s..s.............................................................................................................................................. 163
Members ......................................................................................................................................... 164
Properties ......................................................................................................................................... 165
Active Property................................................................................................................................... 165
AutoRegister P.r.o..p..e..r.t.y......................................................................................................................... 166
Connection Pro..p.e..r..t.y........................................................................................................................... 167
Methods ......................................................................................................................................... 167
SendEvent Met.h..o..d.............................................................................................................................. 168
Start Method ................................................................................................................................... 168
Stop Method ................................................................................................................................... 169
Events ......................................................................................................................................... 169
OnError Event................................................................................................................................... 170
Types .......................................................................................................................................................... 170
© 2022 Devart
III
IV SQLite Data Access Components
TAlerterE.r.r.o..r.E..v..e..n..t. .P..r..o..c.e..d..u..r.e.. .R...e..f.e..r.e..n..c..e......................................................................................................... 171
6 DAD.u..m....p.. .......................................................................................................................... 171
Classes .......................................................................................................................................................... 172
TDADump.. .C..l.a..s..s............................................................................................................................................... 172
Members ......................................................................................................................................... 173
Properties ......................................................................................................................................... 174
Connection Pro..p.e..r..t.y........................................................................................................................... 175
Debug Property................................................................................................................................... 176
Options Proper.t.y................................................................................................................................. 177
SQL Property ................................................................................................................................... 177
TableNames Pr.o..p..e..r.t.y.......................................................................................................................... 178
Methods ......................................................................................................................................... 179
Backup Method................................................................................................................................... 179
BackupQuery M..e..t.h..o..d.......................................................................................................................... 180
BackupToFile M..e..t.h..o..d.......................................................................................................................... 181
BackupToStrea.m... .M...e..t.h..o..d.................................................................................................................... 182
Restore Metho.d.................................................................................................................................. 182
RestoreFromFi.l.e.. .M..e..t.h..o..d..................................................................................................................... 183
RestoreFromSt.r.e..a..m... .M...e..t.h..o..d............................................................................................................... 184
Events ......................................................................................................................................... 185
OnBackupProg.r.e..s..s.. .E..v..e..n..t.................................................................................................................. 185
OnError Event................................................................................................................................... 186
OnRestoreProg..r.e..s..s.. .E..v..e..n..t................................................................................................................. 187
TDADump..O..p..t.i.o..n..s.. .C..l.a..s..s................................................................................................................................... 187
Members ......................................................................................................................................... 188
Properties ......................................................................................................................................... 188
AddDrop Prope.r.t.y................................................................................................................................ 189
CompleteInsert. .P..r.o..p..e..r.t.y...................................................................................................................... 189
GenerateHeade..r. .P...r.o..p..e..r.t.y................................................................................................................... 190
QuoteNames P.r.o..p..e..r.t.y......................................................................................................................... 191
Types .......................................................................................................................................................... 191
TDABack.u.p..P...r.o..g..r.e..s..s.E...v..e..n.t. .P...r.o..c..e..d..u.r..e.. .R..e..f.e..r.e..n..c..e............................................................................................. 191
TDAResto..r.e..P...r.o..g..r.e..s..s.E...v..e..n.t. .P...r.o..c..e..d..u.r..e.. .R..e..f.e..r.e..n..c..e............................................................................................ 192
7 DAL.o..a..d..e..r. ......................................................................................................................... 193
Classes .......................................................................................................................................................... 193
TDAColum..n.. .C...la..s..s............................................................................................................................................. 194
Members ......................................................................................................................................... 195
Properties ......................................................................................................................................... 195
FieldType Prop.e..r.t.y.............................................................................................................................. 195
Name Property................................................................................................................................... 196
TDAColum..n..s.. .C...la..s..s........................................................................................................................................... 197
Members ......................................................................................................................................... 197
Properties ......................................................................................................................................... 198
Items Property(.I.n..d..e..x..e..r.)...................................................................................................................... 198
TDALoad.e..r. .C..l.a..s..s............................................................................................................................................. 199
Members ......................................................................................................................................... 199
Properties ......................................................................................................................................... 200
Columns Prope.r.t.y................................................................................................................................ 201
Connection Pro..p.e..r..t.y........................................................................................................................... 202
TableName Pro.p..e..r.t.y............................................................................................................................ 202
Methods ......................................................................................................................................... 203
CreateColumns. .M...e..t.h..o..d....................................................................................................................... 203
Load Method ................................................................................................................................... 204
© 2022 Devart
Contents V
LoadFromData.S..e..t. .M...e..t.h..o..d.................................................................................................................. 205
PutColumnData.. .M..e..t.h..o..d....................................................................................................................... 205
PutColumnData.. .M..e..t.h..o..d....................................................................................................................... 206
PutColumnData.. .M..e..t.h..o..d....................................................................................................................... 207
Events ......................................................................................................................................... 207
OnGetColumnD..a..t.a.. .E..v..e..n..t................................................................................................................... 208
OnProgress Ev.e..n..t.............................................................................................................................. 209
OnPutData Eve..n..t............................................................................................................................... 210
TDALoad.e..r.O..p..t.i.o..n..s.. .C..l.a..s..s................................................................................................................................. 211
Members ......................................................................................................................................... 211
Properties ......................................................................................................................................... 211
UseBlankValue.s.. .P..r.o..p..e..r.t.y.................................................................................................................... 212
Types .......................................................................................................................................................... 212
TDAPutDa..t.a..E...v..e..n.t. .P...r.o..c..e..d..u.r..e.. .R..e..f.e..r.e..n..c..e.......................................................................................................... 213
TGetColu.m..n..D...a..t.a..E..v..e..n..t. .P..r.o..c..e..d..u..r.e.. .R..e..f.e..r..e..n.c..e................................................................................................... 213
TLoaderP.r..o..g.r..e..s.s..E...v.e..n..t. .P...r.o..c..e..d.u..r.e.. .R...e..f.e..r.e..n..c..e.................................................................................................. 214
8 DAS.c..r.i.p..t.. .......................................................................................................................... 215
Classes .......................................................................................................................................................... 215
TDAScrip.t. .C..l.a..s..s............................................................................................................................................... 216
Members ......................................................................................................................................... 217
Properties ......................................................................................................................................... 218
Connection Pro..p.e..r..t.y........................................................................................................................... 219
DataSet Prope.r.t.y................................................................................................................................ 220
Debug Property................................................................................................................................... 221
Delimiter Prope.r..t.y............................................................................................................................... 221
EndLine Proper..t.y................................................................................................................................ 222
EndOffset Prop.e..r.t.y.............................................................................................................................. 222
EndPos Proper.t.y................................................................................................................................. 223
Macros Proper.t.y................................................................................................................................. 223
SQL Property ................................................................................................................................... 224
StartLine Prope..r.t.y............................................................................................................................... 224
StartOffset Pro.p..e..r.t.y............................................................................................................................ 225
StartPos Prope.r..t.y............................................................................................................................... 225
Statements Pro..p.e..r..t.y........................................................................................................................... 226
Methods ......................................................................................................................................... 227
BreakExec Met.h..o..d.............................................................................................................................. 228
ErrorOffset Me.t.h.o..d.............................................................................................................................. 228
Execute Metho.d.................................................................................................................................. 229
ExecuteFile Me..t.h.o..d............................................................................................................................. 230
ExecuteNext M.e..t.h..o..d........................................................................................................................... 230
ExecuteStream. .M...e..t.h..o..d....................................................................................................................... 231
FindMacro Met.h..o..d.............................................................................................................................. 232
MacroByName .M...e..t.h..o..d........................................................................................................................ 232
Events ......................................................................................................................................... 233
AfterExecute E.v..e..n.t............................................................................................................................. 234
BeforeExecute. .E..v..e..n..t......................................................................................................................... 235
OnError Event................................................................................................................................... 235
TDAState.m...e..n..t. .C..l.a..s..s........................................................................................................................................ 236
Members ......................................................................................................................................... 236
Properties ......................................................................................................................................... 237
EndLine Proper..t.y................................................................................................................................ 238
EndOffset Prop.e..r.t.y.............................................................................................................................. 239
EndPos Proper.t.y................................................................................................................................. 239
Omit Property ................................................................................................................................... 240
© 2022 Devart
V
VI SQLite Data Access Components
Params Proper.t.y................................................................................................................................. 240
Script Property................................................................................................................................... 241
SQL Property ................................................................................................................................... 241
StartLine Prope..r.t.y............................................................................................................................... 242
StartOffset Pro.p..e..r.t.y............................................................................................................................ 242
StartPos Prope.r..t.y............................................................................................................................... 243
Methods ......................................................................................................................................... 243
Execute Metho.d.................................................................................................................................. 244
TDAState.m...e..n..t.s. .C...l.a..s.s....................................................................................................................................... 244
Members ......................................................................................................................................... 245
Properties ......................................................................................................................................... 245
Items Property(.I.n..d..e..x..e..r.)...................................................................................................................... 246
Types .......................................................................................................................................................... 246
TAfterSta.t.e..m..e..n..t.E...x.e..c..u..t.e..E..v..e..n..t. .P..r.o..c..e..d..u..r.e.. .R...e..f.e..r.e..n..c.e........................................................................................ 247
TBeforeS.t.a..t.e..m...e..n.t.E...x.e..c..u..t.e..E..v..e..n..t. .P..r..o..c.e..d..u..r.e.. .R...e..f.e..r.e..n..c..e.................................................................................... 247
TOnErrorE...v..e..n.t. .P...r.o..c..e..d..u.r..e.. .R..e..f.e..r.e..n..c..e............................................................................................................... 248
Enumerations.. ........................................................................................................................................................ 248
TErrorAct.i.o..n.. .E..n..u..m..e..r.a..t.i.o..n................................................................................................................................. 249
9 DAS.Q...L..M..o...n..i.t.o..r. ................................................................................................................. 249
Classes .......................................................................................................................................................... 250
TCustomD..A...S..Q...L..M..o..n..i.t.o..r. .C...la..s..s.......................................................................................................................... 251
Members ......................................................................................................................................... 251
Properties ......................................................................................................................................... 252
Active Property................................................................................................................................... 253
DBMonitorOptio..n..s.. .P..r.o..p..e..r.t.y................................................................................................................. 253
Options Proper.t.y................................................................................................................................. 254
TraceFlags Pro.p..e..r.t.y............................................................................................................................ 254
Events ......................................................................................................................................... 255
OnSQL Event ................................................................................................................................... 255
TDBMonit.o..r..O..p..t.i.o..n..s.. .C..l.a..s..s................................................................................................................................ 256
Members ......................................................................................................................................... 256
Properties ......................................................................................................................................... 257
Host Property ................................................................................................................................... 258
Port Property ................................................................................................................................... 258
ReconnectTime..o..u..t. .P..r.o..p..e..r.t.y................................................................................................................ 259
SendTimeout P.r.o..p..e..r.t.y......................................................................................................................... 259
Types .......................................................................................................................................................... 260
TDATrace..F..l.a..g.s.. .S...e..t......................................................................................................................................... 260
TMonitorO..p..t.i.o..n..s.. .S..e..t........................................................................................................................................ 260
TOnSQLE..v..e..n..t. .P..r.o..c..e..d..u..r.e.. .R..e..f.e..r.e..n..c..e................................................................................................................ 261
Enumerations.. ........................................................................................................................................................ 261
TDATrace..F..l.a..g. .E...n..u.m...e..r.a..t.i.o..n.............................................................................................................................. 262
TMonitorO..p..t.i.o..n.. .E..n..u..m...e..r.a..t.i.o..n............................................................................................................................ 263
10 DBA.c..c..e..s..s.. ........................................................................................................................ 263
Classes .......................................................................................................................................................... 266
EDAError. .C..l.a..s..s................................................................................................................................................ 268
Members ......................................................................................................................................... 268
Properties ......................................................................................................................................... 269
Component Pro..p.e..r..t.y........................................................................................................................... 269
ErrorCode Prop..e..r.t.y............................................................................................................................. 270
TCRData.S..o..u..r.c..e.. .C..l.a..s..s..................................................................................................................................... 270
Members ......................................................................................................................................... 271
TCustomC..o..n..n..e..c..t.D..i.a..l.o..g.. .C..l.a..s..s.......................................................................................................................... 271
© 2022 Devart
Contents VII
Members ......................................................................................................................................... 272
Properties ......................................................................................................................................... 272
CancelButton P..r.o..p..e..r.t.y........................................................................................................................ 273
Caption Proper.t.y................................................................................................................................. 274
ConnectButton .P...r.o..p..e..r.t.y...................................................................................................................... 274
DialogClass Pr.o..p.e..r..t.y.......................................................................................................................... 275
LabelSet Prope..r.t.y............................................................................................................................... 275
Retries Propert.y.................................................................................................................................. 276
StoreLogInfo P.r.o..p..e..r.t.y......................................................................................................................... 276
Methods ......................................................................................................................................... 277
Execute Metho.d.................................................................................................................................. 277
TCustomD..A...C..o..n..n..e..c..t.io..n.. .C...la..s..s........................................................................................................................... 278
Members ......................................................................................................................................... 279
Properties ......................................................................................................................................... 280
ConnectDialog .P...r.o..p..e..r.t.y...................................................................................................................... 281
ConnectString P...r.o..p..e..r.t.y....................................................................................................................... 282
ConvertEOL Pr.o..p..e..r.t.y.......................................................................................................................... 283
InTransaction P..r.o..p..e..r.t.y........................................................................................................................ 284
LoginPrompt Pr.o..p..e..r.t.y.......................................................................................................................... 284
Options Proper.t.y................................................................................................................................. 285
Pooling Propert.y.................................................................................................................................. 286
PoolingOptions. .P..r.o..p..e..r.t.y...................................................................................................................... 287
Methods ......................................................................................................................................... 288
ApplyUpdates M..e..t.h..o..d.......................................................................................................................... 289
ApplyUpdates M..e..t.h..o..d.......................................................................................................................... 289
ApplyUpdates M..e..t.h..o..d.......................................................................................................................... 290
Commit Method................................................................................................................................... 291
Connect Metho.d.................................................................................................................................. 291
CreateSQL Me.t.h..o..d............................................................................................................................. 292
Disconnect Me.t.h..o..d............................................................................................................................. 293
GetKeyFieldNa.m...e..s.. .M..e..t.h..o..d................................................................................................................. 293
GetTableName.s. .M...e..t.h..o..d...................................................................................................................... 294
MonitorMessag.e.. .M...e..t.h..o..d..................................................................................................................... 295
Ping Method ................................................................................................................................... 296
RemoveFromP.o..o..l .M...e..t.h..o..d................................................................................................................... 296
Rollback Metho.d.................................................................................................................................. 297
StartTransactio.n.. .M...e..t.h..o..d..................................................................................................................... 298
Events ......................................................................................................................................... 298
OnConnectionL..o..s.t. .E...v..e..n.t.................................................................................................................... 299
OnError Event................................................................................................................................... 300
TCustomD..A...D..a..t.a..S..e..t. .C...l.a..s.s................................................................................................................................ 300
Members ......................................................................................................................................... 301
Properties ......................................................................................................................................... 307
BaseSQL Prop.e..r.t.y.............................................................................................................................. 310
Conditions Prop..e..r.t.y............................................................................................................................. 311
Connection Pro..p.e..r..t.y........................................................................................................................... 312
DataTypeMap P...r.o..p..e..r.t.y....................................................................................................................... 312
Debug Property................................................................................................................................... 313
DetailFields Pro..p..e..r.t.y........................................................................................................................... 313
Disconnected P..r.o..p..e..r.t.y........................................................................................................................ 314
FetchRows Pro..p.e..r..t.y........................................................................................................................... 315
FilterSQL Prop.e..r.t.y.............................................................................................................................. 315
FinalSQL Prope..r.t.y............................................................................................................................... 316
IsQuery Proper.t.y................................................................................................................................. 317
© 2022 Devart
VII
VIII SQLite Data Access Components
KeyFields Prop.e..r.t.y.............................................................................................................................. 317
MacroCount Pr.o..p..e..r.t.y.......................................................................................................................... 318
Macros Proper.t.y................................................................................................................................. 319
MasterFields P.r.o..p..e..r.t.y......................................................................................................................... 320
MasterSource P...r.o..p..e..r.t.y....................................................................................................................... 321
Options Proper.t.y................................................................................................................................. 321
ParamCheck P.r.o..p..e..r.t.y......................................................................................................................... 324
ParamCount Pr.o..p..e..r.t.y.......................................................................................................................... 324
Params Proper.t.y................................................................................................................................. 325
ReadOnly Prop.e..r.t.y.............................................................................................................................. 326
RefreshOptions.. .P..r.o..p..e..r.t.y..................................................................................................................... 326
RowsAffected P..r..o..p.e..r..t.y....................................................................................................................... 327
SQL Property ................................................................................................................................... 328
SQLDelete Pro.p..e..r.t.y............................................................................................................................ 328
SQLInsert Prop..e..r.t.y............................................................................................................................. 329
SQLLock Prope..r.t.y............................................................................................................................... 330
SQLRecCount .P..r.o..p..e..r.t.y....................................................................................................................... 331
SQLRefresh Pr.o..p..e..r.t.y.......................................................................................................................... 332
SQLUpdate Pro..p..e..r.t.y........................................................................................................................... 333
UniDirectional P..r..o..p.e..r..t.y....................................................................................................................... 334
Methods ......................................................................................................................................... 335
AddWhere Met.h.o..d............................................................................................................................... 338
BreakExec Met.h..o..d.............................................................................................................................. 339
CreateBlobStre.a..m... .M...e..t.h..o..d.................................................................................................................. 339
DeleteWhere M..e..t.h..o..d.......................................................................................................................... 340
Execute Metho.d.................................................................................................................................. 341
Execute Metho.d.................................................................................................................................. 341
Execute Metho.d.................................................................................................................................. 342
Executing Meth.o..d................................................................................................................................ 343
Fetched Metho.d.................................................................................................................................. 343
Fetching Metho.d.................................................................................................................................. 344
FetchingAll Met.h..o..d.............................................................................................................................. 345
FindKey Metho.d.................................................................................................................................. 345
FindMacro Met.h..o..d.............................................................................................................................. 346
FindNearest Me..t.h..o..d............................................................................................................................ 347
FindParam Met.h..o..d.............................................................................................................................. 348
GetDataType M..e..t.h..o..d.......................................................................................................................... 348
GetFieldObject. .M..e..t.h..o..d........................................................................................................................ 349
GetFieldPrecis.io..n.. .M...e..t.h..o..d................................................................................................................... 350
GetFieldScale M...e..t.h..o..d......................................................................................................................... 351
GetKeyFieldNa.m...e..s.. .M..e..t.h..o..d................................................................................................................. 351
GetOrderBy Me..t.h..o..d............................................................................................................................ 352
GotoCurrent Me..t.h..o..d............................................................................................................................ 353
Lock Method ................................................................................................................................... 353
MacroByName .M...e..t.h..o..d........................................................................................................................ 354
ParamByName. .M...e..t.h.o..d........................................................................................................................ 355
Prepare Metho.d.................................................................................................................................. 356
RefreshRecord. .M...e..t.h..o..d....................................................................................................................... 357
RestoreSQL M.e..t.h..o..d........................................................................................................................... 358
SaveSQL Meth.o..d................................................................................................................................ 358
SetOrderBy Me..t.h.o..d............................................................................................................................. 359
SQLSaved Met.h..o..d.............................................................................................................................. 360
UnLock Method................................................................................................................................... 360
Events ......................................................................................................................................... 361
© 2022 Devart
Contents IX
AfterExecute E.v..e..n.t............................................................................................................................. 362
AfterFetch Eve.n..t................................................................................................................................ 362
AfterUpdateExe..c..u.t.e.. .E...v..e..n.t.................................................................................................................. 363
BeforeFetch Ev..e..n..t............................................................................................................................. 363
BeforeUpdateE.x..e..c..u..t.e.. .E..v..e..n..t.............................................................................................................. 364
TCustomD..A...S..Q...L.. .C..l.a..s..s..................................................................................................................................... 364
Members ......................................................................................................................................... 365
Properties ......................................................................................................................................... 367
ChangeCursor .P..r.o..p..e..r.t.y....................................................................................................................... 368
Connection Pro..p.e..r..t.y........................................................................................................................... 369
Debug Property................................................................................................................................... 369
FinalSQL Prope..r.t.y............................................................................................................................... 370
MacroCount Pr.o..p..e..r.t.y.......................................................................................................................... 370
Macros Proper.t.y................................................................................................................................. 371
ParamCheck P.r.o..p..e..r.t.y......................................................................................................................... 372
ParamCount Pr.o..p..e..r.t.y.......................................................................................................................... 373
Params Proper.t.y................................................................................................................................. 373
ParamValues P.r..o..p.e..r..t.y.(..I.n.d..e..x..e..r.).......................................................................................................... 374
Prepared Prope..r.t.y............................................................................................................................... 375
RowsAffected P..r..o..p.e..r..t.y....................................................................................................................... 376
SQL Property ................................................................................................................................... 376
Methods ......................................................................................................................................... 377
BreakExec Met.h..o..d.............................................................................................................................. 378
Execute Metho.d.................................................................................................................................. 378
Execute Metho.d.................................................................................................................................. 379
Execute Metho.d.................................................................................................................................. 379
Executing Meth.o..d................................................................................................................................ 380
FindMacro Met.h..o..d.............................................................................................................................. 381
FindParam Met.h..o..d.............................................................................................................................. 381
MacroByName .M...e..t.h..o..d........................................................................................................................ 382
ParamByName. .M...e..t.h.o..d........................................................................................................................ 383
Prepare Metho.d.................................................................................................................................. 384
UnPrepare Met.h..o..d.............................................................................................................................. 385
WaitExecuting .M...e..t.h..o..d........................................................................................................................ 385
Events ......................................................................................................................................... 386
AfterExecute E.v..e..n.t............................................................................................................................. 386
TCustomD..A...U..p..d..a..t.e..S..Q...L.. .C..l.a..s..s.......................................................................................................................... 387
Members ......................................................................................................................................... 388
Properties ......................................................................................................................................... 389
DataSet Prope.r.t.y................................................................................................................................ 390
DeleteObject P.r.o..p..e..r.t.y......................................................................................................................... 391
DeleteSQL Pro.p..e..r.t.y............................................................................................................................ 391
InsertObject Pr.o..p..e..r.t.y.......................................................................................................................... 392
InsertSQL Prop..e..r.t.y............................................................................................................................. 392
LockObject Pro.p..e..r.t.y............................................................................................................................ 393
LockSQL Prope..r.t.y............................................................................................................................... 394
ModifyObject P.r.o..p..e..r.t.y......................................................................................................................... 394
ModifySQL Pro.p..e..r.t.y............................................................................................................................ 395
RefreshObject .P..r.o..p..e..r.t.y....................................................................................................................... 395
RefreshSQL Pr.o..p..e..r.t.y.......................................................................................................................... 396
SQL Property(I.n..d..e..x.e..r.)........................................................................................................................ 397
Methods ......................................................................................................................................... 397
Apply Method ................................................................................................................................... 398
ExecSQL Meth.o..d................................................................................................................................ 399
© 2022 Devart
IX
X SQLite Data Access Components
TDACond.i.t.i.o..n. .C...l.a..s.s.......................................................................................................................................... 399
Members ......................................................................................................................................... 400
Properties ......................................................................................................................................... 401
Enabled Proper.t.y................................................................................................................................. 401
Name Property................................................................................................................................... 402
Value Property................................................................................................................................... 402
Methods ......................................................................................................................................... 402
Disable Method................................................................................................................................... 403
Enable Method................................................................................................................................... 403
TDACond.i.t.i.o..n.s.. .C...la..s..s........................................................................................................................................ 404
Members ......................................................................................................................................... 404
Properties ......................................................................................................................................... 405
Condition Prope..r..t.y.(..I.n.d..e..x..e..r.)................................................................................................................ 406
Enabled Proper.t.y................................................................................................................................. 407
Items Property(.I.n..d..e..x..e..r.)...................................................................................................................... 407
Text Property ................................................................................................................................... 408
WhereSQL Pro.p..e..r.t.y............................................................................................................................ 408
Methods ......................................................................................................................................... 408
Add Method ................................................................................................................................... 409
Add Method ................................................................................................................................... 410
Add Method ................................................................................................................................... 410
Delete Method................................................................................................................................... 411
Disable Method................................................................................................................................... 412
Enable Method................................................................................................................................... 412
Find Method ................................................................................................................................... 412
Get Method ................................................................................................................................... 413
IndexOf Method................................................................................................................................... 413
Remove Metho.d.................................................................................................................................. 414
TDAConn.e..c..t.i.o..n.O...p..t.i.o..n..s. .C...l.a..s.s........................................................................................................................... 414
Members ......................................................................................................................................... 415
Properties ......................................................................................................................................... 415
AllowImplicitCo.n.n..e..c..t. .P..r..o..p.e..r..t.y............................................................................................................. 416
DisconnectedM..o..d.e.. .P...r.o..p..e..r.t.y............................................................................................................... 417
KeepDesignCo.n..n..e..c.t.e..d.. .P...r.o..p..e..r.t.y......................................................................................................... 417
LocalFailover P..r.o..p..e..r.t.y........................................................................................................................ 418
TDAConn.e..c..t.i.o..n.S...S..L..O...p..t.io..n..s.. .C...la..s..s.................................................................................................................... 418
Members ......................................................................................................................................... 419
Properties ......................................................................................................................................... 419
CACert Propert.y.................................................................................................................................. 420
Cert Property ................................................................................................................................... 420
CipherList Prop..e..r.t.y............................................................................................................................. 421
Key Property ................................................................................................................................... 421
TDADataS...e..t.O..p..t.i.o..n..s.. .C..l.a..s..s............................................................................................................................... 422
Members ......................................................................................................................................... 422
Properties ......................................................................................................................................... 424
AutoPrepare Pr.o..p..e..r.t.y.......................................................................................................................... 426
CacheCalcField..s.. .P..r.o..p..e..r.t.y................................................................................................................... 427
CompressBlobM...o..d..e.. .P..r.o..p..e..r.t.y.............................................................................................................. 427
DefaultValues P..r.o..p..e..r.t.y........................................................................................................................ 428
DetailDelay Pro..p..e..r.t.y........................................................................................................................... 428
FieldsOrigin Pro..p..e..r.t.y........................................................................................................................... 429
FlatBuffers Pro.p..e..r.t.y............................................................................................................................ 429
InsertAllSetFiel.d..s. .P...r.o..p..e..r.t.y.................................................................................................................. 430
LocalMasterDe.t.a..i.l. .P..r.o..p..e..r.t.y................................................................................................................. 430
© 2022 Devart