Specifications

Index
Users Guide 803
Lower 702
Match 702
Mid 709
MidA 710
Pos 724
PosA 725
Replace 730
ReplaceA 731
Right 733
RightA 733
RightTrim 734
Space 740
Trim 753
Upper 755
WordCap 760
strings
comparing 622
concatenating 624
converting 672, 700, 717, 728
deleting leading spaces 698
detecting contents 687, 689, 691
extracting 709, 710
finding substrings 724, 725
lowercase 702
uppercase 755
StripRTF function 748
style libraries 47
StyleBar
about 29
controlling display of 30
in Form painter 540, 541
in Report painter 196
styles, of reports 216
substring
extracting 709, 710
finding 724, 725
replacing 730, 731
subtraction operator 619
sum
in graphs 413
Sum function 749
sum, computing 241
summary bands, in Report painter 196
summary statistics
computing 241
in crosstabs 445
syntax
exporting to another DBMS 95
of view SELECT statement 106
system and environment functions
ProfileInt 725
ProfileString 727
system date 753
system options tab 52
system tables
DBMS 96
extended attribute 89, 95, 767
system time 716
T
tab order in forms 556
tables
accessing in freeform form 509
accessing in grid form 510
accessing in master/detail many-to-one form 513
accessing in master/detail one-to-many form 511
altering definition of 90, 91
applying display formats to columns 261
applying edit styles to columns 273
controlling updates to 531
creating 84
creating indexes 102
dropping 93
dropping indexes 101, 102
exporting syntax to another DBMS 95
extended attributes, specifying 88
fonts 87
joining in Select painter 170
joins, number of tables in 48
number in joins 48
opening, related to foreign keys 98
opening, related to primary keys 98
presenting in Freeform style 146
presenting in Grid style 146
presenting in Label style 147
presenting in N-Up style 148
presenting in Tabular style 145
printing data 114
removing from Database painter view 92
rich text 472