| | 1 | <!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN"> |
| | 2 | <HTML><HEAD><TITLE>DBBrowser Help : Remstar ODBC Classes</TITLE></HEAD> |
| | 3 | <BODY BGCOLOR=#C6DFC6><CENTER><IMG SRC="../help.png/logo.png" WIDTH=17 HEIGHT=18></CENTER><BR><CENTER><B>DBBrowser<BR>Mark Johnson, Berlin Germany<BR>mj10777@gmx.net</B><HR></CENTER> |
| | 4 | <!-----------------------------------------------------------------------------------------------------------> |
| | 5 | <TABLE BORDER=1><TBODY><TR BGCOLOR=#CCFFFF> |
| | 6 | <TH><B><H3><IMG SRC="../help.png/remstar.png" WIDTH=125 HEIGHT=123><BR>Remstar ODBC Classes :<BR>The new wxDB::GetColumns() Function<BR>Description</H3><BR>(English)</B></TH> |
| | 7 | </TR></TBODY></TABLE><P> |
| | 8 | <B>Stand: 2000-01-23.01-mj10777</B><HR> |
| | 9 | <!--------------------------------------------------------------> |
| | 10 | <TABLE BORDER=1><TBODY><TR> |
| | 11 | <TH BGCOLOR=#CCFFFF><B>There are 2 new wxDB Functions : </B></TH> |
| | 12 | </TR></TBODY></TABLE> |
| | 13 | <!--------------------------------> |
| | 14 | <A NAME="GETCOLUMNS"> |
| | 15 | <TABLE BORDER=1><TBODY><TR> |
| | 16 | <TH BGCOLOR=#FFFFAA><B><A HREF="#GETCOLUMNS">wxColInf *wxDB::GetColumns(char *tableName, int *numCols, const char *userID)</A></B></TH> |
| | 17 | </TR></TBODY></TABLE> |
| | 18 | <TABLE BORDER=1><TBODY><TR> |
| | 19 | <TH BGCOLOR=#FFFFE0><B>This Function stores all (<I><FONT color=#FF0000>int numCols) information from the Table (<I><FONT color=#FF0000>char *tableName</I>).<BR>It returns the result in a <A HREF="#WXCOLINF">wxColInf</A> Stucture (Class)</B></TH> |
| | 20 | </TR></TBODY></TABLE> |
| | 21 | <!--------------------------------> |
| | 22 | <A NAME="GETKEYFIELDS"><P> |
| | 23 | <TABLE BORDER=1><TBODY><TR> |
| | 24 | <TH BGCOLOR=#FFFFAA><B><A HREF="#GETKEYFIELDS">int wxDB::GetKeyFields(char *tableName, wxColInf* colInf,int noCols)</A></B></TH> |
| | 25 | </TR></TBODY></TABLE> |
| | 26 | <TABLE BORDER=1><TBODY><TR> |
| | 27 | <TH BGCOLOR=#FFFFE0><B>Tries to find out if any (<I><FONT color=#FF0000>int noCols</I>) of the columns (<I><FONT color=#FF0000>wxColInf* colInf</I>)<BR> in the Table (<I><FONT color=#FF0000>char *tableName</I>) are <IMG SRC="../help.png/key.png" WIDTH=15 HEIGHT=16> Primary or <IMG SRC="../help.png/keyf.png" WIDTH=15 HEIGHT=16> Foreign Keys.<HR>This Function is only called from GetColumns().</B></TH> |
| | 28 | </TR></TBODY></TABLE><HR> |
| | 29 | <!-----------------------------------------------------------------------------------------------------------> |
| | 30 | <TABLE BORDER=1><TBODY><TR> |
| | 31 | <TH BGCOLOR=#CCFFFF><B>There are 4 new wxDB Classes (Structures) : </B></TH> |
| | 32 | </TR></TBODY></TABLE> |
| | 33 | <!--------------------------------> |
| | 34 | <A NAME="WXDBINF"><P> |
| | 35 | <TABLE BORDER=1><TBODY><TR> |
| | 36 | <TH BGCOLOR=#FFFFAA><B><A HREF="#WXDBINF">wxDbInf</A></B></TH> |
| | 37 | </TR></TBODY></TABLE> |
| | 38 | <TABLE BORDER=1><TBODY><TR> |
| | 39 | <TH BGCOLOR=#FFFFE0> |
| | 40 | <B>This Class stores all ODBC-Information for a Database :<HR> |
| | 41 | Catalog Entry (<I><FONT color=#FF0000>char catalog[128+1]</I>),<BR> |
| | 42 | Schema (<I><FONT color=#FF0000>char schema[128+1]</I>)<BR> |
| | 43 | the number of Tables found(<I><FONT color=#FF0000>int numTables</I>)<BR> |
| | 44 | and a Pointer (<I><A HREF="#WXTABLEINF">wxTableInf*</A><FONT color=#FF0000> pTableInf</I>) Structure is stored. |
| | 45 | </B></TH> |
| | 46 | </TR></TBODY></TABLE> |
| | 47 | <!--------------------------------> |
| | 48 | <A NAME="WXTABLEINF"><P> |
| | 49 | <TABLE BORDER=1><TBODY><TR> |
| | 50 | <TH BGCOLOR=#FFFFAA><B><A HREF="#WXTABLEINF">wxTableInf</A></B></TH> |
| | 51 | </TR></TBODY></TABLE> |
| | 52 | <TABLE BORDER=1><TBODY><TR> |
| | 53 | <TH BGCOLOR=#FFFFE0> |
| | 54 | <B>This Class stores all ODBC-Information about a Table :<HR> |
| | 55 | Table-Name (<I><FONT color=#FF0000>char tableName[DB_MAX_TABLE_NAME_LEN+1]</I>),<BR> |
| | 56 | Table-Type (<I><FONT color=#FF0000>char tableType[254+1]</I>) - "TABLE", "SYSTEM TABLE" etc. ,<BR> |
| | 57 | Table-Remarks (<I><FONT color=#FF0000>char tableRemarks[254+1]</I>),<BR> |
| | 58 | the number of Columns found(<I><FONT color=#FF0000>int numCols</I>)<BR> |
| | 59 | and a Pointer (<I><A HREF="#WXCOLINF">wxColInf*</A><FONT color=#FF0000> pColInf</I>) Structure is stored. |
| | 60 | </B></TH> |
| | 61 | </TR></TBODY></TABLE> |
| | 62 | <!--------------------------------> |
| | 63 | <A NAME="WXCOLINF"><P> |
| | 64 | <TABLE BORDER=1><TBODY><TR> |
| | 65 | <TH BGCOLOR=#FFFFAA><B><A HREF="#WXCOLINF">wxColInf</A></B></TH> |
| | 66 | </TR></TBODY></TABLE> |
| | 67 | <TABLE BORDER=1><TBODY><TR> |
| | 68 | <TH BGCOLOR=#FFFFE0> |
| | 69 | <B>This Class stores all ODBC-Information about a Column :<HR> |
| | 70 | Catalog Entry (<I><FONT color=#FF0000>char catalog[128+1]</I>),<BR> |
| | 71 | Schema (<I><FONT color=#FF0000>char schema[128+1]</I>)<BR> |
| | 72 | Table-Name (<I><FONT color=#FF0000>char tableName[DB_MAX_TABLE_NAME_LEN+1]</I>),<BR> |
| | 73 | Column-Name (<I><FONT color=#FF0000>char colName[DB_MAX_COLUMN_NAME_LEN+1]</I>),<BR> |
| | 74 | Datatype (from SQL) (<I><FONT color=#FF0000>SWORD sqlDataType</I>),<BR> |
| | 75 | Data-Name(from SQL) (<I><FONT color=#FF0000>char typeName[128+1]</I>),<BR> |
| | 76 | Column size(from SQL) (<I><FONT color=#FF0000>SWORD columnSize</I>),<BR> |
| | 77 | Buffer length(from SQL) (<I><FONT color=#FF0000>SWORD bufferLength</I>),<BR> |
| | 78 | Decimal digits(from SQL) (<I><FONT color=#FF0000>short decimalDigits</I>),<BR> |
| | 79 | numPrecRadix (from SQL) (<I><FONT color=#FF0000>short numPrecRadix</I>),<BR> |
| | 80 | Nullable (from SQL) (<I><FONT color=#FF0000>short nullable</I>),<BR> |
| | 81 | Remarks (<I><FONT color=#FF0000>char remarks[254+1]</I>),<BR> |
| | 82 | Datatype (from wxDB) (<I><FONT color=#FF0000>int dbDataType</I>),<BR> |
| | 83 | Primary-Key (<I><FONT color=#FF0000>int PkCol</I>) 0=No; 1= First Key, 2 = Second Key etc.,<BR> |
| | 84 | Tables that use this Key as a Foreign Key(<I><FONT color=#FF0000>char PkTableName[DB_MAX_TABLE_NAME_LEN+1]</I>),<BR> |
| | 85 | Foreign-Key (<I><FONT color=#FF0000>int FkCol</I>) 0=No; 1= First Key, 2 = Second Key etc.,<BR> |
| | 86 | Table-Name where this Foreign-Key is Primary Key(<I><FONT color=#FF0000>char FkTableName[DB_MAX_TABLE_NAME_LEN+1]</I>),<BR> |
| | 87 | and a Pointer (<I><A HREF="#WXCOLFOR">wxColFor*</A><FONT color=#FF0000> pColFor</I>) Structure is stored. |
| | 88 | </B></TH> |
| | 89 | </TR></TBODY></TABLE> |
| | 90 | <!--------------------------------> |
| | 91 | <A NAME="WXCOLFOR"><P> |
| | 92 | <TABLE BORDER=1><TBODY><TR> |
| | 93 | <TH BGCOLOR=#FFFFAA><B><A HREF="#WXCOLFOR">wxColFor</A></B></TH> |
| | 94 | </TR></TBODY></TABLE> |
| | 95 | <TABLE BORDER=1><TBODY><TR> |
| | 96 | <TH BGCOLOR=#FFFFE0> |
| | 97 | <B>This Class stores how this Column should be formated in a String : <HR> |
| | 98 | Output String (<I><FONT color=#FF0000>wxString s_Field</I>),<BR> |
| | 99 | Formatted Objects (TIMESTAMP needs 7) (<I><FONT color=#FF0000>wxString s_Format[7]</I>),<BR> |
| | 100 | Formatted Objects (<I><FONT color=#FF0000>wxString s_Menge[7]</I>),<BR> |
| | 101 | Formatted Objects (TT MM YYYY HH MM SS m) (<I><FONT color=#FF0000>int i_Menge[7]</I>),<BR> |
| | 102 | National (0=timestamp,1=EU,2=UK,3=International,4=US)<I><FONT color=#FF0000>int i_Nation</I>),<BR> |
| | 103 | Datatype (from wxDB) (<I><FONT color=#FF0000>int I_dbDataType</I>),<BR> |
| | 104 | Datatype (from SQL) (<I><FONT color=#FF0000>SWORD i_sqlDataType</I>),<HR> |
| | 105 | int Format(int Nation, int dbDataType,SWORD sqlDataType,short columnSize,short decimalDigits);<BR> |
| | 106 | The Formatted Objects receive Standard Values and Format() is called.<BR> |
| | 107 | The Programmers can, if they want something special , change these Values and call Format() again |
| | 108 | </B></TH> |
| | 109 | </TR></TBODY></TABLE> |
| | 110 | <TABLE BORDER=1><TBODY><TR> |
| | 111 | <TH BGCOLOR=#FFBBBB><B>This class is most definitely very much underdeveloped !<BR>It was made so that the DBGrid could be realised.<BR>Changes here are probable. (Suggestions welcomed)</B></TH> |
| | 112 | </TR></TBODY></TABLE><P> |
| | 113 | <!-----------------------------------------------------------------------------------------------------------> |
| | 114 | <TABLE BORDER=1><TBODY><TR> |
| | 115 | <TH BGCOLOR=#FFF777><B>Well now, <A HREF="getcolsh.htm">that makes everything clear</A> does't it?</B></TH> |
| | 116 | </TR></TBODY></TABLE><HR> |
| | 117 | <!-----------------------------------------------------------------------------------------------------------> |
| | 118 | </BODY></HTML> |
projects / wxWidgets.git / blame_incremental