ebook img

SQLite Data Access Components PDF

569 Pages·2016·6.37 MB·English
by  
Save to my drive
Quick download
Download
Most books are stored in the elastic cloud where traffic is expensive. For this reason, we have a limit on daily download.

Preview SQLite Data Access Components

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

Description:
Connecting in Direct Mode. Updating Data with LiteDAC Dataset Components. Master/Detail Relationships. Data Type Mapping. Data Encryption.
See more

The list of books you might like

Most books are stored in the elastic cloud where traffic is expensive. For this reason, we have a limit on daily download.