Contents

 
• List of Figures
• List of Tables
• 1 Introduction
  • 1.1 Why Qddb?
  • 1.2 Minimum requirements
  • 1.3 What you need to know
  • 1.4 What's in this guide
  • 1.5 Typefaces and icons used in this book
  • 1.6 How to contact HSDI
    • 1.6.1 Visit our Web Page
    • 1.6.2 Write a letter
• 2 Developing an nxqddb addressbook
  • 2.1 Creating a simple addressbook
  • 2.2 Improving the simple addressbook
  • 2.3 Adding some final touches to our addressbook
    • 2.3.1 Making the first and last name fields mandatory
    • 2.3.2 Sex radiobuttons: Male, Female, Do not know
    • 2.3.3 Aligning radiobutton labels
    • 2.3.4 Changing Comments field to text area with height of 4 lines
    • 2.3.5 Resizing your nxqddb display window
    • 2.3.6 Saving your changes
  • 2.4 Redesigning the interface using QddbScript
  • 2.5 Learn by doing
• 3 Using nxqddb
  • 3.1 Adding an entry
    • 3.1.1 Editor keys
    • 3.1.2 Navigating within Add Mode
    • 3.1.3 Saving your entry
    • 3.1.4 Exiting Add Mode
  • 3.2 Searching for an entry
    • 3.2.1 Types of search results
  • 3.3 Modifying an entry
  • 3.4 Deleting an entry
  • 3.5 Accelerator Keys
• 4 Searching
  • 4.1 Introduction to Searching
    • 4.1.1 Steps to searching
    • 4.1.2 An example of a common search
    • 4.1.3 nxqddb searching is case insensitive
    • 4.1.4 Meaningless search fields
    • 4.1.5 Clearing search fields
    • 4.1.6 Sample searches
  • 4.2 More Advanced searches
    • 4.2.1 The Generic Search for field
    • 4.2.2 Searching on Multiple fields
      • Steps to searching multiple fields
      • Example of searching multiple fields
    • 4.2.3 Searches with more than one value(Comma Delimiter)
    • 4.2.4 Specifying search values in a Date Field
    • 4.2.5 Specifying Ranges for Numeric and Date Field
      • Range search on a numeric field
      • Range search on a date field
      • @firstofmonth(today) and @lastofmonth(today)
    • 4.2.6 Exclusion using exclamation point(!) delimiter
    • 4.2.7 Regular expression searches
    • 4.2.8 Grouping search values using curly braces ({})
  • 4.3 Search Templates
    • 4.3.1 Steps to storing a search template
    • 4.3.2 Steps to retrieving a search template
    • 4.3.3 Insert Last Template
    • 4.3.4 Deleting a search template
  • 4.4 Customizing a view and/or a search results dialog box
    • 4.4.1 Sorting
    • 4.4.2 Printing
    • 4.4.3 Adding a display field to the view dialog box
    • 4.4.4 Removing a field from the view dialog box
    • 4.4.5 Choosing the width of a column in the view dialog box
    • 4.4.6 Choosing left or right justification
    • 4.4.7 Choosing a column separator
    • 4.4.8 Reading/Writing Configuration Files
  • 4.5 Expert Searches
    • 4.5.1 Steps to performing an expert search
    • 4.5.2 A simple expert search
      • Displaying the expert search window
      • Choosing your search field(or attribute)
      • Choosing the Search Type
      • Entering the search values
      • Saving your expert search
      • Reading a previously stored expert search
      • Executing the Search
      • Clearing an expert search
      • Documenting your expert search with comments
    • 4.5.3 Extending the simple expert search example
      • Appending a node
      • Entering second node information
      • Viewing the Search Node information
      • Deleting a node
      • Expanding a node
      • Dismissing the Expert Search Window
    • 4.5.4 Unlimited Search Capability
    • 4.5.5 Learn the expert search by experimentation
• 5 Configuring nxqddb
  • 5.1 Configuring Individual Fields
    • 5.1.1 Setting the add mode options
    • 5.1.2 Setting the searching options
    • 5.1.3 Setting the type of widget
  • 5.2 Saving/Loading your configuration settings
  • Auto-Save Personal Configuration
  • 5.4 Search Results
  • 5.5 Report Format Defaults
    • 5.5.1 Letter Format
    • 5.5.2 Postcard Format
    • 5.5.3 Email Format
      • Email address attribute
      • E-mail program
      • E-mail subject, carbon copy, blind carbon copy options
    • 5.5.4 Setting your return address
    • 5.5.5 Setting your destination address layout
      • View Attributes and aliases
  • 5.6 Fonts
  • 5.7 Colors
  • 5.8 Setting Soft and Hard Search Limits
    • 5.8.1 Soft Limit
    • 5.8.2 Hard Limit
    • 5.8.3 Typical Settings for the Soft and Hard Limits
  • 5.9 Keyboard Traversal Options
  • 5.10 Date style option
  • Auto-Clear option
  • Auto-Save Tuples option
  • 5.13 Force Field Formatting
  • Force Read-Only Mode
  • 5.15 Entry Widths
• 6 Printing
• 7 Generating reports
  • 7.1 Reports through nxqddb search mode
  • 7.2 Using the Expert Search for more complicated searches
  • 7.3 Displaying the Reports Window
  • 7.4 Steps to creating a report
  • 7.5 Generating a report from AddressBook2 database
    • 7.5.1 Entering a Report Title
    • 7.5.2 Entering Search Criteria
    • 8.4 Entering the Results Format
    • 7.5.4 Listing options (summary of numeric columns)
    • 8.5 Printing options
    • 7.5.6 Creating the postcard message
      • Saving/Retrieving postcard messages
      • Modifying the postcard setup
    • 7.5.7 Running the report
      • Standard Print Dialog Box
      • Preview on screen
    • 7.5.8 Saving your report
  • 7.6 Postcard Reports
  • 7.7 Letter Reports
  • 7.8 Email Reports
  • 7.9 Creating new columns
    • 7.9.1 Numeric expressions
    • 7.9.2 Ranges
    • 7.9.3 Range functions
    • 7.9.4 Numeric functions
    • 7.9.5 Logical expressions
    • 7.9.6 Examples
      • Year to date invoice totals
      • Block ranges
      • Conditional statements
    • 7.9.7 Notes
• 8 Graphs
  • 8.1 Acme's schema and database for the graph scenario
  • 8.2 Steps to creating graphs
  • 8.3 Entering the search criteria
  • Entering the Results Format
  • Printing options
  • 8.6 Setting up your graph
    • 8.6.1 General graph options
    • Configuring options for the X/Y-Axis
    • 8.6.3 Configuring options for each individual graph
  • 8.7 Generating the Acme Graph
    • Graph display options: grid, cross-hairs, zooming, Invert X/Y
  • 8.8 Applying customizations to your graph
  • 8.9 Printing your graph
  • 8.10 Range Analysis
  • 8.11 Example: range analysis of web hits
    • 8.11.1 Graph of daily hits by month
    • 8.11.2 Graph of average daily hits by day of week
    • 8.11.3 Barchart of yearly summaries
    • 8.11.4 Barchart of summary by month
    • 8.11.5 Barchart of summary by day of week
    • 8.11.6 Summary
• 9 Barcharts
  • 9.1 Barchart Setup Window
    • 9.1.1 General barchart options
    • Configuring options for the X/Y-Axis
    • 9.1.3 Configuring options for each individual bar
• 10 Importing/Exporting
  • 10.1 Importing data into your Qddb database
  • 10.2 Exporting data from your Qddb database
• 11 Schemas
  • 11.1 Creating a Qddb Database
  • 11.2 The format
  • 11.3 Entering your attributes
    • 11.3.1 Valid attribute names
    • 11.3.2 Unique Attribute Names
  • 11.4 Schema options
    • Free-form comments are allowed (encouraged) in your schema files
    • 11.4.2 verbosename
    • 11.4.3 type
    • 11.4.4 format
      • integer format
      • real format
      • date format
    • 11.4.5 alias
    • 11.4.6 defaultvalues
    • 11.4.7 exclude
    • 11.4.8 separators
      • Example of specifying a separator
  • 11.5 Example Schemas
    • Schemas are free-form
    • 11.5.2 Deeply Nested Schema
    • 11.5.3 Sample Schema illustrating all the attribute options
  • 11.6 Adding new fields after data has been entered
  • 11.7 Stabilizing your databases
• A Schemas for common applications
• B Faunix: Schemas from a commercial application
• Index
• About this document ...