Advantage Database Server: The Official Guide
|
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
|