| 1 | /////////////////////////////////////////////////////////////////////////////// |
| 2 | // Name: dbtest.h |
| 3 | // Purpose: wxWindows database demo app |
| 4 | // Author: George Tasker |
| 5 | // Modified by: |
| 6 | // Created: 1998 |
| 7 | // RCS-ID: $Id$ |
| 8 | // Copyright: (c) 1998 Remstar International, Inc. |
| 9 | // Licence: wxWindows licence |
| 10 | /////////////////////////////////////////////////////////////////////////////// |
| 11 | |
| 12 | #ifdef __GNUG__ |
| 13 | #pragma interface "dbtest.h" |
| 14 | #endif |
| 15 | |
| 16 | #include <wx/string.h> |
| 17 | #include <wx/dbtable.h> |
| 18 | |
| 19 | enum DialogModes {mView,mCreate,mEdit,mSearch}; |
| 20 | |
| 21 | // ID for the menu quit command |
| 22 | #define FILE_CREATE 100 |
| 23 | #define FILE_RECREATE_TABLE 110 |
| 24 | #define FILE_RECREATE_INDEXES 120 |
| 25 | #if wxUSE_NEW_GRID |
| 26 | #define FILE_DBGRID_TABLE 130 |
| 27 | #endif |
| 28 | #define FILE_EXIT 199 |
| 29 | #define EDIT_PARAMETERS 200 |
| 30 | #define HELP_ABOUT 300 |
| 31 | |
| 32 | // this seems to be missing, Robert Roebling (?) |
| 33 | #ifndef MAX_PATH |
| 34 | #if defined(__WXMAC__) |
| 35 | #define MAX_PATH 260 /* max. length of full pathname */ |
| 36 | #else /* _MAC */ |
| 37 | #define MAX_PATH 256 /* max. length of full pathname */ |
| 38 | #endif |
| 39 | #endif |
| 40 | |
| 41 | // Name of the table to be created/opened |
| 42 | const wxChar CONTACT_TABLE_NAME[] = "contacts"; |
| 43 | |
| 44 | |
| 45 | #define wxODBC_BLOB_EXPERIMENT 0 |
| 46 | |
| 47 | // Number of columns in the CONTACT table |
| 48 | #if wxODBC_BLOB_EXPERIMENT > 0 |
| 49 | const int CONTACT_NO_COLS = 13; // 0-12 |
| 50 | #else |
| 51 | const int CONTACT_NO_COLS = 12; // 0-11 |
| 52 | #endif |
| 53 | |
| 54 | const wxChar PARAM_FILENAME[] = "dbtest.cfg"; |
| 55 | |
| 56 | |
| 57 | enum Language {langENGLISH, langFRENCH, langGERMAN, langSPANISH, langOTHER}; |
| 58 | |
| 59 | // Forward class declarations |
| 60 | class CeditorDlg; |
| 61 | class CparameterDlg; |
| 62 | |
| 63 | |
| 64 | // Used for displaying many of the database capabilites |
| 65 | // and usage statistics on a database connection |
| 66 | void DisplayDbDiagnostics(wxDb *pDb); |
| 67 | |
| 68 | |
| 69 | // |
| 70 | // This class contains the actual data members that are used for transferring |
| 71 | // data back and forth from the database to the program. |
| 72 | // |
| 73 | // NOTE: The object described in this class is just for example purposes, and has no |
| 74 | // real meaning other than to show each type of field being used by the database |
| 75 | // |
| 76 | class CstructContact : public wxObject |
| 77 | { |
| 78 | public: |
| 79 | wxChar Name[50+1]; // Contact's name |
| 80 | wxChar Addr1[50+1]; |
| 81 | wxChar Addr2[50+1]; |
| 82 | wxChar City[25+1]; |
| 83 | wxChar State[25+1]; |
| 84 | wxChar PostalCode[15+1]; |
| 85 | wxChar Country[20+1]; |
| 86 | TIMESTAMP_STRUCT JoinDate; // Date on which this person joined the wxWindows project |
| 87 | Language NativeLanguage; // Enumerated type indicating person's native language |
| 88 | #if wxODBC_BLOB_EXPERIMENT > 0 |
| 89 | wxChar Picture[50000]; |
| 90 | #endif |
| 91 | bool IsDeveloper; // Is this person a developer for wxWindows, or just a subscriber |
| 92 | UCHAR Contributions; // Something to show off an integer field |
| 93 | ULONG LinesOfCode; // Something to show off a 'long' field |
| 94 | }; // CstructContact |
| 95 | |
| 96 | |
| 97 | // |
| 98 | // The Ccontact class derives from wxDbTable, so we have access to all |
| 99 | // of the database table functions and the local memory variables that |
| 100 | // the database classes will store the data into (and read the data from) |
| 101 | // all combined in this one class. |
| 102 | // |
| 103 | class Ccontact : public wxDbTable, public CstructContact |
| 104 | { |
| 105 | private: |
| 106 | // Used to keep track of whether this class had a wxDb instance |
| 107 | // passed in to it or not. If an existing wxDb instance was not |
| 108 | // passed in at Ccontact creation time, then when the Ccontact |
| 109 | // instance is deleted, the connection will be freed as Ccontact |
| 110 | // created its own connection when it was created. |
| 111 | bool freeDbConn; |
| 112 | |
| 113 | // Calls wxDbTable::SetColDefs() once for each column that is |
| 114 | // to be associated with some member variable for use with |
| 115 | // this database object. |
| 116 | void SetupColumns(); |
| 117 | |
| 118 | public: |
| 119 | // Used in places where we need to construct a WHERE clause to |
| 120 | // be passed to the SetWhereClause() function. From example, |
| 121 | // where building the WHERE clause requires using ::Printf() |
| 122 | // to build the string. |
| 123 | wxString whereStr; |
| 124 | |
| 125 | // WHERE string returned from the query dialog |
| 126 | wxString qryWhereStr; |
| 127 | |
| 128 | Ccontact(wxDb *pwxDb=NULL); |
| 129 | ~Ccontact(); |
| 130 | |
| 131 | void Initialize(); |
| 132 | |
| 133 | // Contains all the index definitions and calls to wxDbTable::CreateIndex() |
| 134 | // required to create all the indexes we wish to define for this table. |
| 135 | bool CreateIndexes(bool recreate); |
| 136 | |
| 137 | // Since we do not wish to have duplicate code blocks all over our program |
| 138 | // for a common query/fetch that we will need to do in many places, we |
| 139 | // include this member function that does it all for us in one place. |
| 140 | bool FetchByName(const wxString &name); |
| 141 | |
| 142 | }; // Ccontact class definition |
| 143 | |
| 144 | |
| 145 | typedef struct Cparameters |
| 146 | { |
| 147 | wxChar ODBCSource[SQL_MAX_DSN_LENGTH+1]; |
| 148 | wxChar UserName[SQL_MAX_USER_NAME_LEN+1]; |
| 149 | wxChar Password[SQL_MAX_AUTHSTR_LEN+1]; |
| 150 | wxChar DirPath[MAX_PATH+1]; |
| 151 | } Cparameters; |
| 152 | |
| 153 | |
| 154 | // Define a new frame type |
| 155 | class DatabaseDemoFrame: public wxFrame |
| 156 | { |
| 157 | private: |
| 158 | CeditorDlg *pEditorDlg; |
| 159 | CparameterDlg *pParamDlg; |
| 160 | |
| 161 | public: |
| 162 | DatabaseDemoFrame(wxFrame *frame, const wxString& title, const wxPoint& pos, const wxSize& sz); |
| 163 | ~DatabaseDemoFrame(); |
| 164 | |
| 165 | void OnCloseWindow(wxCloseEvent& event); |
| 166 | void OnCreate(wxCommandEvent& event); |
| 167 | void OnRecreateTable(wxCommandEvent& event); |
| 168 | void OnRecreateIndexes(wxCommandEvent& event); |
| 169 | void OnExit(wxCommandEvent& event); |
| 170 | void OnEditParameters(wxCommandEvent& event); |
| 171 | void OnAbout(wxCommandEvent& event); |
| 172 | #if wxUSE_NEW_GRID |
| 173 | void OnDbGridTable( wxCommandEvent& ); |
| 174 | #endif |
| 175 | void CreateDataTable(bool recreate); |
| 176 | void BuildEditorDialog(); |
| 177 | void BuildParameterDialog(wxWindow *parent); |
| 178 | |
| 179 | DECLARE_EVENT_TABLE() |
| 180 | }; // DatabaseDemoFrame |
| 181 | |
| 182 | |
| 183 | #if wxUSE_NEW_GRID |
| 184 | |
| 185 | // *************************** DBGridFrame *************************** |
| 186 | |
| 187 | class DbGridFrame : public wxFrame |
| 188 | { |
| 189 | public: |
| 190 | bool initialized; |
| 191 | |
| 192 | DbGridFrame(wxWindow *parent); |
| 193 | |
| 194 | void OnCloseWindow(wxCloseEvent& event); |
| 195 | bool Initialize(); |
| 196 | |
| 197 | DECLARE_EVENT_TABLE() |
| 198 | }; |
| 199 | |
| 200 | #endif |
| 201 | |
| 202 | // Define a new application type |
| 203 | class DatabaseDemoApp: public wxApp |
| 204 | { |
| 205 | public: |
| 206 | // These are the parameters that are stored in the "PARAM_FILENAME" file |
| 207 | // that are read in at startup of the program that indicate the connection |
| 208 | // parameters to be used for connecting to the ODBC data source. |
| 209 | Cparameters params; |
| 210 | |
| 211 | // Pointer to the main frame used by the App |
| 212 | DatabaseDemoFrame *DemoFrame; |
| 213 | |
| 214 | // Pointer to the main database connection used in the program. This |
| 215 | // pointer would normally be used for doing things as database lookups |
| 216 | // for user login names and passwords, getting workstation settings, etc. |
| 217 | // |
| 218 | // ---> IMPORTANT <--- |
| 219 | // |
| 220 | // For each database object created which uses this wxDb pointer |
| 221 | // connection to the database, when a CommitTrans() or RollBackTrans() |
| 222 | // will commit or rollback EVERY object which uses this wxDb pointer. |
| 223 | // |
| 224 | // To allow each table object (those derived from wxDbTable) to be |
| 225 | // individually committed or rolled back, you MUST use a different |
| 226 | // instance of wxDb in the constructor of the table. Doing so creates |
| 227 | // more overhead, and will use more database connections (some DBs have |
| 228 | // connection limits...), so use connections sparringly. |
| 229 | // |
| 230 | // It is recommended that one "main" database connection be created for |
| 231 | // the entire program to use for READ-ONLY database accesses, but for each |
| 232 | // table object which will do a CommitTrans() or RollbackTrans() that a |
| 233 | // new wxDb object be created and used for it. |
| 234 | wxDb *READONLY_DB; |
| 235 | |
| 236 | // Contains the ODBC connection information used by |
| 237 | // all database connections |
| 238 | wxDbConnectInf *DbConnectInf; |
| 239 | |
| 240 | bool OnInit(); |
| 241 | |
| 242 | // Read/Write ODBC connection parameters to the "PARAM_FILENAME" file |
| 243 | bool ReadParamFile(Cparameters ¶ms); |
| 244 | bool WriteParamFile(Cparameters ¶ms); |
| 245 | |
| 246 | void CreateDataTable(bool recreate); |
| 247 | |
| 248 | // Pointer to the wxDbTable instance that is used to manipulate |
| 249 | // the data in memory and in the database |
| 250 | Ccontact *Contact; |
| 251 | |
| 252 | }; // DatabaseDemoApp |
| 253 | |
| 254 | |
| 255 | DECLARE_APP(DatabaseDemoApp) |
| 256 | |
| 257 | |
| 258 | // *************************** CeditorDlg *************************** |
| 259 | |
| 260 | class CeditorDlg : public wxPanel |
| 261 | { |
| 262 | private: |
| 263 | // Used to indicate whether all of the widget pointers (defined |
| 264 | // below) have been initialized to point to the memory for |
| 265 | // the named widget. Used as a safeguard from using the widget |
| 266 | // before it has been initialized. |
| 267 | bool widgetPtrsSet; |
| 268 | |
| 269 | // Used when the EDIT button has been pressed to maintain the |
| 270 | // original name that was displayed in the editor before the |
| 271 | // EDIT button was pressed, so that if CANCEL is pressed, a |
| 272 | // FetchByName() can be done to retrieve the original data |
| 273 | // to repopulate the dialog. |
| 274 | wxString saveName; |
| 275 | |
| 276 | // Pointers to all widgets on the dialog |
| 277 | wxButton *pCreateBtn, *pEditBtn, *pDeleteBtn, *pCopyBtn, *pSaveBtn, *pCancelBtn; |
| 278 | wxButton *pPrevBtn, *pNextBtn, *pQueryBtn, *pResetBtn, *pDoneBtn, *pHelpBtn; |
| 279 | wxButton *pNameListBtn; |
| 280 | wxButton *pCatalogBtn, *pDataTypesBtn, *pDbDiagsBtn; |
| 281 | wxTextCtrl *pNameTxt, *pAddress1Txt, *pAddress2Txt,*pCityTxt, *pStateTxt, *pCountryTxt,*pPostalCodeTxt; |
| 282 | wxStaticText *pNameMsg, *pAddress1Msg, *pAddress2Msg,*pCityMsg, *pStateMsg, *pCountryMsg,*pPostalCodeMsg; |
| 283 | wxTextCtrl *pJoinDateTxt,*pContribTxt, *pLinesTxt; |
| 284 | wxStaticText *pJoinDateMsg,*pContribMsg, *pLinesMsg; |
| 285 | wxRadioBox *pDeveloperRadio; |
| 286 | wxChoice *pNativeLangChoice; |
| 287 | wxStaticText *pNativeLangMsg; |
| 288 | |
| 289 | public: |
| 290 | // Indicates if the editor dialog has been initialized yet (used to |
| 291 | // help trap if the Initialize() function failed to load all required |
| 292 | // resources or not. |
| 293 | bool initialized; |
| 294 | |
| 295 | enum DialogModes mode; |
| 296 | |
| 297 | CeditorDlg(wxWindow *parent); |
| 298 | |
| 299 | void OnCloseWindow(wxCloseEvent& event); |
| 300 | void OnButton( wxCommandEvent &event ); |
| 301 | void OnCommand(wxWindow& win, wxCommandEvent& event); |
| 302 | void OnActivate(bool) {}; // necessary for hot keys |
| 303 | |
| 304 | bool Initialize(); |
| 305 | |
| 306 | // Sets wxStaticText fields to be editable or not depending |
| 307 | // on the current value of 'mode' |
| 308 | void FieldsEditable(); |
| 309 | |
| 310 | // Sets the editor mode, determining what state widgets |
| 311 | // on the dialog are to be in based on the operation |
| 312 | // being performed. |
| 313 | void SetMode(enum DialogModes m); |
| 314 | |
| 315 | // Update/Retrieve data from the widgets on the dialog |
| 316 | bool PutData(); |
| 317 | bool GetData(); |
| 318 | |
| 319 | // Inserts/updates the database with the current data |
| 320 | // retrieved from the editor dialog |
| 321 | bool Save(); |
| 322 | |
| 323 | // Database functions for changing the data that is to |
| 324 | // be displayed on the dialog. GetNextRec()/GetPrevRec() |
| 325 | // provide database independent methods that do not require |
| 326 | // backward scrolling cursors to obtain the record that |
| 327 | // is prior to the current record in the search sequence. |
| 328 | bool GetNextRec(); |
| 329 | bool GetPrevRec(); |
| 330 | bool GetRec(const wxString &whereStr); |
| 331 | |
| 332 | DECLARE_EVENT_TABLE() |
| 333 | }; // CeditorDlg |
| 334 | |
| 335 | #define EDITOR_DIALOG 199 |
| 336 | |
| 337 | // Editor dialog control ids |
| 338 | #define EDITOR_DIALOG_FN_GROUP 200 |
| 339 | #define EDITOR_DIALOG_SEARCH_GROUP 201 |
| 340 | #define EDITOR_DIALOG_CREATE 202 |
| 341 | #define EDITOR_DIALOG_EDIT 203 |
| 342 | #define EDITOR_DIALOG_DELETE 204 |
| 343 | #define EDITOR_DIALOG_COPY 205 |
| 344 | #define EDITOR_DIALOG_SAVE 206 |
| 345 | #define EDITOR_DIALOG_CANCEL 207 |
| 346 | #define EDITOR_DIALOG_PREV 208 |
| 347 | #define EDITOR_DIALOG_NEXT 209 |
| 348 | #define EDITOR_DIALOG_QUERY 211 |
| 349 | #define EDITOR_DIALOG_RESET 212 |
| 350 | #define EDITOR_DIALOG_NAME_MSG 213 |
| 351 | #define EDITOR_DIALOG_NAME_TEXT 214 |
| 352 | #define EDITOR_DIALOG_LOOKUP 215 |
| 353 | #define EDITOR_DIALOG_ADDRESS1_MSG 216 |
| 354 | #define EDITOR_DIALOG_ADDRESS1_TEXT 217 |
| 355 | #define EDITOR_DIALOG_ADDRESS2_MSG 218 |
| 356 | #define EDITOR_DIALOG_ADDRESS2_TEXT 219 |
| 357 | #define EDITOR_DIALOG_CITY_MSG 220 |
| 358 | #define EDITOR_DIALOG_CITY_TEXT 221 |
| 359 | #define EDITOR_DIALOG_COUNTRY_MSG 222 |
| 360 | #define EDITOR_DIALOG_COUNTRY_TEXT 223 |
| 361 | #define EDITOR_DIALOG_POSTAL_MSG 224 |
| 362 | #define EDITOR_DIALOG_POSTAL_TEXT 225 |
| 363 | #define EDITOR_DIALOG_LANG_MSG 226 |
| 364 | #define EDITOR_DIALOG_LANG_CHOICE 227 |
| 365 | #define EDITOR_DIALOG_DATE_MSG 228 |
| 366 | #define EDITOR_DIALOG_DATE_TEXT 229 |
| 367 | #define EDITOR_DIALOG_CONTRIB_MSG 230 |
| 368 | #define EDITOR_DIALOG_CONTRIB_TEXT 231 |
| 369 | #define EDITOR_DIALOG_LINES_MSG 232 |
| 370 | #define EDITOR_DIALOG_LINES_TEXT 233 |
| 371 | #define EDITOR_DIALOG_STATE_MSG 234 |
| 372 | #define EDITOR_DIALOG_STATE_TEXT 235 |
| 373 | #define EDITOR_DIALOG_DEVELOPER 236 |
| 374 | #define EDITOR_DIALOG_JOIN_MSG 237 |
| 375 | #define EDITOR_DIALOG_JOIN_TEXT 238 |
| 376 | #define EDITOR_DIALOG_CATALOG 240 |
| 377 | #define EDITOR_DIALOG_DATATYPES 250 |
| 378 | #define EDITOR_DIALOG_DB_DIAGS 260 |
| 379 | |
| 380 | // *************************** CparameterDlg *************************** |
| 381 | |
| 382 | class CparameterDlg : public wxDialog |
| 383 | { |
| 384 | private: |
| 385 | // Used to indicate whether all of the widget pointers (defined |
| 386 | // below) have been initialized to point to the memory for |
| 387 | // the named widget. Used as a safeguard from using the widget |
| 388 | // before it has been initialized. |
| 389 | bool widgetPtrsSet; |
| 390 | |
| 391 | enum DialogModes mode; |
| 392 | |
| 393 | // Have the parameters been saved yet, or do they |
| 394 | // need to be saved to update the params on disk |
| 395 | bool saved; |
| 396 | |
| 397 | // Original params |
| 398 | Cparameters savedParamSettings; |
| 399 | |
| 400 | // Pointers to all widgets on the dialog |
| 401 | wxStaticText *pParamODBCSourceMsg; |
| 402 | wxListBox *pParamODBCSourceList; |
| 403 | wxStaticText *pParamUserNameMsg, *pParamPasswordMsg, *pParamDirPathMsg; |
| 404 | wxTextCtrl *pParamUserNameTxt, *pParamPasswordTxt, *pParamDirPathTxt; |
| 405 | wxButton *pParamSaveBtn, *pParamCancelBtn; |
| 406 | |
| 407 | public: |
| 408 | CparameterDlg(wxWindow *parent); |
| 409 | |
| 410 | void OnCloseWindow(wxCloseEvent& event); |
| 411 | void OnButton( wxCommandEvent &event ); |
| 412 | void OnCommand(wxWindow& win, wxCommandEvent& event); |
| 413 | void OnActivate(bool) {}; // necessary for hot keys |
| 414 | |
| 415 | // Update/Retrieve data from the widgets on the dialog |
| 416 | bool PutData(); |
| 417 | bool GetData(); |
| 418 | |
| 419 | // Stores the defined parameter for connecting to the selected ODBC |
| 420 | // data source to the config file name in "PARAM_FILENAME" |
| 421 | bool Save(); |
| 422 | |
| 423 | // Populates the 'pParamODBCSourceList' listbox with the names of all |
| 424 | // ODBC datasource defined for use at the current workstation |
| 425 | void FillDataSourceList(); |
| 426 | |
| 427 | DECLARE_EVENT_TABLE() |
| 428 | }; // CparameterDlg |
| 429 | |
| 430 | #define PARAMETER_DIALOG 400 |
| 431 | |
| 432 | // Parameter dialog control ids |
| 433 | #define PARAMETER_DIALOG_SOURCE_MSG 401 |
| 434 | #define PARAMETER_DIALOG_SOURCE_LISTBOX 402 |
| 435 | #define PARAMETER_DIALOG_NAME_MSG 403 |
| 436 | #define PARAMETER_DIALOG_NAME_TEXT 404 |
| 437 | #define PARAMETER_DIALOG_PASSWORD_MSG 405 |
| 438 | #define PARAMETER_DIALOG_PASSWORD_TEXT 406 |
| 439 | #define PARAMETER_DIALOG_DIRPATH_MSG 407 |
| 440 | #define PARAMETER_DIALOG_DIRPATH_TEXT 408 |
| 441 | #define PARAMETER_DIALOG_SAVE 409 |
| 442 | #define PARAMETER_DIALOG_CANCEL 410 |
| 443 | |
| 444 | // *************************** CqueryDlg *************************** |
| 445 | |
| 446 | |
| 447 | // QUERY DIALOG |
| 448 | enum qryOp |
| 449 | { |
| 450 | qryOpEQ, |
| 451 | qryOpLT, |
| 452 | qryOpGT, |
| 453 | qryOpLE, |
| 454 | qryOpGE, |
| 455 | qryOpBEGINS, |
| 456 | qryOpCONTAINS, |
| 457 | qryOpLIKE, |
| 458 | qryOpBETWEEN |
| 459 | }; |
| 460 | |
| 461 | |
| 462 | // Query strings |
| 463 | wxChar * const langQRY_EQ = "column = column | value"; |
| 464 | wxChar * const langQRY_LT = "column < column | value"; |
| 465 | wxChar * const langQRY_GT = "column > column | value"; |
| 466 | wxChar * const langQRY_LE = "column <= column | value"; |
| 467 | wxChar * const langQRY_GE = "column >= column | value"; |
| 468 | wxChar * const langQRY_BEGINS = "columns that BEGIN with the string entered"; |
| 469 | wxChar * const langQRY_CONTAINS = "columns that CONTAIN the string entered"; |
| 470 | wxChar * const langQRY_LIKE = "% matches 0 or more of any char; _ matches 1 char"; |
| 471 | wxChar * const langQRY_BETWEEN = "column BETWEEN value AND value"; |
| 472 | |
| 473 | |
| 474 | class CqueryDlg : public wxDialog |
| 475 | { |
| 476 | private: |
| 477 | wxDbColInf *colInf; // Column inf. returned by db->GetColumns() |
| 478 | wxDbTable *dbTable; // generic wxDbTable object for attaching to the table to query |
| 479 | wxChar *masterTableName; // Name of the table that 'dbTable' will be associated with |
| 480 | wxString pWhere; // A pointer to the storage for the resulting where clause |
| 481 | wxDb *pDB; |
| 482 | |
| 483 | public: |
| 484 | // Used to indicate whether all of the widget pointers (defined |
| 485 | // below) have been initialized to point to the memory for |
| 486 | // the named widget. Used as a safeguard from using the widget |
| 487 | // before it has been initialized. |
| 488 | bool widgetPtrsSet; |
| 489 | |
| 490 | // Widget pointers |
| 491 | wxStaticText *pQueryCol1Msg; |
| 492 | wxChoice *pQueryCol1Choice; |
| 493 | wxStaticText *pQueryNotMsg; |
| 494 | wxCheckBox *pQueryNotCheck; |
| 495 | wxStaticText *pQueryOperatorMsg; |
| 496 | wxChoice *pQueryOperatorChoice; |
| 497 | wxStaticText *pQueryCol2Msg; |
| 498 | wxChoice *pQueryCol2Choice; |
| 499 | wxStaticText *pQueryValue1Msg; |
| 500 | wxTextCtrl *pQueryValue1Txt; |
| 501 | wxStaticText *pQueryValue2Msg; |
| 502 | wxTextCtrl *pQueryValue2Txt; |
| 503 | wxStaticText *pQuerySqlWhereMsg; |
| 504 | wxTextCtrl *pQuerySqlWhereMtxt; |
| 505 | wxButton *pQueryAddBtn; |
| 506 | wxButton *pQueryAndBtn; |
| 507 | wxButton *pQueryOrBtn; |
| 508 | wxButton *pQueryLParenBtn; |
| 509 | wxButton *pQueryRParenBtn; |
| 510 | wxButton *pQueryDoneBtn; |
| 511 | wxButton *pQueryClearBtn; |
| 512 | wxButton *pQueryCountBtn; |
| 513 | wxButton *pQueryHelpBtn; |
| 514 | wxStaticBox *pQueryHintGrp; |
| 515 | wxStaticText *pQueryHintMsg; |
| 516 | |
| 517 | wxTextCtrl *pFocusTxt; |
| 518 | |
| 519 | CqueryDlg(wxWindow *parent, wxDb *pDb, wxChar *tblName[], const wxString &pWhereArg); |
| 520 | ~CqueryDlg(); |
| 521 | |
| 522 | void OnButton( wxCommandEvent &event ); |
| 523 | void OnCommand(wxWindow& win, wxCommandEvent& event); |
| 524 | void OnCloseWindow(wxCloseEvent& event); |
| 525 | void OnActivate(bool) {}; // necessary for hot keys |
| 526 | |
| 527 | void AppendToWhere(wxChar *s); |
| 528 | void ProcessAddBtn(); |
| 529 | void ProcessCountBtn(); |
| 530 | bool ValidateWhereClause(); |
| 531 | |
| 532 | DECLARE_EVENT_TABLE() |
| 533 | }; // CqueryDlg |
| 534 | |
| 535 | #define QUERY_DIALOG 300 |
| 536 | |
| 537 | // Parameter dialog control ids |
| 538 | #define QUERY_DIALOG_COL_MSG 301 |
| 539 | #define QUERY_DIALOG_COL_CHOICE 302 |
| 540 | #define QUERY_DIALOG_NOT_MSG 303 |
| 541 | #define QUERY_DIALOG_NOT_CHECKBOX 304 |
| 542 | #define QUERY_DIALOG_OP_MSG 305 |
| 543 | #define QUERY_DIALOG_OP_CHOICE 306 |
| 544 | #define QUERY_DIALOG_COL2_MSG 307 |
| 545 | #define QUERY_DIALOG_COL2_CHOICE 308 |
| 546 | #define QUERY_DIALOG_WHERE_MSG 309 |
| 547 | #define QUERY_DIALOG_WHERE_TEXT 310 |
| 548 | #define QUERY_DIALOG_ADD 311 |
| 549 | #define QUERY_DIALOG_AND 312 |
| 550 | #define QUERY_DIALOG_OR 313 |
| 551 | #define QUERY_DIALOG_LPAREN 314 |
| 552 | #define QUERY_DIALOG_RPAREN 315 |
| 553 | #define QUERY_DIALOG_DONE 316 |
| 554 | #define QUERY_DIALOG_CLEAR 317 |
| 555 | #define QUERY_DIALOG_COUNT 318 |
| 556 | #define QUERY_DIALOG_VALUE1_MSG 319 |
| 557 | #define QUERY_DIALOG_VALUE1_TEXT 320 |
| 558 | #define QUERY_DIALOG_VALUE2_MSG 321 |
| 559 | #define QUERY_DIALOG_VALUE2_TEXT 322 |
| 560 | #define QUERY_DIALOG_HINT_GROUP 323 |
| 561 | #define QUERY_DIALOG_HINT_MSG 324 |
| 562 | |
| 563 | char * const langNO = "No"; |
| 564 | char * const langYES = "Yes"; |
| 565 | char * const langDBINF_DB_NAME = "Database Name = "; |
| 566 | char * const langDBINF_DB_VER = "Database Version = "; |
| 567 | char * const langDBINF_DRIVER_NAME = "Driver Name = "; |
| 568 | char * const langDBINF_DRIVER_ODBC_VER = "Driver ODBC Version = "; |
| 569 | char * const langDBINF_DRIVER_MGR_ODBC_VER = "Driver Manager ODBC Version = "; |
| 570 | char * const langDBINF_DRIVER_VER = "Driver Version = "; |
| 571 | char * const langDBINF_SERVER_NAME = "Server Name = "; |
| 572 | char * const langDBINF_FILENAME = "Filename = "; |
| 573 | char * const langDBINF_OUTER_JOINS = "Outer Joins = "; |
| 574 | char * const langDBINF_STORED_PROC = "Stored Procedures = "; |
| 575 | char * const langDBINF_MAX_HDBC = "Max # of Db connections = "; |
| 576 | char * const langDBINF_MAX_HSTMT = "Max # of cursors (per db connection) = "; |
| 577 | char * const langDBINF_UNLIMITED = "Unlimited or Unknown"; |
| 578 | char * const langDBINF_API_LVL = "ODBC API conformance level = "; |
| 579 | char * const langDBINF_CLI_LVL = "Client (SAG) conformance level = "; |
| 580 | char * const langDBINF_SQL_LVL = "SQL conformance level = "; |
| 581 | char * const langDBINF_COMMIT_BEHAVIOR = "Commit Behavior = "; |
| 582 | char * const langDBINF_ROLLBACK_BEHAVIOR = "Rollback Behavior = "; |
| 583 | char * const langDBINF_SUPP_NOT_NULL = "Support NOT NULL clause = "; |
| 584 | char * const langDBINF_SUPP_IEF = "Support IEF = "; |
| 585 | char * const langDBINF_TXN_ISOLATION = "Transaction Isolation Level (default) = "; |
| 586 | char * const langDBINF_TXN_ISOLATION_CURR = "Transaction Isolation Level (current) = "; |
| 587 | char * const langDBINF_TXN_ISOLATION_OPTS = "Transaction Isolation Options Available = "; |
| 588 | char * const langDBINF_FETCH_DIRS = "Fetch Directions = "; |
| 589 | char * const langDBINF_LOCK_TYPES = "Lock Types (SQLSetPos) = "; |
| 590 | char * const langDBINF_POS_OPERS = "Position Operations (SQLSetPos) = "; |
| 591 | char * const langDBINF_POS_STMTS = "Position Statements = "; |
| 592 | char * const langDBINF_SCROLL_CONCURR = "Concurrency Options (scrollable cursors) = "; |
| 593 | char * const langDBINF_SCROLL_OPTS = "Scroll Options (scrollable cursors) = "; |
| 594 | char * const langDBINF_STATIC_SENS = "Static Sensitivity = "; |
| 595 | char * const langDBINF_TXN_CAPABLE = "Transaction Support = "; |
| 596 | char * const langDBINF_LOGIN_TIMEOUT = "Login Timeout = "; |
| 597 | char * const langDBINF_NONE = "None"; |
| 598 | char * const langDBINF_LEVEL1 = "Level 1"; |
| 599 | char * const langDBINF_LEVEL2 = "Level 2"; |
| 600 | char * const langDBINF_NOT_COMPLIANT = "Not Compliant"; |
| 601 | char * const langDBINF_COMPLIANT = "Compliant"; |
| 602 | char * const langDBINF_MIN_GRAMMAR = "Minimum Grammer"; |
| 603 | char * const langDBINF_CORE_GRAMMAR = "Core Grammer"; |
| 604 | char * const langDBINF_EXT_GRAMMAR = "Extended Grammer"; |
| 605 | char * const langDBINF_DELETE_CURSORS = "Delete cursors"; |
| 606 | char * const langDBINF_CLOSE_CURSORS = "Close cursors"; |
| 607 | char * const langDBINF_PRESERVE_CURSORS = "Preserve cursors"; |
| 608 | char * const langDBINF_READ_UNCOMMITTED = "Read Uncommitted"; |
| 609 | char * const langDBINF_READ_COMMITTED = "Read Committed"; |
| 610 | char * const langDBINF_REPEATABLE_READ = "Repeatable Read"; |
| 611 | char * const langDBINF_SERIALIZABLE = "Serializable"; |
| 612 | char * const langDBINF_VERSIONING = "Versioning"; |
| 613 | char * const langDBINF_NEXT = "Next"; |
| 614 | char * const langDBINF_PREV = "Prev"; |
| 615 | char * const langDBINF_FIRST = "First"; |
| 616 | char * const langDBINF_LAST = "Last"; |
| 617 | char * const langDBINF_ABSOLUTE = "Absolute"; |
| 618 | char * const langDBINF_RELATIVE = "Relative"; |
| 619 | char * const langDBINF_RESUME = "Resume"; |
| 620 | char * const langDBINF_BOOKMARK = "Bookmark"; |
| 621 | char * const langDBINF_NO_CHANGE = "No Change"; |
| 622 | char * const langDBINF_EXCLUSIVE = "Exclusive"; |
| 623 | char * const langDBINF_UNLOCK = "Unlock"; |
| 624 | char * const langDBINF_POSITION = "Position"; |
| 625 | char * const langDBINF_REFRESH = "Refresh"; |
| 626 | char * const langDBINF_UPD = "Upd"; |
| 627 | char * const langDBINF_DEL = "Del"; |
| 628 | char * const langDBINF_ADD = "Add"; |
| 629 | char * const langDBINF_POS_DEL = "Pos Delete"; |
| 630 | char * const langDBINF_POS_UPD = "Pos Update"; |
| 631 | char * const langDBINF_SELECT_FOR_UPD = "Select For Update"; |
| 632 | char * const langDBINF_READ_ONLY = "Read Only"; |
| 633 | char * const langDBINF_LOCK = "Lock"; |
| 634 | char * const langDBINF_OPT_ROWVER = "Opt. Rowver"; |
| 635 | char * const langDBINF_OPT_VALUES = "Opt. Values"; |
| 636 | char * const langDBINF_FWD_ONLY = "Fwd Only"; |
| 637 | char * const langDBINF_STATIC = "Static"; |
| 638 | char * const langDBINF_KEYSET_DRIVEN = "Keyset Driven"; |
| 639 | char * const langDBINF_DYNAMIC = "Dynamic"; |
| 640 | char * const langDBINF_MIXED = "Mixed"; |
| 641 | char * const langDBINF_ADDITIONS = "Additions"; |
| 642 | char * const langDBINF_DELETIONS = "Deletions"; |
| 643 | char * const langDBINF_UPDATES = "Updates"; |
| 644 | char * const langDBINF_DML_ONLY = "DML Only"; |
| 645 | char * const langDBINF_DDL_COMMIT = "DDL Commit"; |
| 646 | char * const langDBINF_DDL_IGNORE = "DDL Ignore"; |
| 647 | char * const langDBINF_DDL_AND_DML = "DDL and DML"; |
| 648 | char * const langDBINF_ORACLE_BANNER = ">>> ORACLE STATISTICS AND TUNING INFORMATION <<<"; |
| 649 | char * const langDBINF_DB_BLOCK_GETS = "DB block gets"; |
| 650 | char * const langDBINF_CONSISTENT_GETS = "Consistent gets"; |
| 651 | char * const langDBINF_PHYSICAL_READS = "Physical reads"; |
| 652 | char * const langDBINF_CACHE_HIT_RATIO = "Cache hit ratio"; |
| 653 | char * const langDBINF_TABLESPACE_IO = "TABLESPACE I/O LEVELS"; |
| 654 | char * const langDBINF_PHYSICAL_WRITES = "Physical writes"; |