]> git.saurik.com Git - wxWidgets.git/blobdiff - samples/db/listdb.h
Project file update
[wxWidgets.git] / samples / db / listdb.h
index 9aac86702042325f1c44ea94d9f46e2cb5156b5c..070a0982e2528ce42e3b051d4519d07acdce9c86 100644 (file)
 
 const int LOOKUP_COL_LEN = 250;
 
-// Global database connection
-extern wxDB *READONLY_DB;
-
 // Clookup class
-class Clookup : public wxTable
+class Clookup : public wxDbTable
 {
     public:
 
-        char lookupCol[LOOKUP_COL_LEN+1];
+        wxChar lookupCol[LOOKUP_COL_LEN+1];
 
-        Clookup(char *tblName, char *colName);
+        Clookup(wxChar *tblName, wxChar *colName, wxDb *pDb, const wxString &defDir="");
 
 };  // Clookup
 
+
 // Clookup2 class
-class Clookup2 : public wxTable
+class Clookup2 : public wxDbTable
 {
     public:
 
-        char lookupCol1[LOOKUP_COL_LEN+1];
-        char lookupCol2[LOOKUP_COL_LEN+1];
+        wxChar lookupCol1[LOOKUP_COL_LEN+1];
+        wxChar lookupCol2[LOOKUP_COL_LEN+1];
 
-        Clookup2(char *tblName, char *colName1, char *colName2, wxDB *pDb);
+        Clookup2(wxChar *tblName, wxChar *colName1, wxChar *colName2, wxDb *pDb, const wxString &defDir="");
 
 };  // Clookup2
 
+
+// ClookUpDlg class
 class ClookUpDlg : public wxDialog
 {
     private:
@@ -69,20 +69,22 @@ class ClookUpDlg : public wxDialog
 
         // This is a generic lookup constructor that will work with any table and any column
         ClookUpDlg(wxWindow *parent,
-                      char  *windowTitle,
-                      char  *tableName,
-                      char  *colName,
-                      char  *where,
-                      char  *orderBy);
+                    wxChar  *windowTitle,
+                    wxChar  *tableName,
+                    wxChar  *colName,
+                    wxChar  *where,
+                    wxChar  *orderBy,
+                    wxDb    *pDb,
+                    const wxString &defDir);
 
         //
         // This is a generic lookup constructor that will work with any table and any column.
         // It extends the capabilites of the lookup dialog in the following ways:
         //
         //    1) 2 columns rather than one
-        // 2) The ability to select DISTINCT column values
+        //    2) The ability to select DISTINCT column values
         //
-        // Only set distinctValues equal to true if necessary.  In many cases, the constraints
+        // Only set distinctValues equal to TRUE if necessary.  In many cases, the constraints
         // of the index(es) will enforce this uniqueness.  Selecting DISTINCT does require
         // overhead by the database to ensure that all values returned are distinct.  Therefore,
         // use this ONLY when you need it.
@@ -95,22 +97,23 @@ class ClookUpDlg : public wxDialog
         // since it cannot be derived when you query using your own sql statement.
         //
         // The optional database connection can be used if you'd like the lookup class
-        // to use a database pointer other than the global READONLY_DB.  This is necessary if
-        // records are being saved, but not committed to the db, yet should be included
+        // to use a database pointer other than the READONLY_DB of the app.  This is necessary
+        // if records are being saved, but not committed to the db, yet should be included
         // in the lookup window.
         //
         ClookUpDlg(wxWindow *parent,
-                      char  *windowTitle,
-                      char  *tableName,
-                      char  *dispCol1,                  // Must have at least 1 display column
-                      char  *dispCol2,                  // Optional
-                      char  *where,
-                      char  *orderBy,
-                      bool   distinctValues,            // e.g. SELECT DISTINCT ...
-                      char  *selectStmt = 0,            // If you wish to query by SQLstmt (complicated lookups)
-                      int    maxLenCol1 = 0,            // Mandatory if querying by SQLstmt
-                      wxDB  *pDb        = READONLY_DB,  // Database connection pointer
-                      bool   allowOk    = TRUE);        // is the OK button enabled
+                    wxChar  *windowTitle,
+                    wxChar  *tableName,
+                    wxChar  *dispCol1,                  // Must have at least 1 display column
+                    wxChar  *dispCol2,                  // Optional
+                    wxChar  *where,
+                    wxChar  *orderBy,
+                    wxDb    *pDb,                       // Database connection pointer
+                    const wxString &defDir,
+                    bool     distinctValues,            // e.g. SELECT DISTINCT ...
+                    wxChar  *selectStmt = 0,            // If you wish to query by SQLstmt (complicated lookups)
+                    int      maxLenCol1 = 0,            // Mandatory if querying by SQLstmt
+                    bool     allowOk    = TRUE);        // is the OK button enabled
 
         void        OnButton( wxCommandEvent &event );
         void        OnCommand(wxWindow& win, wxCommandEvent& event);
@@ -118,7 +121,7 @@ class ClookUpDlg : public wxDialog
         void        OnActivate(bool) {};  // necessary for hot keys
 
 DECLARE_EVENT_TABLE()
-};
+};  // class ClookUpDlg
 
 #define LOOKUP_DIALOG                   500