Specifications

Index
802
InfoMaker
sliding
in forms 551
in reports 251
Slide dropdown toolbar, in Report painter 196
used in nested reports 361
Small function 738
snaking columns, in reports 223
sort criteria, specifying in Quick Select 159
sorting
groups 312
in graphs 423
in SQL Select 177
rows 299
sorting Name column in Library painter 59
sources of data 155
Space function 740
space, in libraries 67
spaces
deleting leading 698
deleting trailing 734
inserting in a string 740
removing from strings 753
spacing
equalizing in forms 550
equalizing in reports 250
of columns in graphs 426
Specify Retrieval Criteria dialog box, when running
forms 558
Specify Sort Columns dialog box 300
Specify Update Properties dialog box 532
spin controls
defining edit masks as 280
SQL Anywhere
data source 602
SQL Anywhere databases, creating and deleting 83
SQL Select
adding tables 167
defining retrieval arguments 173
joining tables with 170
selecting columns 168
selecting tables 166
specifying selection, sorting, and grouping
criteria 175
specifying what is displayed 167
using as data source 165
SQL Select data source
modifying SELECT statement graphically 560
SQL Select data source, colors in 167
SQL statements
building and executing 115
displaying 169
executing 115, 118
execution plan 118
explaining 118
exporting to another DBMS 95
for views, displaying 106
generating through Quick Select 156
generating through SQL Select 165
importing from text files 118
logging 82
painting 115
typing 117
SQLCache variable 357
Sqrt function 741
square root 741
stacked graphs 408
standalone document declaration 375
standard deviation 742, 744
starting InfoMaker from command line 53, 593
StDev function 742
StDevP function 744
Stored Procedure data source 182
stored procedures
modifying result sets in reports 230
using 182
string
concatenating 564
display formats for 267
String function 746
string functions
Asc 642
AscA 642
Char 650
CharA 650
Fill 679
FillA 680
Left 696
LeftA 697
LeftTrim 698
Len 698
LenA 699