Index_R

R

RADIANS() scalar function, 248

RAND() scalar function, 248, 310

ranges

See also scopes

indexes and, 78–79

setting in Delphi example, 341–342

RAW data type, 36

reading ADS data

See also SQL; querying

from C#Builder, 406–409

from Delphi, 335–335

from Java, 361–363

from JBuilder, 361–363

from PHP, 434–435

from Visual Basic, 383–385

from Visual C#, 406–409

in SQL, 237–257

via ADO, 383–385

via ADO.NET, 406–409

re-indexing tables, 52–53

record cache setting, 253

record number, 64

record-level constraints

comments about, 145–147

defined, 124

defining, 135–136

records

See also tables

defined, 30

referential integrity

comments about, 145, 147

creating, 137–145, 319–320

defined, 92, 124

delete rules, 141–142

entity relationship diagram, 142–145

removing, 320

update rules, 141–142

registering .NET class libraries, 185–186, 222–223

regular user, defined, 108

remote connection, 41

REPEAT() scalar function, 248

REPLACE() scalar function, 248

required fields, 129

reserved SQL keywords, 239

restructuring fields in tables, 48–50, 323

retrieving data. See reading ADS data; querying; SQL

REVOKE statement, 239, 313–314

RIGHT() scalar function, 248

rights to tables. See granting access rights to tables; permissions

ROLLBACK reserved keyword, 239

ROLLBACK WORK statement, 299–300

ROUND() scalar function, 248

ROWID field, 279

rows

See also tables

defined, 30

RTRIM() scalar function, 248, 277, 298