Index_D

D

data dictionaries

adding Advantage Extended Procedures to, 189–193

adding groups to, 112–116

adding tables to, 100–102, 105–106, 317–318

adding triggers to, 226–229

adding users to, 108–111

advantages of, 92–94

aliases, 96, 101

changing properties of, 316–317

checking user rights, 107, 111–112

comparing, 118–122

controlling user access, 106–108

creating, 94–99, 311

defined, 92

deleting, 311

encrypting, 96–97

file types, 96

Internet access to, 97

linking with queries, 280–281

linking with views, 162–165

listing objects in, 310

listing properties of, 304

opening, 100–101

overview, 92–94

password, 98

paths, default and temp, 96

removing tables from, 103

security and, 106–118

versions, 94, 97

Data Dictionary Differentiator

See also data dictionaries

overview, 25

using, 118–122

data dictionary links

See also data dictionaries

access rights to, 116–117, 165, 312–314

creating, 164–165, 320–321

deleting, 321–322

listing, 309

using in queries, 281

using with views, 165

views and, 150–151

Data locks, setting, 14

data security, 43–45, 103–106

See also security

data types

AUTOINC, 36

BINARY, 36

CHARACTER, 36

CURDOUBLE, 27, 36

DATE, 36

DOUBLE, 36

IMAGE, 36

INTEGER, 36

LOGICAL, 36

MEMO, 36

MONEY, 27, 36

RAW, 36

SHORTINTEGER, 36

TIME, 36

TIMESTAMP, 36

database applications

creating, 20–24

creating clients for, 22–24

creating database for, 20–22

database tables

See also data dictionaries; tables

defined, 33, 92–93

versus free tables, 32–33

DATABASE() scalar function, 249, 310

database example used in book, 452–454

databases

See also data dictionaries; database applications

configuring, 17–18

creating, 20

defined, 20

DataExpress and the Advantage JDBC Driver, 370

date arithmetic operators, 245

date comparison operators, 246

DATE data type, 36

date literals, 240–241

date operators, 245

DAYNAME() scalar function, 247

DAYOFMONTH() scalar function, 247

DAYOFWEEK() scalar function, 247, 310

DAYOFYEAR() scalar function, 247

DBF table format, 31

See also tables

debugging

Advantage Extended Procedures, 193–194

SQL syntax checking, 265

triggers, 230

decrypting tables, 46

default index, 134, 322

DEFAULT reserved keyword, 239, 272, 296

DEGREES() scalar function, 248

delete rules, 141–142, 309, 319

DELETE statement, 239, 256, 298

deleting

Advantage Extended Procedures, 275

aliases, 99

data dictionaries, 311

data dictionary links, 321–322

groups, 326

indexes, 74, 275

records, 41, 53, 298

referential integrity, 320

tables, 275

tables from data dictionary definition, 103

triggers, 229, 275

users, 109, 326

views, 157, 275

DELIMITERS keyword, 274

Delphi

accessing ADS tables, 335

Advantage Data Architect and, 18

advantages of using with ADS, 330–331

changing user passwords, 348–350

connecting to ADS data with, 332–334

creating Advantage Extended Procedures, 176–180

creating tables, 345–348

creating triggers, 211–216

drivers for ADS, 24

executing parameterized queries, 337

executing queries, 336

executing stored procedures, 337–339

finding records, 340–341

granting access rights to tables, 345–348

reading and writing data, 335–335

scanning result sets, 344

setting filters, 342–343

setting indexes, 340

setting ranges, 341–342

using with ADS, 23

deploying

data dictionary files, 96

triggers, 230

DESC reserved keyword, 239

detail table, 136

DIFFERENCE() scalar function, 249

disabling DHCP media sensing, 445–446

DISTINCT reserved keyword, 239, 254, 285

documentation for ADS, 11, 448–449

DOUBLE data type, 36

DROP reserved keyword, 239, 275

DROP statement, 239

DROPCHARS keyword, 274