| | 1 | //---------------------------------------------------------------------------------------- |
| | 2 | // Name: browsedb.h |
| | 3 | // Purpose: a wxDb class |
| | 4 | // Author: Mark Johnson |
| | 5 | // Modified by: |
| | 6 | // Created: 19991127.mj10777 |
| | 7 | // Copyright: (c) Mark Johnson |
| | 8 | // Licence: wxWindows license |
| | 9 | // RCS-ID: $Id$ |
| | 10 | //---------------------------------------------------------------------------------------- |
| | 11 | //-- Zu tun in browsedb.h |
| | 12 | //---------------------------------------------------------------------------------------- |
| | 13 | //-- 1) |
| | 14 | //---------------------------------------------------------------------------------------- |
| | 15 | // Global structure for holding ODBC connection information |
| | 16 | //---------------------------------------------------------------------------------------- |
| | 17 | //extern wxDbConnectInf DbConnectInf; |
| | 18 | class MainDoc; |
| | 19 | |
| | 20 | //---------------------------------------------------------------------------------------- |
| | 21 | class BrowserDB |
| | 22 | { |
| | 23 | public: |
| | 24 | //--------------------------------------------------------------------------------------- |
| | 25 | // Pointer to the main database connection used in the program. This |
| | 26 | // pointer would normally be used for doing things as database lookups |
| | 27 | // for user login names and passwords, getting workstation settings, etc. |
| | 28 | // ---> IMPORTANT <--- |
| | 29 | // |
| | 30 | // For each database object created which uses this wxDb pointer |
| | 31 | // connection to the database, when a CommitTrans() or RollBackTrans() |
| | 32 | // will commit or rollback EVERY object which uses this wxDb pointer. |
| | 33 | // |
| | 34 | // To allow each table object (those derived from wxDbTable) to be |
| | 35 | // individually committed or rolled back, you MUST use a different |
| | 36 | // instance of wxDb in the constructor of the table. Doing so creates |
| | 37 | // more overhead, and will use more database connections (some DBs have |
| | 38 | // connection limits...), so use connections sparringly. |
| | 39 | // |
| | 40 | // It is recommended that one "main" database connection be created for |
| | 41 | // the entire program to use for READ-ONLY database accesses, but for each |
| | 42 | // table object which will do a CommitTrans() or RollbackTrans() that a |
| | 43 | // new wxDb object be created and used for it. |
| | 44 | //--------------------------------------------------------------------------------------- |
| | 45 | wxDb* db_BrowserDB; |
| | 46 | wxDbInf* ct_BrowserDB; |
| | 47 | wxDbColInf* cl_BrowserDB; |
| | 48 | wxString ODBCSource, UserName, Password; |
| | 49 | MainDoc *pDoc; |
| | 50 | //--------------------------------------------------------------------------------------- |
| | 51 | wxString Temp0, Temp1, Temp2, Temp3, Temp4, Temp5; |
| | 52 | wxString ODBCText; |
| | 53 | wxTextCtrl* p_LogWindow; |
| | 54 | wxString s_SqlTyp[25]; |
| | 55 | int i_SqlTyp[25]; |
| | 56 | wxString s_dbTyp[5]; |
| | 57 | int i_dbTyp[5]; |
| | 58 | int i_Which; |
| | 59 | int i_Records; |
| | 60 | int i_Cols; |
| | 61 | //--------------------------------------------------------------------------------------- |
| | 62 | BrowserDB(); |
| | 63 | ~BrowserDB(); |
| | 64 | void PointerToNULL(int Art); |
| | 65 | bool Initialize(int Quiet); |
| | 66 | //--------------------------------------------------------------------------------------- |
| | 67 | bool OnStartDB(int Quiet); |
| | 68 | bool OnCloseDB(int Quiet); |
| | 69 | bool OnSelect(wxString tb_Name,int Quiet); |
| | 70 | bool OnExecSql(wxString SQLStmt,int Quiet); |
| | 71 | bool OnGetNext(int Cols,int Quiet); |
| | 72 | wxDbInf* OnGetCatalog(int Quiet); |
| | 73 | wxDbColInf* OnGetColumns(char *tableName, int numCols,int Quiet); |
| | 74 | void OnFillSqlTyp(); |
| | 75 | void OnFilldbTyp(); |
| | 76 | //--------------------------------------------------------------------------------------- |
| | 77 | }; // BrowserDB class definition |
| | 78 | //---------------------------------------------------------------------------------------- |
projects / wxWidgets.git / blame_incremental