Chapter 8
DQL Lexicon
DQL Lexicon: Introduction
DQL Lexicon Typographical Conventions
Symbols
+ (addition)
- (subtraction)
/ (division)
*(multiplication)
*(asterisk)
? (question mark)
~ (tilde)
: (colon)
() (parentheses)
. (period)
;_semicolon
" " (quotation marks)
:= (assignment operator)
< (less than)
<= (less than or equal to)
= (equals)
> (greater than)
>= (greater than or equal to)
-- (comment)
abs (absolute value)
acos (arccosine)
ad hoc relationship
all
ampm
and
any
application status
asin (arcsine)
assign
atan (arctangent)
atan2 (arctangent 2)
backup db (backup database)
begin transaction
between
blank
call menu
call program
case
ceil
comment
commit
Comparison Operators
Conditional Statistical Operators
Constant Value
Concat
Control Procedure
copy all from
cos (cosine)
cosh (hyperbolic cosine)
count
count of
count of (example)
current
data-entry
date
day
db status (database status)
define
delete records
do
else
end
enter a record
error messages off
error messages on
exec SQL
exit
exp
export
firstc
firstlast
firstw
floor
for
Functions
futurevalue
global
Grouping
highest of
hours
if Command
if Function
import
in
in groups
in order
in reverse
input using
Using the input using Command with Multiforms
install application
installment
item (Statistical Operator)
item (Conditional Statistical Operator)
jointext
julian
lastc
lastfirst
lastw
length
list records
lock
lock db (lock database)
log
log10
lower
lowest of
max
mean
mean of
message
midc
midw
min
minutes
mod (modulus)
modify records
month
named
Nested Actions
not
Operators
or
others
output
percent
periods
power
presentvalue
Primary Table
Procedural Commands
Processing Procedure
proper
query selection
random
rate
record entry
Relational Statistical Operators
Relationships
reorganize
restore db (restore database)
rollback
run procedure
Secondary Table
seconds
Selection Criteria
sin
sinh
Sorting
spellcurrency
spelldate
spellmonth
spellnumber
spellweekday
sqrt (square root)
Statistical Operators
std.dev. (standard deviation)
std.err. (standard error)
sum
sum of
tan (tangent)
tanh (hyperbolic tangent)
temp
textpos
timeampm
tran off
tran on
Transaction Processing
unlock
unlock db (unlock database)
upper
value
variable
variance
weekday
while
with
year
yearday
yearweek