Index_T

T

Table Browser

decrypting free tables with, 46

encrypting free tables with, 43–45

filtering, 75–76

maintaining tables with, 46–53

navigating and editing data in, 41–43

selecting indexes, 75–77

TABLE reserved keyword, 239, 274–275

tables

See also creating tables example

access rights to, 111–118, 311–314

adding fields to, 35–37, 271–275

adding indexes to, 51, 71–74, 273–274

adding nonstructural indexes to, 318

adding records to, 41–43, 296–297

adding to data dictionaries, 100–102, 105–106, 317–318

ADT format advantages, 31–32

ADT format specifications, 32

ADT table field types, 36

Advantage proprietary (ADT) format, 31–33

auto-create, 133, 322

changes properties of, 322–323

changing field properties, 48–22, 323

changing structure of, 48–50, 274–275

Clipper format, 31

combining, 292–293

constraints versus structures, 125

creating, 33–38, 100, 271–273

database, 33

DBF format, 31

decrypting, 46

defined, 30

deleting, 275

deleting records from, 41, 298

description, 134–135

editing data in, 41–43

emptying, 53

encrypting, 43–45, 103–106

exporting data from, 53, 58–59

exporting, structures as code, 59–62

FoxPro format, 31

free versus database, 32–33

importing data into, 53–58

inserting records into, 41–43, 296–297

joining, 290–292

listing, 304

listing columns in, 304–305

listing relations between, 309

maintaining, 46–53

navigating records in, 41–43

opening, 39–41

packing, 51–52

permissions level for, 134–135, 322

re-indexing, 52–53

restoring deleted records, 51

saving, 37–38

sorting records in, 65, 75–78, 283–284

supported types of, 31

system, 302–310

updating records, 297–298

views as temporary, 160–161

working with, 38–43

__error, 174, 200

__input, 173–174

__new, 200

__old, 200

__output, 173–174

tags. See indexes; index orders

TAN() scalar function, 248

TDataSet descendant. See Advantage TDataSet Descendant

templates

for Advantage Extended Procedures, 174, 176–177, 180–181

for triggers, 205, 211–212, 217

text searches. See full text search (FTS)

THEN reserved keyword, 239, 279

time and timestamp operators, 246

TIME data type, 36

time literals, 242

TIMESTAMP data type, 36

timestamp literals, 242–243

TIMESTAMPADD() scalar function, 247

TIMESTAMPDIFF() scalar function, 247

TO reserved keyword, 239

TOP keyword, 254, 286

training, 456

transaction log path, 15

TRANSACTION reserved keyword, 239, 299–300

transactions

defined, 9

triggers and, 203–204

using, 299–300

trial 5-user version expiration date, determining, 13

trigger containers, 199

triggers

adding to data dictionaries, 226–229

Advantage Extended Procedures compared to, 198

AFTER, 202

BEFORE, 200–201

BLOB data and, 200, 228–229

constraints versus, 126–126, 204

debugging, 230

deleting, 229, 275

deploying, 230

description of examples, 205–207

developing in Delphi, 211–216

developing in SQL, 207–211

developing in Visual Basic .NET, 223–226

developing in Visual C#, 217–221

INSTEAD OF, 201–202

listing, 306–307

memo data and, 200, 228–229

overview, 25, 198–202

parameters of, 199

priority of, 204

SQL scripts in, 199

templates for, 205, 211–212, 217

transactions and, 203–204

types of, 200–202

types of implementations, 198–199

updating, 229

TRUE reserved keyword, 239

TRUNCATE() scalar function, 248