--- /dev/null
+/* XPM */\r
+static char* VIEW_xpm[] = {
+"16 16 5 1",\r
+" c #000000",\r
+"! c #000080",\r
+"# c #C0C0C0",\r
+"$ c #808080",\r
+"% c #FFFFFF",\r
+"$$$$$$$$$$$$$$$$",\r
+"$$$$$$$$$$$$$$$$",\r
+"$#############$ ",\r
+"$#$$$$$$$$$$$$$ ",\r
+"$$$$$$$$$$$$$$$ ",\r
+"$$############# ",\r
+"$$#$$$$$$$$$$$$ ",\r
+"$$#$$$$$$$$$$$$ ",\r
+"$$#$$$$$$$$$$$$ ",\r
+"$$#%%%%%%%%%%%$ ",\r
+"$$#%!!!%!!!%!%$ ",\r
+"$$#%%%%%%%%%%%$ ",\r
+"$$#%!!!%!!!%!%$ ",\r
+"$$#%%%%%%%%%%%$ ",\r
+" $#%!!!%!!!%!% ",\r
+"%$$$$$$$$$$$$$$$"};
KEY ICON "bitmaps\\key.ico"
KEYF ICON "bitmaps\\keyf.ico"
TAB ICON "bitmaps\\tab.ico"
+VIEW ICON "bitmaps\\view.ico"
DocClosed ICON "bitmaps\\d_closed.ico"
DocOpen ICON "bitmaps\\d_open.ico"
FolderClosed ICON "bitmaps\\f_closed.ico"
//---------------------------------------------------------------------------
int DBGrid::OnTableView(wxString Table)
{
- //---------------------------------------------------------------------------
- int i=0,x,y,z, ValidTable=0;
- wxString Temp0;
- //SetLabelFont(* f_Temp);
-
- wxBeginBusyCursor();
- //---------------------------------------------------------------------------
- ct_BrowserDB = (db_Br+i_Which)->ct_BrowserDB; // Get the DSN Pointer
- //----------------------------------------------------------------------------
- if (ct_BrowserDB) // Valid pointer (!= NULL) ?
- { // Pointer is Valid, use the wxDatabase Information
- for (x=0;x<ct_BrowserDB->numTables;x++) // go through the Tables
- {
- if (!wxStrcmp((ct_BrowserDB->pTableInf+x)->tableName,Table)) // is this our Table ?
- { // Yes, the Data of this Table shall be put into the Grid
- ValidTable = x; // Save the Tablenumber
- (db_Br+i_Which)->OnSelect(Table,FALSE); // Select * from "table"
- // Set the local Pointer to the Column Information we are going to use
- (db_Br+i_Which)->cl_BrowserDB = (ct_BrowserDB->pTableInf+x)->pColInf;
- if ((ct_BrowserDB->pTableInf+x)->pColInf) // Valid pointer (!= NULL) ?
- { // Pointer is Valid, Column Informationen sind Vorhanden
- i = (db_Br+i_Which)->i_Records; // How many Records are there
- (db_Br+i_Which)->i_Which = ValidTable; // Still used ???? mj10777
- if (i == 0) // If the Table is empty, then show one empty row
- i++;
- CreateGrid(i,(ct_BrowserDB->pTableInf+x)->numCols); // Records , Columns
- for (y=0;y<(ct_BrowserDB->pTableInf+x)->numCols;y++) // Loop through the Fields
- { // The Field / Column name is used here as Row Titel
- SetColLabelValue(y,((ct_BrowserDB->pTableInf+x)->pColInf+y)->colName);
- SetColSize(y,95);
- } // for (y=0;y<(ct_BrowserDB->pTableInf+x)->numCols;y++)
- SetColSize(((ct_BrowserDB->pTableInf+x)->numCols-1),120); // Make the last Column Wider
- // The Grid has been created, now fill it
- for (z=0;z<(db_Br+i_Which)->i_Records;z++) // Loop through the Records
- {
- Temp0.Printf("%06d",z+1); SetRowLabelValue(z,Temp0); // Set Row Lable Value
- (db_Br+i_Which)->OnGetNext((ct_BrowserDB->pTableInf+ValidTable)->numCols,FALSE);
- for (y=0;y<(ct_BrowserDB->pTableInf+ValidTable)->numCols;y++) // Loop through the Fields
- { // BrowserDB::OnGetNext Formats the field Value into tablename
- SetCellValue(z, y,((db_Br+i_Which)->cl_BrowserDB+y)->tableName);
- }
- if (z % 50 == 0)
- {
- Temp0.Printf(_("-I-> DBGrid::OnTableView(%s) - Record %6d has been read."),Table.c_str(),z);
- pDoc->p_MainFrame->SetStatusText(Temp0, 0);
- }
- } // for (z=0;z<(db_Br+i_Which)->i_Records;z++)
- Temp0.Printf(_("-I-> DBGrid::OnTableView(%s) - %6d Records have been read."),Table.c_str(),z);
- pDoc->p_MainFrame->SetStatusText(Temp0, 0);
- // The Grid has been filled, now leave
- goto Weiter;
- } // if ((ct_BrowserDB->pTableInf+x)->pColInf)
- else
- wxLogMessage(_("\n-E-> DBGrid::OnTableView():: Invalid Column Pointer : Failed"));
- } // if ((ct_BrowserDB->pTableInf+x)->tableType == "TABLE")
- } // for (x=0;x<ct_BrowserDB->numTables;x++)
- } // if (ct_BrowserDB)
- else
- wxLogMessage(_("\n-E-> DBGrid::OnTableView():: Invalid DSN Pointer : Failed"));
+ //---------------------------------------------------------------------------
+ int i=0,x,y,z, ValidTable=0;
+ wxString Temp0;
+ //SetLabelFont(* f_Temp);
+ wxBeginBusyCursor();
+ //---------------------------------------------------------------------------
+ ct_BrowserDB = (db_Br+i_Which)->ct_BrowserDB; // Get the DSN Pointer
+ //----------------------------------------------------------------------------
+ if (ct_BrowserDB) // Valid pointer (!= NULL) ?
+ { // Pointer is Valid, use the wxDatabase Information
+ for (x=0;x<ct_BrowserDB->numTables;x++) // go through the Tables
+ {
+ if (!wxStrcmp((ct_BrowserDB->pTableInf+x)->tableName,Table)) // is this our Table ?
+ { // Yes, the Data of this Table shall be put into the Grid
+ ValidTable = x; // Save the Tablenumber
+ (db_Br+i_Which)->OnSelect(Table,FALSE); // Select * from "table"
+ // Set the local Pointer to the Column Information we are going to use
+ (db_Br+i_Which)->cl_BrowserDB = (ct_BrowserDB->pTableInf+x)->pColInf;
+ if ((ct_BrowserDB->pTableInf+x)->pColInf) // Valid pointer (!= NULL) ?
+ { // Pointer is Valid, Column Informationen sind Vorhanden
+ i = (db_Br+i_Which)->i_Records; // How many Records are there
+ (db_Br+i_Which)->i_Which = ValidTable; // Still used ???? mj10777
+ if (i == 0) // If the Table is empty, then show one empty row
+ i++;
+ wxLogMessage(_("\n-I-> DBGrid::OnTableView():: Vor CreateGrid"));
+ CreateGrid(i,(ct_BrowserDB->pTableInf+x)->numCols); // Records , Columns
+ for (y=0;y<(ct_BrowserDB->pTableInf+x)->numCols;y++) // Loop through the Fields
+ { // The Field / Column name is used here as Row Titel
+ SetColLabelValue(y,((ct_BrowserDB->pTableInf+x)->pColInf+y)->colName);
+ SetColSize(y,95);
+ } // for (y=0;y<(ct_BrowserDB->pTableInf+x)->numCols;y++)
+ SetColSize(((ct_BrowserDB->pTableInf+x)->numCols-1),120); // Make the last Column Wider
+ // The Grid has been created, now fill it
+ for (z=0;z<(db_Br+i_Which)->i_Records;z++) // Loop through the Records
+ {
+ Temp0.Printf("%06d",z+1); SetRowLabelValue(z,Temp0); // Set Row Lable Value
+ (db_Br+i_Which)->OnGetNext((ct_BrowserDB->pTableInf+ValidTable)->numCols,FALSE);
+ for (y=0;y<(ct_BrowserDB->pTableInf+ValidTable)->numCols;y++) // Loop through the Fields
+ { // BrowserDB::OnGetNext Formats the field Value into tablename
+ SetCellValue(z, y,((db_Br+i_Which)->cl_BrowserDB+y)->tableName);
+ }
+ if (z % 50 == 0)
+ {
+ Temp0.Printf(_("-I-> DBGrid::OnTableView(%s) - Record %6d has been read."),Table.c_str(),z);
+ pDoc->p_MainFrame->SetStatusText(Temp0, 0);
+ }
+ } // for (z=0;z<(db_Br+i_Which)->i_Records;z++)
+ Temp0.Printf(_("-I-> DBGrid::OnTableView(%s) - %6d Records have been read."),Table.c_str(),z);
+ pDoc->p_MainFrame->SetStatusText(Temp0, 0);
+ // The Grid has been filled, now leave
+ goto Weiter;
+ } // if ((ct_BrowserDB->pTableInf+x)->pColInf)
+ else
+ wxLogMessage(_("\n-E-> DBGrid::OnTableView():: Invalid Column Pointer : Failed"));
+ } // if ((ct_BrowserDB->pTableInf+x)->tableType == "TABLE")
+ } // for (x=0;x<ct_BrowserDB->numTables;x++)
+ } // if (ct_BrowserDB)
+ else
+ wxLogMessage(_("\n-E-> DBGrid::OnTableView():: Invalid DSN Pointer : Failed"));
//---------------------------------------------------------------------------
Weiter:
SetEditInPlace(b_EditModus); // Activate in-place Editing (FALSE)
{
logBuf = "DBGrid::OnCellLeftClick : ";
logBuf << "Cell at row " << ev.GetRow()
- << " col " << ev.GetCol();
+ << " col " << ev.GetCol();
// wxLogMessage( "%s", logBuf.c_str() );
// wxMessageBox(logBuf);
logBuf += "\n";
{
logBuf = "DBGrid::OnCellRightClick : ";
logBuf << "Cell at row " << ev.GetRow()
- << " col " << ev.GetCol();
+ << " col " << ev.GetCol();
// wxLogMessage( "%s", logBuf.c_str() );
// wxMessageBox(logBuf);
logBuf += "\n";
{
logBuf = "DBGrid::OnCellLeftDClick : ";
logBuf << "Cell at row " << ev.GetRow()
- << " col " << ev.GetCol();
+ << " col " << ev.GetCol();
// wxLogMessage( "%s", logBuf.c_str() );
// wxMessageBox(logBuf);
logBuf += "\n";
{
logBuf = "DBGrid::OnCellRightDClick : ";
logBuf << "Cell at row " << ev.GetRow()
- << " col " << ev.GetCol();
+ << " col " << ev.GetCol();
// wxLogMessage( "%s", logBuf.c_str() );
// wxMessageBox(logBuf);
logBuf += "\n";
{
logBuf = "DBGrid::OnCellChange : ";
logBuf << "Cell at row " << ev.GetRow()
- << " col " << ev.GetCol();
+ << " col " << ev.GetCol();
// wxLogMessage( "%s", logBuf.c_str() );
// wxMessageBox(logBuf);
logBuf += "\n";
// wxLogMessage( "%s", logBuf.c_str() );
logBuf += "\n";
wxLogMessage(logBuf.c_str());
-
+
ev.Skip();
}
//---------------------------------------------------------------------------
{
logBuf = "DBGrid::OnRangeSelected : ";
logBuf << "Selected cells from row " << ev.GetTopRow()
- << " col " << ev.GetLeftCol()
- << " to row " << ev.GetBottomRow()
- << " col " << ev.GetRightCol();
-
+ << " col " << ev.GetLeftCol()
+ << " to row " << ev.GetBottomRow()
+ << " col " << ev.GetRightCol();
+
logBuf += "\n";
// wxLogMessage( "%s", logBuf.c_str() );
wxLogMessage(logBuf.c_str());
-
+
ev.Skip();
}
//---------------------------------------------------------------------------
-
// Author: Mark Johnson
// Modified by:
// Created: 19991129
-/// RCS-ID: $Id$
+// RCS-ID: $Id$
// Copyright: (c) Mark Johnson, Berlin Germany, mj10777@gmx.net
// Licence: wxWindows license
//---------------------------------------------------------------------------
//wxFont* ft_Temp = new wxFont(10,wxSWISS,wxNORMAL,wxBOLD,FALSE,"Comic Sans MS");
wxFont* ft_Temp = new wxFont(wxSystemSettings::GetSystemFont(wxSYS_SYSTEM_FONT));
SetFont(* ft_Temp);
-
+
// Make an image list containing small icons
p_imageListNormal = new wxImageList(16, 16, TRUE);
-
+
// should correspond to TreeIc_xxx enum
#if !defined(__WXMSW__)
#include "bitmaps/key.xpm"
#include "bitmaps/keyf.xpm"
#include "bitmaps/d_open.xpm"
-#include "bitmaps/d_closed.xpm"
+#include "bitmaps/d_closed.xpm"
#include "bitmaps/col.xpm"
#endif
p_imageListNormal->Add(wxICON(DocOpen));
p_imageListNormal->Add(wxICON(DocOpen));
-
-
+
+
SetImageList(p_imageListNormal);
ct_BrowserDB = NULL;
}
//---------------------------------------------------------------------------
int DBTree::OnPopulate()
{
- wxTreeItemId Root, Folder, Docu, Funkt;
- int i,x,y;
- wxString SQL_TYPE, DB_TYPE;
-
- //----------------------------------------------------------------------------------------------------------------------------
- if((pDoc->db_Br+i_Which)->Initialize(FALSE))
+ wxTreeItemId Root, Folder, Docu, Funkt;
+ int i,x,y, TableType;
+ wxString SQL_TYPE, DB_TYPE;
+ //----------------------------------------------------------------------------------------------------------------------------
+ if ((pDoc->db_Br+i_Which)->Initialize(FALSE))
+ {
+ wxBeginBusyCursor();
+ ct_BrowserDB = (pDoc->db_Br+i_Which)->OnGetCatalog(FALSE);
+ if (ct_BrowserDB)
+ { // Use the wxDatabase Information
+ Temp0.Printf("%s - (%s) (%s)", s_DSN.c_str(),ct_BrowserDB->catalog, ct_BrowserDB->schema);
+ // Root = AddRoot(Temp0,TreeIc_DsnOpen,TreeIc_DsnOpen,new DBTreeData("Root"));
+ Root = AddRoot(Temp0,TreeIc_Smile,TreeIc_Smile,new DBTreeData("Root"));
+ for (x=0;x<ct_BrowserDB->numTables;x++)
+ {
+ wxYield();
+ TableType = 0; // TABLE = 1 ; VIEW = 2 ; 0 We are not interested in
+ if (!wxStrcmp((ct_BrowserDB->pTableInf+x)->tableType,"TABLE")) // only TABLES
+ TableType = 1;
+ if (!wxStrcmp((ct_BrowserDB->pTableInf+x)->tableType,"VIEW")) // and VIEWS
+ TableType = 2;
+ if (TableType) // only TABLES or Views
{
- wxBeginBusyCursor();
- ct_BrowserDB = (pDoc->db_Br+i_Which)->OnGetCatalog(FALSE);
- if (ct_BrowserDB)
- { // Use the wxDatabase Information
- Temp0.Printf("%s - (%s) (%s)", s_DSN.c_str(),ct_BrowserDB->catalog, ct_BrowserDB->schema);
- Root = AddRoot(Temp0,TreeIc_DsnOpen,TreeIc_DsnOpen,new DBTreeData("Root"));
- for (x=0;x<ct_BrowserDB->numTables;x++)
- {
- wxYield();
- if (!wxStrcmp((ct_BrowserDB->pTableInf+x)->tableType,"TABLE")) // only TABLES
- {
- Temp0.Printf(_("Tablename(%s) with (%d)Columns ; Remarks(%s)"), (ct_BrowserDB->pTableInf+x)->tableName,
- (ct_BrowserDB->pTableInf+x)->numCols,
- (ct_BrowserDB->pTableInf+x)->tableRemarks);
- Temp1.Printf("TN(%s",(ct_BrowserDB->pTableInf+x)->tableName);
- //----
- (ct_BrowserDB->pTableInf+x)->pColInf = (pDoc->db_Br+i_Which)->OnGetColumns((ct_BrowserDB->pTableInf+x)->tableName,(ct_BrowserDB->pTableInf+x)->numCols,FALSE);
- //----
- if ((ct_BrowserDB->pTableInf+x)->pColInf)
- {
- Temp0.Printf(_("Tablename(%s) with (%d)Columns ; Remarks(%s)"), (ct_BrowserDB->pTableInf+x)->tableName,
- (ct_BrowserDB->pTableInf+x)->numCols,
- (ct_BrowserDB->pTableInf+x)->tableRemarks);
- Folder = AppendItem(Root,Temp0,TreeIc_TAB,TreeIc_TAB, new DBTreeData(Temp1));
- for (y=0;y<(ct_BrowserDB->pTableInf+x)->numCols;y++)
- {
- Temp1.Printf("FN(%s",((ct_BrowserDB->pTableInf+x)->pColInf+y)->colName);
- // Here is where we find out if the Column is a Primary / Foreign Key
- if (((ct_BrowserDB->pTableInf+x)->pColInf+y)->PkCol != 0) // Primary Key
- {
- Docu = AppendItem(Folder,((ct_BrowserDB->pTableInf+x)->pColInf+y)->colName,TreeIc_KEY,TreeIc_KEY,new DBTreeData(Temp1));
- Temp2.Printf(_("This Key is used in the following Tables : %s"),((ct_BrowserDB->pTableInf+x)->pColInf+y)->PkTableName);
- Funkt = AppendItem(Docu,Temp2,TreeIc_DocClosed,TreeIc_DocOpen,new DBTreeData("KEY"));
- }
+ Temp1.Printf("TN(%s",(ct_BrowserDB->pTableInf+x)->tableName);
+ //----
+ (ct_BrowserDB->pTableInf+x)->pColInf = (pDoc->db_Br+i_Which)->OnGetColumns((ct_BrowserDB->pTableInf+x)->tableName,(ct_BrowserDB->pTableInf+x)->numCols,FALSE);
+ //----
+ if ((ct_BrowserDB->pTableInf+x)->pColInf)
+ {
+ if (TableType == 1) // Table
+ {
+ Temp0.Printf(_("Table-Name(%s) with (%d)Columns ; Remarks(%s)"), (ct_BrowserDB->pTableInf+x)->tableName,
+ (ct_BrowserDB->pTableInf+x)->numCols,(ct_BrowserDB->pTableInf+x)->tableRemarks);
+ Folder = AppendItem(Root,Temp0,TreeIc_TAB,TreeIc_TAB, new DBTreeData(Temp1));
+ }
+ if (TableType == 2) // View
+ {
+ Temp0.Printf(_("View-Name(%s) with (%d)Columns ; Remarks(%s)"), (ct_BrowserDB->pTableInf+x)->tableName,
+ (ct_BrowserDB->pTableInf+x)->numCols,(ct_BrowserDB->pTableInf+x)->tableRemarks);
+ Folder = AppendItem(Root,Temp0,TreeIc_VIEW,TreeIc_VIEW, new DBTreeData(Temp1));
+ }
+ for (y=0;y<(ct_BrowserDB->pTableInf+x)->numCols;y++)
+ {
+ Temp1.Printf("FN(%s",((ct_BrowserDB->pTableInf+x)->pColInf+y)->colName);
+ // Here is where we find out if the Column is a Primary / Foreign Key
+ if (((ct_BrowserDB->pTableInf+x)->pColInf+y)->PkCol != 0) // Primary Key
+ {
+ Docu = AppendItem(Folder,((ct_BrowserDB->pTableInf+x)->pColInf+y)->colName,TreeIc_KEY,TreeIc_KEY,new DBTreeData(Temp1));
+ Temp2.Printf(_("This Key is used in the following Tables : %s"),((ct_BrowserDB->pTableInf+x)->pColInf+y)->PkTableName);
+ Funkt = AppendItem(Docu,Temp2,TreeIc_DocClosed,TreeIc_DocOpen,new DBTreeData("KEY"));
+ }
else
- if (((ct_BrowserDB->pTableInf+x)->pColInf+y)->FkCol != 0) // Foreign Key
- {
- Docu = AppendItem(Folder,((ct_BrowserDB->pTableInf+x)->pColInf+y)->colName,TreeIc_KEYF,TreeIc_KEYF,new DBTreeData(Temp1));
- Temp2.Printf(_("This Foreign Key comes from the following Table : %s"),((ct_BrowserDB->pTableInf+x)->pColInf+y)->FkTableName);
- Funkt = AppendItem(Docu,Temp2,TreeIc_DocClosed,TreeIc_DocOpen,new DBTreeData("KEYF"));
- }
- else
- Docu = AppendItem(Folder,((ct_BrowserDB->pTableInf+x)->pColInf+y)->colName,TreeIc_COL,TreeIc_COL,new DBTreeData(Temp1));
- SQL_TYPE.Printf(_("SQL_C_???? (%d)"),((ct_BrowserDB->pTableInf+x)->pColInf+y)->sqlDataType);
- DB_TYPE.Printf(_("DB_DATA_TYPE_???? (%d)"),((ct_BrowserDB->pTableInf+x)->pColInf+y)->dbDataType);
- for (i=1;i<=(pDoc->db_Br+i_Which)->i_SqlTyp[0];i++)
- {
- if (((ct_BrowserDB->pTableInf+x)->pColInf+y)->sqlDataType == (pDoc->db_Br+i_Which)->i_SqlTyp[i])
- {
- SQL_TYPE.Printf("%s(%d) ; ",(pDoc->db_Br+i_Which)->s_SqlTyp[i].c_str(),(pDoc->db_Br+i_Which)->i_SqlTyp[i]);
- }
- } // for (i=1;i<=i_SqlTyp[0];i++)
- for (i=1;i<=(pDoc->db_Br+i_Which)->i_dbTyp[0];i++)
- {
- if (((ct_BrowserDB->pTableInf+x)->pColInf+y)->dbDataType == (pDoc->db_Br+i_Which)->i_dbTyp[i])
- {
- DB_TYPE.Printf("%s(%d)",(pDoc->db_Br+i_Which)->s_dbTyp[i].c_str(),(pDoc->db_Br+i_Which)->i_dbTyp[i]);
- }
- } // for (i=1;i<=i_dbTyp[0];i++)
- SQL_TYPE += DB_TYPE;
- Funkt = AppendItem(Docu,SQL_TYPE,TreeIc_DocClosed,TreeIc_DocOpen,new DBTreeData(SQL_TYPE));
- SQL_TYPE.Printf("%10s %d,%d",((ct_BrowserDB->pTableInf+x)->pColInf+y)->typeName,
- ((ct_BrowserDB->pTableInf+x)->pColInf+y)->columnSize,
- ((ct_BrowserDB->pTableInf+x)->pColInf+y)->decimalDigits);
- Funkt = AppendItem(Docu,SQL_TYPE,TreeIc_DocClosed,TreeIc_DocOpen,new DBTreeData(SQL_TYPE));
- } // for (y=0;y<(ct_BrowserDB->pTableInf+x)->numCols;y++)
- } // if ((ct_BrowserDB->pTableInf+x)->pColInf)
- else
- Folder = AppendItem(Root,Temp0,TreeIc_FolderClosed,TreeIc_FolderOpen, new DBTreeData(Temp1));
- } // if ((ct_BrowserDB->pTableInf+x)->tableType == "TABLE")
- } // for (x=0;x<ct_BrowserDB->numTables;x++)
- } // if (ct_BrowserDB)
- else
- wxLogMessage(_("\n-E-> DBTree::OnPopulate() : Invalid Catalog Pointer : Failed"));
- wxEndBusyCursor();
- } // if((pDoc->db_Br+i_Which)->Initialize(FALSE))
+ {
+ if (((ct_BrowserDB->pTableInf+x)->pColInf+y)->FkCol != 0) // Foreign Key
+ {
+ Docu = AppendItem(Folder,((ct_BrowserDB->pTableInf+x)->pColInf+y)->colName,TreeIc_KEYF,TreeIc_KEYF,new DBTreeData(Temp1));
+ Temp2.Printf(_("This Foreign Key comes from the following Table : %s"),((ct_BrowserDB->pTableInf+x)->pColInf+y)->FkTableName);
+ Funkt = AppendItem(Docu,Temp2,TreeIc_DocClosed,TreeIc_DocOpen,new DBTreeData("KEYF"));
+ }
+ else
+ Docu = AppendItem(Folder,((ct_BrowserDB->pTableInf+x)->pColInf+y)->colName,TreeIc_COL,TreeIc_COL,new DBTreeData(Temp1));
+ }
+ SQL_TYPE.Printf(_("SQL_C_???? (%d)"),((ct_BrowserDB->pTableInf+x)->pColInf+y)->sqlDataType);
+ DB_TYPE.Printf(_("DB_DATA_TYPE_???? (%d)"),((ct_BrowserDB->pTableInf+x)->pColInf+y)->dbDataType);
+ for (i=1;i<=(pDoc->db_Br+i_Which)->i_SqlTyp[0];i++)
+ {
+ if (((ct_BrowserDB->pTableInf+x)->pColInf+y)->sqlDataType == (pDoc->db_Br+i_Which)->i_SqlTyp[i])
+ {
+ SQL_TYPE.Printf("%s(%d) ; ",(pDoc->db_Br+i_Which)->s_SqlTyp[i].c_str(),(pDoc->db_Br+i_Which)->i_SqlTyp[i]);
+ }
+ } // for (i=1;i<=i_SqlTyp[0];i++)
+ for (i=1;i<=(pDoc->db_Br+i_Which)->i_dbTyp[0];i++)
+ {
+ if (((ct_BrowserDB->pTableInf+x)->pColInf+y)->dbDataType == (pDoc->db_Br+i_Which)->i_dbTyp[i])
+ {
+ DB_TYPE.Printf("%s(%d)",(pDoc->db_Br+i_Which)->s_dbTyp[i].c_str(),(pDoc->db_Br+i_Which)->i_dbTyp[i]);
+ }
+ } // for (i=1;i<=i_dbTyp[0];i++)
+ SQL_TYPE += DB_TYPE;
+ Funkt = AppendItem(Docu,SQL_TYPE,TreeIc_DocClosed,TreeIc_DocOpen,new DBTreeData(SQL_TYPE));
+ SQL_TYPE.Printf("%10s %d,%d",((ct_BrowserDB->pTableInf+x)->pColInf+y)->typeName,
+ ((ct_BrowserDB->pTableInf+x)->pColInf+y)->columnSize,((ct_BrowserDB->pTableInf+x)->pColInf+y)->decimalDigits);
+ Funkt = AppendItem(Docu,SQL_TYPE,TreeIc_DocClosed,TreeIc_DocOpen,new DBTreeData(SQL_TYPE));
+ } // for (y=0;y<(ct_BrowserDB->pTableInf+x)->numCols;y++)
+ } // if ((ct_BrowserDB->pTableInf+x)->pColInf)
+ else
+ Folder = AppendItem(Root,Temp0,TreeIc_FolderClosed,TreeIc_FolderOpen, new DBTreeData(Temp1));
+ } // if ((ct_BrowserDB->pTableInf+x)->tableType == "TABLE" or VIEW)
+ // else
+ // wxLogMessage(_("\n-I-> if ! TABLE or VIEW >%s<"),(ct_BrowserDB->pTableInf+x)->tableType);
+ } // for (x=0;x<ct_BrowserDB->numTables;x++)
+ } // if (ct_BrowserDB)
else
- {
- return 0;
- //wxLogMessage(_("\n-E-> DBTree::OnPopulate() : A valid Pointer could not be created : Failed"));
- }
- //----------------------------------------------------------------------------------------------------------------------------
- Expand(Root);
- //----------------------------------------------------------------------------------------------------------------------------
- popupMenu1 = NULL;
- popupMenu1 = new wxMenu("");
- popupMenu1->Append(DATA_DB, _("Make wxDB.cpp/h "));
- popupMenu1->AppendSeparator();
- popupMenu1->Append(DATA_TABLE_ALL, _("Make all wxTable.cpp/h classes"));
- popupMenu2 = NULL;
- popupMenu2 = new wxMenu("");
- popupMenu2->Append(DATA_SHOW, _("Show Data"));
- popupMenu2->AppendSeparator();
- popupMenu2->Append(DATA_TABLE, _("Make wxTable.cpp/h "));
- //----------------------------------------------------------------------------------------------------------------------------
-
+ wxLogMessage(_("\n-E-> DBTree::OnPopulate() : Invalid Catalog Pointer : Failed"));
+ wxEndBusyCursor();
+ } // if((pDoc->db_Br+i_Which)->Initialize(FALSE))
+ else
+ {
+ wxLogMessage(_("\n-E-> DBTree::OnPopulate() : A valid Pointer could not be created : Failed"));
return 0;
+ }
+ //----------------------------------------------------------------------------------------------------------------------------
+ Expand(Root);
+ //----------------------------------------------------------------------------------------------------------------------------
+ popupMenu1 = NULL;
+ popupMenu1 = new wxMenu("");
+ popupMenu1->Append(DATA_DB, _("Make wxDB.cpp/h "));
+ popupMenu1->AppendSeparator();
+ popupMenu1->Append(DATA_TABLE_ALL, _("Make all wxTable.cpp/h classes"));
+ popupMenu2 = NULL;
+ popupMenu2 = new wxMenu("");
+ popupMenu2->Append(DATA_SHOW, _("Show Data"));
+ popupMenu2->AppendSeparator();
+ popupMenu2->Append(DATA_TABLE, _("Make wxTable.cpp/h "));
+ //----------------------------------------------------------------------------------------------------------------------------
+
+ return 0;
}
//---------------------------------------------------------------------------
void DBTree::OnSelChanged(wxTreeEvent& WXUNUSED(event))
TreeIc_DsnClosed, // dsnclose.ico
TreeIc_DsnOpen, // dsnopen.ico
TreeIc_TAB, // tab.ico
+ TreeIc_VIEW, // view.ico
TreeIc_COL, // col.ico
TreeIc_KEY, // key.ico
TreeIc_KEYF, // keyf.ico
- TreeIc_DocClosed, // d_closed.ico
TreeIc_DocOpen, // d_open.ico
+ TreeIc_DocClosed, // d_closed.ico
TreeIc_FolderClosed, // f_closed.ico
TreeIc_FolderOpen // f_open.ico
};
<TR><TH bgcolor=#FFFFAA><B><IMG SRC="../help.png/key.png"> key.ico / key.xpm</B></TH><TH bgcolor=#FFFFE0><B>dbtree.cpp :<BR> ODBC Primärschlüssel-Spalte in eine Tablle</B></FONT></TH></TR>
<TR><TH bgcolor=#CCFFCC><B><IMG SRC="../help.png/keyf.png"> keyf.ico / keyf.xpm</B></TH><TH><B>dbtree.cpp :<BR> ODBC Fremdschlüssel-Spalte in eine Tablle</B></FONT></TH></TR>
<TR><TH bgcolor=#FFFFAA><B><IMG SRC="../help.png/logo.png"> logo.ico / logo.xpm</B></TH><TH bgcolor=#FFFFE0><B>Programm Logo</B></FONT></TH></TR>
- <TR><TH bgcolor=#FFFFAA><B><IMG SRC="../help.png/pgmctrl.png"> pgmctrl.ico / pgmctrl.xpm / pgmctrl.bmp</B></TH><TH bgcolor=#FFFFE0><B>pgmctrl.cpp :<BR> Tab Bitmap</B></FONT></TH></TR>
- <TR><TH bgcolor=#CCFFCC><B><IMG SRC="../help.png/tab.png"> tab.ico / tab.xpm</B></TH><TH><B>dbtree.cpp :<BR> ODBC Tabelle</B></FONT></TH></TR>
+ <TR><TH bgcolor=#CCFFCC><B><IMG SRC="../help.png/pgmctrl.png"> pgmctrl.ico / pgmctrl.xpm / pgmctrl.bmp</B></TH><TH bgcolor=#FFFFE0><B>pgmctrl.cpp :<BR> Tab Bitmap</B></FONT></TH></TR>
+ <TR><TH bgcolor=#FFFFAA><B><IMG SRC="../help.png/tab.png"> tab.ico / tab.xpm</B></TH><TH><B>dbtree.cpp :<BR> ODBC Table</B></FONT></TH></TR>
+ <TR><TH bgcolor=#CCFFCC><B><IMG SRC="../help.png/view.png"> view.ico / view.xpm</B></TH><TH><B>dbtree.cpp :<BR> ODBC View</B></FONT></TH></TR>
</TR></TBODY></TABLE>
<TABLE border=1><B><TBODY><TR bgcolor=#FFF777>
<TH><B><A HREF="icons.htm">Alle andere Pictograms werden nicht in DBBrowser verwendet.<BR>(sind .png Files)</A></B></FONT></TH>
<TABLE border=1><B><TBODY><TR bgcolor=#CCFFFF>
<TH><B><H3><IMG SRC="../help.png/logo.png"> DBBrowser : Was Funktionert nicht ?</H3><BR>(deutsch)</B></FONT></TH>
</TABLE></TBODY></TR><P>
- <B>Stand: 2000-01-22.01-mj10777</B>
+ <B>Stand: 2000-02-04.01-mj10777</B>
<!----------------------------------------------------------------------------------------------------------->
<HR><TABLE border=1><B><TBODY>
<TR><TH bgcolor=#CCFFFF><B>Allgemein</B></TH></TR>
<!-------------------------------------->
<TABLE border=1><B><TBODY><TR>
<TR><TH bgcolor=#FFFFAA><B>Problem :</B></TH><TH bgcolor=#FFFFE0><B>Warum Funktioniert die Aktulisierungs-Taste (F5) nicht?</B></FONT></TH></TR>
- <TR><TH bgcolor=#CCFFCC><B>Lösung :</B></TH><TH><B>unbekannt</B></FONT></TH></TR>
+ <TR><TH bgcolor=#CCFFCC><B>Solution :</B></TH><TH><B>pDoc->p_Hilfe-> Display("GUp_Mask_Kunden.htm#Sonstiges");</B></FONT></TH></TR>
</TR></TBODY></TABLE><P>
<!-------------------------------------->
<TABLE border=1><B><TBODY><TR>
</TBODY></TABLE>
<TABLE border=1><B><TBODY><TR>
<TR><TH bgcolor=#FFFFAA><B>Problem :</B></TH><TH bgcolor=#FFFFE0><B>Wenn wxGrid in wxPaggedWindows verwendet wird, funktioniert die Scrollbars nicht.</B></FONT></TH></TR>
- <TR><TH bgcolor=#CCFFCC><B>Lösung :</B></TH><TH><B>unbekannt</B></FONT></TH></TR>
+ <TR><TH bgcolor=#CCFFCC><B>Lösung :</B></TH><TH><B>04.02.2000 : mit neue Grid Version gelößt</B></FONT></TH></TR>
+ </TR></TBODY></TABLE><P>
+<!----------------------------------------------------------------------------------------------------------->
+ <HR><TABLE border=1><B><TBODY>
+ <TR><TH bgcolor=#CCFFFF><B>wxGrid (newe Version) 04.02.2000</B></TH></TR>
+ </TBODY></TABLE>
+ <TABLE border=1><B><TBODY><TR>
+ <TR><TH bgcolor=#FFFFAA><B>Problem :</B></TH><TH bgcolor=#FFFFE0><B>Often : Error: wxGrid::CreateGrid(numRows, numCols) called more than once</B></FONT></TH></TR>
+ <TR><TH bgcolor=#CCFFCC><B>Solution :</B></TH><TH><B>in Arbeit</B></FONT></TH></TR>
</TR></TBODY></TABLE><P>
<!----------------------------------------------------------------------------------------------------------->
<HR><TABLE border=1><B><TBODY>
<TR><TH bgcolor=#FFFFAA><B><IMG SRC="../help.png/key.png"> key.ico / key.xpm</B></TH><TH bgcolor=#FFFFE0><B>dbtree.cpp :<BR> ODBC Primary-Key Column in a Table</B></FONT></TH></TR>
<TR><TH bgcolor=#CCFFCC><B><IMG SRC="../help.png/keyf.png"> keyf.ico / keyf.xpm</B></TH><TH><B>dbtree.cpp :<BR> ODBC Foreign-Key Column in a Table</B></FONT></TH></TR>
<TR><TH bgcolor=#FFFFAA><B><IMG SRC="../help.png/logo.png"> logo.ico / logo.xpm</B></TH><TH bgcolor=#FFFFE0><B>Programm Logo</B></FONT></TH></TR>
- <TR><TH bgcolor=#FFFFAA><B><IMG SRC="../help.png/pgmctrl.png"> pgmctrl.ico / pgmctrl.xpm / pgmctrl.bmp</B></TH><TH bgcolor=#FFFFE0><B>pgmctrl.cpp :<BR> Tab Bitmap</B></FONT></TH></TR>
- <TR><TH bgcolor=#CCFFCC><B><IMG SRC="../help.png/tab.png"> tab.ico / tab.xpm</B></TH><TH><B>dbtree.cpp :<BR> ODBC Table</B></FONT></TH></TR>
+ <TR><TH bgcolor=#CCFFCC><B><IMG SRC="../help.png/pgmctrl.png"> pgmctrl.ico / pgmctrl.xpm / pgmctrl.bmp</B></TH><TH bgcolor=#FFFFE0><B>pgmctrl.cpp :<BR> Tab Bitmap</B></FONT></TH></TR>
+ <TR><TH bgcolor=#FFFFAA><B><IMG SRC="../help.png/tab.png"> tab.ico / tab.xpm</B></TH><TH><B>dbtree.cpp :<BR> ODBC Table</B></FONT></TH></TR>
+ <TR><TH bgcolor=#CCFFCC><B><IMG SRC="../help.png/view.png"> view.ico / view.xpm</B></TH><TH><B>dbtree.cpp :<BR> ODBC View</B></FONT></TH></TR>
</TR></TBODY></TABLE>
<TABLE border=1><B><TBODY><TR bgcolor=#FFF777>
<TH><B><A HREF="pictograms.htm">All other Pictograms are not used in DBBrowser<BR>(they are .png files)</A></B></FONT></TH>
<TABLE border=1><B><TBODY><TR bgcolor=#CCFFFF>
<TH><B><H3><IMG SRC="../help.png/logo.png"> DBBrowser : What does not Work ?</H3><BR>(English)</B></FONT></TH>
</TABLE></TBODY></TR><P>
- <B>Stand: 2000-01-22.01-mj10777</B>
+ <B>Stand: 2000-02-04.01-mj10777</B>
<!-------------------------------------->
<HR><TABLE border=1><B><TBODY>
<TR><TH bgcolor=#CCFFFF><B>General</B></TH></TR>
<!-------------------------------------->
<TABLE border=1><B><TBODY><TR>
<TR><TH bgcolor=#FFFFAA><B>Problem :</B></TH><TH bgcolor=#FFFFE0><B>How can Help be called and a certin Page be opened (Context Help)</B></FONT></TH></TR>
- <TR><TH bgcolor=#CCFFCC><B>Solution :</B></TH><TH><B>unknown</B></FONT></TH></TR>
+ <TR><TH bgcolor=#CCFFCC><B>Solution :</B></TH><TH><B>p_Help-> Display("GUp_Mask_Kunden.htm#Sonstiges");</B></FONT></TH></TR>
</TR></TBODY></TABLE><P>
<!-------------------------------------->
<TABLE border=1><B><TBODY><TR>
<TR><TH bgcolor=#FFFFAA><B>Problem :</B></TH><TH bgcolor=#FFFFE0><B>Why doesn't the Refresh-Button (F5) work?</B></FONT></TH></TR>
- <TR><TH bgcolor=#CCFFCC><B>Lvsung :</B></TH><TH><B>unbekannt</B></FONT></TH></TR>
+ <TR><TH bgcolor=#CCFFCC><B>solved :</B></TH><TH><B>unbekannt</B></FONT></TH></TR>
</TR></TBODY></TABLE><P>
<!-------------------------------------->
<TABLE border=1><B><TBODY><TR>
</TR></TBODY></TABLE><P>
<!----------------------------------------------------------------------------------------------------------->
<HR><TABLE border=1><B><TBODY>
- <TR><TH bgcolor=#CCFFFF><B>wxGrid (new Versions)</B></TH></TR>
+ <TR><TH bgcolor=#CCFFFF><B>wxGrid (new Version)</B></TH></TR>
</TBODY></TABLE>
<TABLE border=1><B><TBODY><TR>
<TR><TH bgcolor=#FFFFAA><B>Problem :</B></TH><TH bgcolor=#FFFFE0><B>When wxGrid is used in wxPaggedWindows, the Scrollbars do not work.</B></FONT></TH></TR>
+ <TR><TH bgcolor=#CCFFCC><B>Solution :</B></TH><TH><B>04.02.2000 : This has been solved with the new code.</B></FONT></TH></TR>
+ </TR></TBODY></TABLE><P>
+<!----------------------------------------------------------------------------------------------------------->
+ <HR><TABLE border=1><B><TBODY>
+ <TR><TH bgcolor=#CCFFFF><B>wxGrid (new Version) 04.02.2000</B></TH></TR>
+ </TBODY></TABLE>
+ <TABLE border=1><B><TBODY><TR>
+ <TR><TH bgcolor=#FFFFAA><B>Problem :</B></TH><TH bgcolor=#FFFFE0><B>Often : Error: wxGrid::CreateGrid(numRows, numCols) called more than once</B></FONT></TH></TR>
<TR><TH bgcolor=#CCFFCC><B>Solution :</B></TH><TH><B>unknown</B></FONT></TH></TR>
</TR></TBODY></TABLE><P>
<!----------------------------------------------------------------------------------------------------------->
projects / wxWidgets.git / commitdiff
