Table of Content

only for RuBoard - do not distribute or recompile

MySQL Building User Interfaces

About the Author

About the Technical Reviewers

Acknowledgments

Tell Us What You Think

Introduction
     Who Should Read This Book
     Organization of This Book
     Conventions Used in This Book

I: Quick and Dirty

1. MySQL for Access and SQL Server Developers and DBAs
     Why You Should Use MySQL
     Licensing Issues
     Datatypes: MySQL Compared to Access 2000 and SQL Server 7
     What MySQL Lacks
     MySQL, MYSQL, and mysql ”They re Not the Same Thing
     For Access Converts Only: Daemons and Services
     Where to Get MySQL
     Deciding On an Installation Method: Pros and Cons
     What to Get for RPM Installation
     Installation
     The Whirlwind Tour: Creating, Accessing, and Dropping a Database
     Nonstandard or Unique SQL Constructs in MySQL (Extensions to ANSI SQL92)
     Utilities and Programs for MySQL
     MySQL s C API

2. GTK+ for VB Developers
     Why You Should Use GTK+
     Where to Get GTK+ and How to Install It
     Licensing Issues
     GTK+ Overview
     GTK+ Containers as Resizer Controls
     The Basic Widget Tour ”As a Program

3. More GTK+ Widgets
     The GtkCombo Widget
     The GtkProgressBar and GtkStatusBar Widgets
     GtkFrame and GtkAspectFrame
     GtkDialog, GtkFileSelection, GtkColorSelectionDialog, and GtkFontSelectionDialog
     Menu Widget, ItemFactory, and Popup Menu Widgets

4. Advanced GTK+ Layout Widgets
     GtkTable
     GtkTree and GtkCTree
     GtkFixed
     GtkLayout
     GtkScrolledWindow
     GtkNotebook
     GtkPaned

5. Glade for VB Developers
     About Glade
     Diving Right In: HelloWorld Done with Glade
     HelloWorld Files Dissected
     Glade by the Widgets
     Project Design: Knowing Your Object Hierarchy
     Window-to-Window Communication in a Glade Project
     Global Variables and Good Software Engineering

II: Real World Implementations

6. Order Entry Abstract and Design
     Problem Definition and Design Issues
     User Interface
     Creating the Database
     Deploying the Application
     Upgrading the Application

7. Construction of the SESI Order Entry Application
     User Interface Construction with Glade
     Utility Functions of the Application
     Connecting the Interface to the Utility Functions
     Compiling the Program
     Project Post-Mortem

8. Commission Calculations Abstract and Design
     Problem Definition
     User Interface
     Database and Login Setup
     Creating the Database

9. Constructing the Commissions Application
     User Interface (UI) Construction with Glade
     The Data Display Control (DDC)
     Utility Functions of the Application
     The Glue : callbacks.c
     Project Post-Mortem

10. Commission Calculations Deployment
     Compiling from the Command Line
     The Benefits of Using Make
     Deploying the Application
     Compiling for Win32 Using MS VC++

11. Management Reporting Abstract and Design
     Problem Definition
     User Interface
     Database and Login Setup
     Creating the Database

12. Management Reporting Construction
     Problem Definition
     The Controlling Application: KBI
     Report 1: Tabular
     Report 2: Pie Chart
     Report 3: Bar/Line Chart
     Report 4: Scatter Plot

13. Compiling the Key Business Indicators Application
     Compiling and Distributing Via an RPM
     Compiling with MinGW for Win32

III: Example

14. Dynamic User Interface Control with XML
     HelloWorld! One More Time
     Cross-Window Communication
     Changing the Application Without Recompiling

IV: Appendixes

A. Glade-Generated Files from the SESI Order Application
     interface.c
     sesi.glade

B. Glade-Generated Files from the Worldwide Commissions Application
     interface.c
     sesi.glade

C. Glade-Generated Files from the Key Business Indicators Application
     KBI Files
     Tabular Files
     Pie Chart Files
     bar_line Files
     Scatter Plot Files

only for RuBoard - do not distribute or recompile