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