Index_P

P

PAGESIZE keyword, 274

Paradox, using with ADS, 23

parameterized queries

See also querying; SQL

described, 248–249

reducing security problems using, 251–252

using from C#Builder, 405–406

using from Delphi, 337

using from Java, 360–361

using from JBuilder, 360–361

using from PHP, 431–432

using from Visual Basic, 381–383

using from Visual C#, 405–406

using in SQL, 248–249

via ADO, 381–383

via ADO.NET, 405–406

parent table, 136, 309

parent-child relationship, 136–145

passwords

See also security

changing user, from C#Builder, 414–417

changing user, from Delphi, 348–350

changing user, from Java, 368–369

changing user, from JBuilder, 368–369

changing user, from Visual C#, 414–417

changing user, from Visual Basic, 394–395

changing user, via ADO, 394–395

changing user, via ADO.NET, 414–417

described, 43–46

removing from free tables, 46

setting for data dictionaries, 98

setting for free tables, 44–46

PERCENT keyword, 286

Perl

driver for ADS, 24, 437

using with ADS, 23, 437–438

permissions

See also granting access rights to tables

Advantage Extended Procedures, 192–193

field-level rights, 117–118, 312–314

granting, 112–118, 310–313

listing, 307–309

objects in data dictionaries, 116–118

permissions level, 134–135, 322

revoking, 313–314

views, 155–157

PHP

See also 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

PI() scalar function, 248

POSITION() scalar function, 248

positional parameters in parameterized queries, 249

posting records, 42

primary index, 134, 272, 309, 322

PRIMARY reserved keyword, 239, 272

PROCEDURE reserved keyword, 239

procedures. See Advantage Extended Procedures (AEPs)

PROTECTNUMBERS keyword, 274