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 // Clookup class
  29 class Clookup : public wxDbTable
  30 {
  31     public:
  32
  33         wxChar lookupCol[LOOKUP_COL_LEN+1];
  34
  35         Clookup(wxChar *tblName, wxChar *colName, wxDb *pDb, const wxString &defDir="");
  36
  37 };  // Clookup
  38
  39
  40 // Clookup2 class
  41 class Clookup2 : public wxDbTable
  42 {
  43     public:
  44
  45         wxChar lookupCol1[LOOKUP_COL_LEN+1];
  46         wxChar lookupCol2[LOOKUP_COL_LEN+1];
  47
  48         Clookup2(wxChar *tblName, wxChar *colName1, wxChar *colName2, wxDb *pDb, const wxString &defDir="");
  49
  50 };  // Clookup2
  51
  52
  53 // ClookUpDlg class
  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                     wxChar  *windowTitle,
  73                     wxChar  *tableName,
  74                     wxChar  *colName,
  75                     wxChar  *where,
  76                     wxChar  *orderBy,
  77                     wxDb    *pDb,
  78                     const wxString &defDir);
  79
  80         //
  81         // This is a generic lookup constructor that will work with any table and any column.
  82         // It extends the capabilites of the lookup dialog in the following ways:
  83         //
  84         //    1) 2 columns rather than one
  85         //    2) The ability to select DISTINCT column values
  86         //
  87         // Only set distinctValues equal to true if necessary.  In many cases, the constraints
  88         // of the index(es) will enforce this uniqueness.  Selecting DISTINCT does require
  89         // overhead by the database to ensure that all values returned are distinct.  Therefore,
  90         // use this ONLY when you need it.
  91         //
  92         // For complicated queries, you can pass in the sql select statement.  This would be
  93         // necessary if joins are involved since by default both columns must come from the
  94         // same table.
  95         //
  96         // If you do query by sql statement, you must pass in the maximum length of column1,
  97         // since it cannot be derived when you query using your own sql statement.
  98         //
  99         // The optional database connection can be used if you'd like the lookup class
 100         // to use a database pointer other than the READONLY_DB of the app.  This is necessary
 101         // if records are being saved, but not committed to the db, yet should be included
 102         // in the lookup window.
 103         //
 104         ClookUpDlg(wxWindow *parent,
 105                     wxChar  *windowTitle,
 106                     wxChar  *tableName,
 107                     wxChar  *dispCol1,                  // Must have at least 1 display column
 108                     wxChar  *dispCol2,                  // Optional
 109                     wxChar  *where,
 110                     wxChar  *orderBy,
 111                     wxDb    *pDb,                       // Database connection pointer
 112                     const wxString &defDir,
 113                     bool     distinctValues,            // e.g. SELECT DISTINCT ...
 114                     wxChar  *selectStmt = 0,            // If you wish to query by SQLstmt (complicated lookups)
 115                     int      maxLenCol1 = 0,            // Mandatory if querying by SQLstmt
 116                     bool     allowOk    = TRUE);        // is the OK button enabled
 117
 118         void        OnButton( wxCommandEvent &event );
 119         void        OnCommand(wxWindow& win, wxCommandEvent& event);
 120         void        OnClose(wxCloseEvent& event);
 121         void        OnActivate(bool) {};  // necessary for hot keys
 122
 123 DECLARE_EVENT_TABLE()
 124 };  // class ClookUpDlg
 125
 126 #define LOOKUP_DIALOG                   500
 127
 128 #define LOOKUP_DIALOG_SELECT            501
 129 #define LOOKUP_DIALOG_OK                502
 130 #define LOOKUP_DIALOG_CANCEL            503
 131
 132 #endif  // LISTDB_DOT_H
 133
 134 // ************************************ listdb.h *********************************