Filter
Top Products
Contents
DataWindow Designer User’s Guide v
Closing a table......................................................................... 70
Dropping a table...................................................................... 70
Viewing pending SQL changes ............................................... 71
Printing the table definition...................................................... 72
Exporting table syntax............................................................. 72
About system tables................................................................ 73
Creating and editing Sybase Adaptive Server temporary
tables................................................................................ 74
Working with keys .......................................................................... 75
Working with indexes ..................................................................... 79
Working with database views......................................................... 81
Manipulating data........................................................................... 86
Retrieving data ........................................................................ 86
Modifying data......................................................................... 87
Sorting rows ............................................................................ 88
Filtering rows ........................................................................... 89
Viewing row information .......................................................... 90
Importing data ......................................................................... 90
Printing data ............................................................................ 91
Saving data ............................................................................. 91
Creating and executing SQL statements ....................................... 92
Building and executing SQL statements ................................. 92
Customizing the editor............................................................. 95
Controlling access to the current database.................................... 96
PART 2 DATAWINDOWS
CHAPTER 4 Defining DataWindow Objects..................................................... 99
About DataWindow objects............................................................ 99
DataWindow object examples............................................... 100
Choosing a presentation style...................................................... 101
Using the Tabular style.......................................................... 102
Using the Freeform style ....................................................... 102
Using the Grid style............................................................... 103
Using the Label style............................................................. 103
Using the N-Up style ............................................................. 105
Using the Group style............................................................ 106
Using the Composite style..................................................... 107
Using the Graph and Crosstab styles.................................... 108
Using the TreeView style....................................................... 108
Building a DataWindow object ..................................................... 109
Selecting a data source................................................................ 110