Advantage Database Server: The Official Guide
|
I
IDX indexes, 31
IFNULL() scalar function, 249
IIF() scalar function, 249
IMAGE data type, 36
importing data, 17, 53–58
IN reserved keyword, 239, 245–246, 282–283
index key expression
building, 67
defined, 65
INDEX reserved keyword, 239, 273–274
Indexes
adding nonstructural indexes to tables, 318
Advantage Optimized Filters and, 78–80
auto-create, 133, 322
auto-open, 64
changing, 74, 274
compound, 64
condition expression, 69
conditional, 69–70
corrupt, 64
creating, 71–74, 273–274
custom, 70
default, 134, 322
deleting, 74, 275
expression, 67–69
filters and, 78–80
foreign key, 136–137
FTS (full text search), 25, 70–71, 80–89, 274, 293–295
imported tables and, 56
index key, 65
index orders, defined, 64–65
listing index files, 306
listing index orders, 305–306
multi-order, 64
performance and, 66, 78
primary, 134, 137, 322
re-indexing tables, 52–53
scopes and, 78–79
seeks and, 78–79
setting in Delphi example, 340
setting in Visual Basic example, 387–388
sorting with, 65
specifications, 64
SQL performance and, 68
structural, 30, 64
subindexes, 71
testing, 74–78
types of, 66–71
unique, 68, 272–273
uses for, 65–66
INNER reserved keyword, 239, 291
INSERT INTO statement, 256–257, 294–295, 300
INSERT reserved keyword, 239
INSERT() scalar function, 248
installing
Advantage data access clients, 442–444
Advantage Database Server, 442–443
Advantage Local Server, 443–444
code samples, 452–454
Microsoft loopback adapter, 446–447
sample database, 452–454
INSTEAD OF triggers, 201–202
INTEGER data type, 36
internationalization of applications, 19–20
Internet
accessing data dictionaries via, 97, 110
accessing databases via, 97, 110
creating Web application example, 426–438
creating Web server extensions, 23
network traffic, reducing, 8, 169
using ADS for access, 7
Internet port, setting, 16
INTO reserved keyword, 239, 273, 296
IP port
setting, 15–16
IS reserved keyword, 239, 244–246
ISAM
advantages of, 5–6
described, 4–6
ISNULL() scalar function, 249
|