samples/db/listdb.h

   1 ///////////////////////////////////////////////////////////////////////////////
   2 // Name:        listdb.h
   3 // Purpose:     wxWindows database demo app
   4 // Author:      George Tasker
   5 // Modified by:
   6 // Created:     1996
   7 // RCS-ID:      $Id$
   8 // Copyright:   (c) 1996 Remstar International, Inc.
   9 // Licence:     wxWindows licence
  10 ///////////////////////////////////////////////////////////////////////////////
  11
  12 #ifdef __GNUG__
  13 #pragma interface "listdb.h"
  14 #endif
  15
  16 /*
  17     Contains dialog class for creating a data table lookup listbox
  18 */
  19
  20 #ifndef LISTDB_DOT_H
  21 #define LISTDB_DOT_H
  22
  23
  24 #include <wx/dbtable.h>
  25
  26 const int LOOKUP_COL_LEN = 250;
  27
  28 // Global database connection
  29 extern wxDb *READONLY_DB;
  30
  31 // Clookup class
  32 class Clookup : public wxDbTable
  33 {
  34     public:
  35
  36         char lookupCol[LOOKUP_COL_LEN+1];
  37
  38         Clookup(char *tblName, char *colName);
  39
  40 };  // Clookup
  41
  42 // Clookup2 class
  43 class Clookup2 : public wxDbTable
  44 {
  45     public:
  46
  47         char lookupCol1[LOOKUP_COL_LEN+1];
  48         char lookupCol2[LOOKUP_COL_LEN+1];
  49
  50         Clookup2(char *tblName, char *colName1, char *colName2, wxDb *pDb);
  51
  52 };  // Clookup2
  53
  54 class ClookUpDlg : public wxDialog
  55 {
  56     private:
  57         bool             widgetPtrsSet;
  58         int              currentCursor;
  59         Clookup         *lookup;
  60         Clookup2        *lookup2;
  61         int              noDisplayCols;
  62         int              col1Len;
  63
  64         wxListBox       *pLookUpSelectList;
  65         wxButton        *pLookUpOkBtn;
  66         wxButton        *pLookUpCancelBtn;
  67
  68     public:
  69
  70         // This is a generic lookup constructor that will work with any table and any column
  71         ClookUpDlg(wxWindow *parent,
  72                       char  *windowTitle,
  73                       char  *tableName,
  74                       char  *colName,
  75                       char  *where,
  76                       char  *orderBy);
  77
  78         //
  79         // This is a generic lookup constructor that will work with any table and any column.
  80         // It extends the capabilites of the lookup dialog in the following ways:
  81         //
  82         //    1) 2 columns rather than one
  83         // 2) The ability to select DISTINCT column values
  84         //
  85         // Only set distinctValues equal to true if necessary.  In many cases, the constraints
  86         // of the index(es) will enforce this uniqueness.  Selecting DISTINCT does require
  87         // overhead by the database to ensure that all values returned are distinct.  Therefore,
  88         // use this ONLY when you need it.
  89         //
  90         // For complicated queries, you can pass in the sql select statement.  This would be
  91         // necessary if joins are involved since by default both columns must come from the
  92         // same table.
  93         //
  94         // If you do query by sql statement, you must pass in the maximum length of column1,
  95         // since it cannot be derived when you query using your own sql statement.
  96         //
  97         // The optional database connection can be used if you'd like the lookup class
  98         // to use a database pointer other than the global READONLY_DB.  This is necessary if
  99         // records are being saved, but not committed to the db, yet should be included
 100         // in the lookup window.
 101         //
 102         ClookUpDlg(wxWindow *parent,
 103                       char  *windowTitle,
 104                       char  *tableName,
 105                       char  *dispCol1,                  // Must have at least 1 display column
 106                       char  *dispCol2,                  // Optional
 107                       char  *where,
 108                       char  *orderBy,
 109                       bool   distinctValues,            // e.g. SELECT DISTINCT ...
 110                       char  *selectStmt = 0,            // If you wish to query by SQLstmt (complicated lookups)
 111                       int    maxLenCol1 = 0,            // Mandatory if querying by SQLstmt
 112                       wxDb  *pDb        = READONLY_DB,  // Database connection pointer
 113                       bool   allowOk    = TRUE);        // is the OK button enabled
 114
 115         void        OnButton( wxCommandEvent &event );
 116         void        OnCommand(wxWindow& win, wxCommandEvent& event);
 117         void        OnClose(wxCloseEvent& event);
 118         void        OnActivate(bool) {};  // necessary for hot keys
 119
 120 DECLARE_EVENT_TABLE()
 121 };
 122
 123 #define LOOKUP_DIALOG                   500
 124
 125 #define LOOKUP_DIALOG_SELECT            501
 126 #define LOOKUP_DIALOG_OK                502
 127 #define LOOKUP_DIALOG_CANCEL            503
 128
 129 #endif  // LISTDB_DOT_H
 130
 131 // ************************************ listdb.h *********************************