]>
Commit | Line | Data |
---|---|---|
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 ********************************* |