Specifications

Index
Users Guide 785
specifying fonts in tables 87
using in graphs 413
database administration
database access 119
executing SQL 115
painting SQL 115
security 119
Database Blob Object dialog box 499
Database painter
changing colors in 81
creating tables 84
defining display formats 261
defining validation rules 289
dragging and dropping 79
previewing data 108
specifying extended attributes 88
tasks 79
views 78
working with edit styles 272
workspace 78
Database painter, validation rules 617
database profiles in pipelines 125
database views
extended attributes of 89
working with 103
databases
accessing through Quick Select 156
accessing through SQL Select 165
connecting to 153
controlling access to 119
controlling updates to 531
creating and deleting (SQL Anywhere) 83
creating tables 84
destination in pipelines 122
ensuring referential integrity 97
executing SQL statements 118
importing data 113, 203, 525
limiting retrieved data 297
logging work 82
piping data 121
retrieving, presenting, and manipulating data 108
source in pipelines 122
specifying fonts 87
stored procedures 182
system tables 96
updating 109, 202
using as data source in a report 155
using as data source in DataWindow object 155
datatypes
in display formats 263
in graphs 427
of blob columns 498
when piping data 122
DataWindow objects
escapement 253
modifying 187
rotating controls in 253
DataWindow objects versus reports 144
Date function 672
date, day, and time functions
Day 674
DayName 674
DayNumber 675
DaysAfter 676
Hour 684
Minute 713
Month 716
Now 716
RelativeDate 729
RelativeTime 729
Second 736
SecondsAfter 737
Today 753
Year 761
dates
checking string 687
converting to 672
DateTime data type 673
day of week 674, 675
determining interval 676
display formats for 267
displaying in Library painter 60
obtaining current 753
obtaining day of month 674
DateTime function 673
Day function 674
DayName function 674
DayNumber function 675
DaysAfter function 676
DBMS
controlling database access 119
CREATE VIEW statement 105