Index_A

A

ABS() scalar function, 248

access rights. See granting access rights to tables; permissions

accessing ADS data. See connecting to ADS data; reading ADS data

ACE API. See Advantage Client Engine (ACE) API

ACOS() scalar function, 248

ActiveX data objects. See ADO

ADD file, 96

ADD reserved keyword, 239, 275

ADM file, 32

administrative user (ADSSYS), 98–99, 300, 302–303, 315

ADO

See also ADO.NET

changing user passwords, 394–395

client-side cursors, 373

connecting to ADS data with, 376–380

connecting using data link (UDL) files, 377–378

connection parameters for, 376–377

creating tables, 392–393

defined, 372–373

drivers for ADS, 24

executing parameterized queries, 381–383

executing queries, 380–381

executing stored procedures, 385–386

granting access rights to tables, 392–393

opening tables directly, 386–387

overview, 6, 372–373

reading and writing data, 383–385

scanning result sets, 390–391

seeking records, 388–389

server-side cursors, 373

setting filters, 389–390

setting indexes, 387–388

using with ADS, 372–373

ADO.NET

See also ADO; Advantage .NET Data Provider; C# Builder; Visual Basic .NET; Visual C#

changing user passwords, 414–417

connecting to ADS data with, 401–403

connection parameters for, 401–424

creating tables, 412–414

drivers for ADS, 24

executing parameterized queries, 405–406

executing queries, 403–405

executing stored procedures, 409–410

granting access rights to tables, 412–414

overview, 26, 398–399

reading and writing data, 406–409

scanning result sets, 410–411

ADS help, 11, 448–449

AdsAddCustomKey, 70

AdsDeleteCustomKey, 70

ADSSYS administrative user, 98–99, 300, 302–303, 315

ads_err.dbf, 448

ADT file, 32, 38

ADT table format, 31–33

See also tables

Advantage ANSI Collation Utility, 18–20

Advantage Client Engine (ACE) API

supported development environments, 24

using with Delphi, 330

Advantage Clipper RDDs, 24

Advantage Configuration Utility, 11–17

Advantage Data Architect

message display option in, 98–99

overview, 17–18

Advantage data dictionaries. See data dictionaries

Advantage Database Manager, 98–100

Advantage Database Server

Advantage Local Server versus, 7–11

configuring, 11–17

connection limits, setting, 14

connection statistics, 12

defined, 4

driver types, 24

features added in version 7, 25–27

indexes. See indexes

installation information, 13–14

installing, 442–443

ISAM server, as, 5

maintenance of, 6–7

network traffic and, 8, 169

number of users, 12

overview, 2–10

proprietary table format, 31–33

performance and, 8–9

performance of, 4–6

remote database server, as, 7

running without a network connection, 444–447

server types, 21

SQL server, as, 5

stability of, 9–10

system stored procedures for, 314–326

system tables for information about, 302–310

tables. See tables

transactions and, 9

versions of, 21

work area statistics, 12

Advantage DBI Driver (for Perl)

overview, 437–438

supported development environments, 24

Advantage Extended Procedures (AEPs)

access rights to, 116–117, 189, 192, 312–314

adding to data dictionaries, 189–193

AEP containers, 168

benefits of using, 168–173

debugging, 193–194

defined, 168

deleting, 275

deploying, 195

developing in Visual C#, 180–185

developing in Delphi, 176–180

developing in Visual Basic .NET, 186–188

developing in Visual Basic, 188–189

executing from C#Builder, 409–410

executing from Delphi, 337–339

executing from Java, 363–364

executing from JBuilder, 363–364

executing from PHP, 435–437

executing from Visual Basic, 385–386

executing from Visual C#, 409–410

executing in SQL, 316

executing via ADO, 385–386

executing via ADO.NET, 409–410

functions in, 171–174

GetInterfaceVersion function, 172–173

implementing, 174–176

limits using ALS, 170

listing, 309

querying, 193

registering .NET class libraries, 185–186

Shutdown function, 172

Startup function, 171–172

structure of, 170–174

templates for, 174, 176–177, 180–181

testing, 193

triggers compared to, 198

types of libraries for creating, 168, 171

version 1 and version 2 AEPs, 171

Advantage help, 11, 448–449

Advantage JDBC Driver

DataExpress and, 370

overview, 26

supported development environments, 24

using with Java, 352–353

Advantage Local Server

Advantage Database Server versus, 7–10

described, 7–11

installing, 443–444

licensing/pricing, 7

network traffic and, 8

performance and, 8–9

SQL, using with, 235

stability of, 9–10

transactions and, 9

when to use, 10–11

Advantage Management Utility, 12

Advantage .NET Data Provider

See also Visual C#

changing user passwords, 414–417

connecting to ADS data with, 401–403

connection parameters for, 401–424

creating Advantage Extended Procedures, 180–185

creating tables, 412–414

executing parameterized queries, 405–406

executing queries, 403–405

executing stored procedures, 409–410

granting access rights to tables, 412–414

overview, 24, 26, 398–399

reading and writing data, 406–409

scanning result sets, 410–411

supported development environments, 23–24

using with Delphi for .NET, 330

using with Visual C#, 398–417

Advantage ODBC Driver

connecting to ADS data with, 421–426

connecting using a connection string, 424–426

connecting using a data source name (DSN), 422–424

connection parameters for, 425–426

creating data source name (DSN) for, 422–424

overview, 23–24, 420–421

supported development environments, 24

types of, 23

using with Delphi, 330

using with Java, 352

Advantage OLE DB Provider

MDAC and, 372–373

supported development environments, 23–24

using with Delphi, 330

Advantage Optimized Filters (AOFs)

fully optimized, 79–80, 253

indexes and, 78–80

live cursors and, 253–254

nonoptimized, 79–80, 253

partially optimized, 79–80, 253

setting from Delphi, 342–343

setting from Visual Basic, 389–390

Advantage PHP Extension

connecting to ADS data with, 430–431

driver for ADS, 23–24, 426–427

executing parameterized queries, 431–432

executing queries, 433–434

executing stored procedures, 435–437

overview, 426–428

reading and writing data, 434–435

scanning result sets, 435

supported development environments, 24

Advantage Query Builder, 258–262

See also querying

Advantage Replication server, 5

Advantage SQL utilities, 257–267

See also SQL

Advantage SQL. See SQL

Advantage TDataSet Descendant

See also Delphi

supported development environments, 24

TAdsConnection, 331–333

TAdsDictionary, 331

TAdsQuery, 331

TAdsSettings, 331

TAdsStoredProc, 331

TAdsTable, 331

using with Delphi, 330

Advantage tools, 11–20

Advantage Visual Objects RDDs, 24

AEP containers, 168

AEPs. See Advantage Extended Procedures (AEPs)

AFTER triggers, 202

AI file, 32, 96

aliases, 96, 99, 101, 333

ALL reserved keyword, 239

ALTER reserved keyword, 239, 275

ALTER statement, 239, 274–275

AM file, 96

AND reserved keyword, 239, 244

ANSI character set

creating new, 19–20

determining, 13

ANY reserved keyword, 239

AOFs. See Advantage Optimized Filters (AOFs)

ARC. See Advantage Data Architect

AS reserved keyword, 239

ASC reserved keyword, 239

ASCII() scalar function, 248

ASIN() scalar function, 248

ATAN() scalar function, 248

ATAN2() scalar function, 248

auto-create tables and indexes, 133, 322

AUTOINC data type, 36

auto-increment fields, 35

auto-open indexes, 30, 64

autocommit settings, 300

AVG reserved keyword, 239, 286