The Definitive DataWindow: Your Key to PowerBuilder Success Book

	Preface	xvii
	Acknowledgments	xxi
	Introduction	xxv
Chapter 1	DataWindow to Database: Structured Query Language	1
	Characteristics of SQL	2
	Advantages of SQL	3
	Types of SQL	4
	Data Control Language	4
	Data Definition Language	5
	Tables	5
	Data Manipulation Language	7
	Nulls	11
	Advanced SQL Topics	12
	Views	39
	SQL Tips, Tricks, and Tools	43
	Summary	46
Chapter 2	Understanding Open Database Connectivity	47
	Flat File Databases	47
	Indexed Sequential Access Method Databases	49
	Interprocess Communications	52
	Relational Databases	53
	The Acceptance of Structured Programming Language	54
	Summary	57
Chapter 3	Data Modeling and Database Design	59
	The Architecture of Database Systems	59
	Database Design	63
	A Practical Approach to Database Design	82
	Summary	86
Chapter 4	Behind the DataWindow: Highlights of Database Design	89
	Primary Keys	90
	Foreign Keys	92
	Normalization	94
	One-to-One Relationships	102
	One-to-Many Relationships	103
	Many-to-Many Relationships	104
	A Real-World Example	106
	Summary	108
Chapter 5	Working with the Database Painter	111
	Primary Keys	111
	The Catalog Tables	112
	Maintaining the Catalog Tables	115
	The Edit Style Dialogs	121
	Maintaining Code Tables	124
	Display Format Maintenance	125
	Maintaining Data Validations	126
	A Version 7 Enhancement	129
	Summary	131
Chapter 6	The Very Basics	133
	The DataWindow Control and the DataWindow Object	134
	The Primary DataWindow Buffer	134
	Proactive and Reactive Programming	136
	DataWindow Buffers	139
	Summary	142
Chapter 7	The Simplest DataWindows	143
	The Toolbar	144
	Summary	192
Chapter 8	The DataWindow Painter	193
	The Bands	193
	Expanding and Contracting Bands	195
	The DataWindow Workspace	196
	Menu Items	229
	Summary	261
Chapter 9	DataWindow Objects and Their Properties	263
	A Brief Overview of DataWindow Objects	263
	DataWindow Object Properties	268
	Summary	407
Chapter 10	DataWindow Controls	409
	The Basic Idea	409
	Standard Events	425
	Beyond the Standard Events	448
	Some Commonly Used or Just Interesting Functions	451
	Summary	458
Chapter 11	Graphing	459
	A First Example--A Line Graph	460
	A Second Example--A Line Graph with a Series	468
	A Third Example--Selectable Series	471
	A Fourth Example--Final Polishing of the Line Graph	475
	A Final Example--A Pie Chart	476
	Moving Beyond the Pie	479
	Summary	484
Chapter 12	Using Edit and Display Formats	485
	Sections	485
	Colors	485
	Numbers	486
	Strings	488
	Dates	489
	Times	490
	Combinations	491
	Summary	491
Chapter 13	An Ancestor DataWindow Control	493
	Some Basics First	494
	A Start--Create Your DataWindow Object	498
	A Solution to an Unusual Problem	513
	Where to Go from Here	517
	Summary	517
Chapter 14	Tips and Techniques	519
	DataWindow Controls--Coding Your DataWindow	519
	The DataWindow Object	572
	Object-Oriented Techniques	616
	Miscellaneous	651
	Summary	676
Chapter 15	The Web DataWindow	677
	The Basic Idea	677
	The Web DataWindow	684
	Moving to the Future	689
Chapter 16	Differences Between PowerBuilder 6 and 7	691
	The Basic Idea	691
	Menus	692
	Panels	694
	Database Painter	696
	Tab Pages	701
	The DataWindow Painter	702
Chapter 17	DataWindow Basics for PowerJ and PowerSite Programmers	705
	Libraries	705
	The Painter Concept	707
	The Library Painter	707
Chapter 18	The Future	711
	Glossary	713
	Index	735