X-Git-Url: https://git.saurik.com/wxWidgets.git/blobdiff_plain/b5ffecfc985136771bb521074c0f46a07894e62e..94e2ed3b8db0220160c0b939782cd46914ec073a:/demos/dbbrowse/help.std/getcol.htm?ds=sidebyside diff --git a/demos/dbbrowse/help.std/getcol.htm b/demos/dbbrowse/help.std/getcol.htm index d1bc4c879a..c56639b422 100644 --- a/demos/dbbrowse/help.std/getcol.htm +++ b/demos/dbbrowse/help.std/getcol.htm @@ -1,118 +1,118 @@ <!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN"> <HTML><HEAD><TITLE>DBBrowser Help : Remstar ODBC Classes</TITLE></HEAD> -<BODY BGCOLOR=#C6DFC6><CENTER><IMG SRC="../help.png/logo.png"></CENTER><BR><CENTER><B>DBBrowser<BR>Mark Johnson, Berlin Germany<BR>mj10777@gmx.net</B><HR></CENTER> +<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> <!-----------------------------------------------------------------------------------------------------------> - <TABLE border=1><B><TBODY><TR bgcolor=#CCFFFF> - <TH><B><H3><IMG SRC="../help.png/remstar.png"><BR>Remstar ODBC Classes :<BR>The new wxDB::GetColumns() Function<BR>Description</H3><BR>(English)</B></FONT></TH> - </TABLE></TBODY></TR><P> + <TABLE BORDER=1><TBODY><TR BGCOLOR=#CCFFFF> + <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> + </TR></TBODY></TABLE><P> <B>Stand: 2000-01-23.01-mj10777</B><HR> <!--------------------------------------------------------------> - <TABLE border=1><B><TBODY> - <TR><TH bgcolor=#CCFFFF><B>There are 2 new wxDB Functions : </B></TH></TR> - </TBODY></TABLE> + <TABLE BORDER=1><TBODY><TR> + <TH BGCOLOR=#CCFFFF><B>There are 2 new wxDB Functions : </B></TH> + </TR></TBODY></TABLE> <!--------------------------------> <A NAME="GETCOLUMNS"> - <TABLE border=1><B><TBODY><TR> - <TR><TH bgcolor=#FFFFAA><B><A HREF="#GETCOLUMNS">wxColInf *wxDB::GetColumns(char *tableName, int *numCols, const char *userID)</A></B></FONT></TH></TR> - </TBODY></TABLE> - <TABLE border=1><B><TBODY><TR> - <TR><TH bgcolor=#FFFFE0><B>This Function stores all (<I><FONT color=#FF0000>int numCols</FONT>) information from the Table (<I><FONT color=#FF0000>char *tableName</FONT></I>).<BR>It returns the result in a <A HREF="#WXCOLINF">wxColInf</A> Stucture (Class)</B></FONT></TH></TR> - </TBODY></TABLE> + <TABLE BORDER=1><TBODY><TR> + <TH BGCOLOR=#FFFFAA><B><A HREF="#GETCOLUMNS">wxColInf *wxDB::GetColumns(char *tableName, int *numCols, const char *userID)</A></B></TH> + </TR></TBODY></TABLE> + <TABLE BORDER=1><TBODY><TR> + <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> + </TR></TBODY></TABLE> <!--------------------------------> <A NAME="GETKEYFIELDS"><P> - <TABLE border=1><B><TBODY><TR> - <TR><TH bgcolor=#FFFFAA><B><A HREF="#GETKEYFIELDS">int wxDB::GetKeyFields(char *tableName, wxColInf* colInf,int noCols)</A></B></FONT></TH></TR> - </TBODY></TABLE> - <TABLE border=1><B><TBODY><TR> - <TR><TH bgcolor=#FFFFE0><B>Tries to find out if any (<I><FONT color=#FF0000>int noCols</FONT></I>) of the columns (<I><FONT color=#FF0000>wxColInf* colInf</FONT></I>)<BR> in the Table (<I><FONT color=#FF0000>char *tableName</FONT></I>) are <IMG SRC="../help.png/key.png"> Primary or <IMG SRC="../help.png/keyf.png"> Foreign Keys.<HR>This Function is only called from GetColumns().</B></FONT></TH></TR> - </TBODY></TABLE><HR> + <TABLE BORDER=1><TBODY><TR> + <TH BGCOLOR=#FFFFAA><B><A HREF="#GETKEYFIELDS">int wxDB::GetKeyFields(char *tableName, wxColInf* colInf,int noCols)</A></B></TH> + </TR></TBODY></TABLE> + <TABLE BORDER=1><TBODY><TR> + <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> + </TR></TBODY></TABLE><HR> <!-----------------------------------------------------------------------------------------------------------> - <TABLE border=1><B><TBODY> - <TR><TH bgcolor=#CCFFFF><B>There are 4 new wxDB Classes (Structures) : </B></TH></TR> - </TBODY></TABLE> + <TABLE BORDER=1><TBODY><TR> + <TH BGCOLOR=#CCFFFF><B>There are 4 new wxDB Classes (Structures) : </B></TH> + </TR></TBODY></TABLE> <!--------------------------------> <A NAME="WXDBINF"><P> - <TABLE border=1><B><TBODY><TR> - <TR><TH bgcolor=#FFFFAA><B><A HREF="#WXDBINF">wxDbInf</A></B></FONT></TH></TR> - </TBODY></TABLE> - <TABLE border=1><B><TBODY><TR> - <TR><TH bgcolor=#FFFFE0> - <B>This Class stores all ODBC-Information for a Database :<HR> - Catalog Entry (<I><FONT color=#FF0000>char catalog[128+1]</I></FONT>),<BR> - Schema (<I><FONT color=#FF0000>char schema[128+1]</I></FONT>)<BR> - the number of Tables found(<I><FONT color=#FF0000>int numTables</I></FONT>)<BR> - and a Pointer (<I><A HREF="#WXTABLEINF">wxTableInf*</A><FONT color=#FF0000> pTableInf</FONT></I>) Structure is stored. - </B></FONT></TH></TR> - </TBODY></TABLE> + <TABLE BORDER=1><TBODY><TR> + <TH BGCOLOR=#FFFFAA><B><A HREF="#WXDBINF">wxDbInf</A></B></TH> + </TR></TBODY></TABLE> + <TABLE BORDER=1><TBODY><TR> + <TH BGCOLOR=#FFFFE0> + <B>This Class stores all ODBC-Information for a Database :<HR> + Catalog Entry (<I><FONT color=#FF0000>char catalog[128+1]</I>),<BR> + Schema (<I><FONT color=#FF0000>char schema[128+1]</I>)<BR> + the number of Tables found(<I><FONT color=#FF0000>int numTables</I>)<BR> + and a Pointer (<I><A HREF="#WXTABLEINF">wxTableInf*</A><FONT color=#FF0000> pTableInf</I>) Structure is stored. + </B></TH> + </TR></TBODY></TABLE> <!--------------------------------> <A NAME="WXTABLEINF"><P> - <TABLE border=1><B><TBODY><TR> - <TR><TH bgcolor=#FFFFAA><B><A HREF="#WXTABLEINF">wxTableInf</A></B></FONT></TH></TR> - </TBODY></TABLE> - <TABLE border=1><B><TBODY><TR> - <TR><TH bgcolor=#FFFFE0> - <B>This Class stores all ODBC-Information about a Table :<HR> - Table-Name (<I><FONT color=#FF0000>char tableName[DB_MAX_TABLE_NAME_LEN+1]</I></FONT>),<BR> - Table-Type (<I><FONT color=#FF0000>char tableType[254+1]</I></FONT>) - "TABLE", "SYSTEM TABLE" etc. ,<BR> - Table-Remarks (<I><FONT color=#FF0000>char tableRemarks[254+1]</I></FONT>),<BR> - the number of Columns found(<I><FONT color=#FF0000>int numCols</I></FONT>)<BR> - and a Pointer (<I><A HREF="#WXCOLINF">wxColInf*</A><FONT color=#FF0000> pColInf</FONT></I>) Structure is stored. - </B></FONT></TH></TR> - </TBODY></TABLE> + <TABLE BORDER=1><TBODY><TR> + <TH BGCOLOR=#FFFFAA><B><A HREF="#WXTABLEINF">wxTableInf</A></B></TH> + </TR></TBODY></TABLE> + <TABLE BORDER=1><TBODY><TR> + <TH BGCOLOR=#FFFFE0> + <B>This Class stores all ODBC-Information about a Table :<HR> + Table-Name (<I><FONT color=#FF0000>char tableName[DB_MAX_TABLE_NAME_LEN+1]</I>),<BR> + Table-Type (<I><FONT color=#FF0000>char tableType[254+1]</I>) - "TABLE", "SYSTEM TABLE" etc. ,<BR> + Table-Remarks (<I><FONT color=#FF0000>char tableRemarks[254+1]</I>),<BR> + the number of Columns found(<I><FONT color=#FF0000>int numCols</I>)<BR> + and a Pointer (<I><A HREF="#WXCOLINF">wxColInf*</A><FONT color=#FF0000> pColInf</I>) Structure is stored. + </B></TH> + </TR></TBODY></TABLE> <!--------------------------------> <A NAME="WXCOLINF"><P> - <TABLE border=1><B><TBODY><TR> - <TR><TH bgcolor=#FFFFAA><B><A HREF="#WXCOLINF">wxColInf</A></B></FONT></TH></TR> - </TBODY></TABLE> - <TABLE border=1><B><TBODY><TR> - <TR><TH bgcolor=#FFFFE0> - <B>This Class stores all ODBC-Information about a Column :<HR> - Catalog Entry (<I><FONT color=#FF0000>char catalog[128+1]</I></FONT>),<BR> - Schema (<I><FONT color=#FF0000>char schema[128+1]</I></FONT>)<BR> - Table-Name (<I><FONT color=#FF0000>char tableName[DB_MAX_TABLE_NAME_LEN+1]</I></FONT>),<BR> - Column-Name (<I><FONT color=#FF0000>char colName[DB_MAX_COLUMN_NAME_LEN+1]</I></FONT>),<BR> - Datatype (from SQL) (<I><FONT color=#FF0000>SWORD sqlDataType</I></FONT>),<BR> - Data-Name(from SQL) (<I><FONT color=#FF0000>char typeName[128+1]</I></FONT>),<BR> - Column size(from SQL) (<I><FONT color=#FF0000>SWORD columnSize</I></FONT>),<BR> - Buffer length(from SQL) (<I><FONT color=#FF0000>SWORD bufferLength</I></FONT>),<BR> - Decimal digits(from SQL) (<I><FONT color=#FF0000>short decimalDigits</I></FONT>),<BR> - numPrecRadix (from SQL) (<I><FONT color=#FF0000>short numPrecRadix</I></FONT>),<BR> - Nullable (from SQL) (<I><FONT color=#FF0000>short nullable</I></FONT>),<BR> - Remarks (<I><FONT color=#FF0000>char remarks[254+1]</I></FONT>),<BR> - Datatype (from wxDB) (<I><FONT color=#FF0000>int dbDataType</I></FONT>),<BR> - Primary-Key (<I><FONT color=#FF0000>int PkCol</I></FONT>) 0=No; 1= First Key, 2 = Second Key etc.,<BR> - Tables that use this Key as a Foreign Key(<I><FONT color=#FF0000>char PkTableName[DB_MAX_TABLE_NAME_LEN+1]</I></FONT>),<BR> - Foreign-Key (<I><FONT color=#FF0000>int FkCol</I></FONT>) 0=No; 1= First Key, 2 = Second Key etc.,<BR> - Table-Name where this Foreign-Key is Primary Key(<I><FONT color=#FF0000>char FkTableName[DB_MAX_TABLE_NAME_LEN+1]</I></FONT>),<BR> - and a Pointer (<I><A HREF="#WXCOLFOR">wxColFor*</A><FONT color=#FF0000> pColFor</FONT></I>) Structure is stored. - </B></FONT></TH></TR> - </TBODY></TABLE> + <TABLE BORDER=1><TBODY><TR> + <TH BGCOLOR=#FFFFAA><B><A HREF="#WXCOLINF">wxColInf</A></B></TH> + </TR></TBODY></TABLE> + <TABLE BORDER=1><TBODY><TR> + <TH BGCOLOR=#FFFFE0> + <B>This Class stores all ODBC-Information about a Column :<HR> + Catalog Entry (<I><FONT color=#FF0000>char catalog[128+1]</I>),<BR> + Schema (<I><FONT color=#FF0000>char schema[128+1]</I>)<BR> + Table-Name (<I><FONT color=#FF0000>char tableName[DB_MAX_TABLE_NAME_LEN+1]</I>),<BR> + Column-Name (<I><FONT color=#FF0000>char colName[DB_MAX_COLUMN_NAME_LEN+1]</I>),<BR> + Datatype (from SQL) (<I><FONT color=#FF0000>SWORD sqlDataType</I>),<BR> + Data-Name(from SQL) (<I><FONT color=#FF0000>char typeName[128+1]</I>),<BR> + Column size(from SQL) (<I><FONT color=#FF0000>SWORD columnSize</I>),<BR> + Buffer length(from SQL) (<I><FONT color=#FF0000>SWORD bufferLength</I>),<BR> + Decimal digits(from SQL) (<I><FONT color=#FF0000>short decimalDigits</I>),<BR> + numPrecRadix (from SQL) (<I><FONT color=#FF0000>short numPrecRadix</I>),<BR> + Nullable (from SQL) (<I><FONT color=#FF0000>short nullable</I>),<BR> + Remarks (<I><FONT color=#FF0000>char remarks[254+1]</I>),<BR> + Datatype (from wxDB) (<I><FONT color=#FF0000>int dbDataType</I>),<BR> + Primary-Key (<I><FONT color=#FF0000>int PkCol</I>) 0=No; 1= First Key, 2 = Second Key etc.,<BR> + Tables that use this Key as a Foreign Key(<I><FONT color=#FF0000>char PkTableName[DB_MAX_TABLE_NAME_LEN+1]</I>),<BR> + Foreign-Key (<I><FONT color=#FF0000>int FkCol</I>) 0=No; 1= First Key, 2 = Second Key etc.,<BR> + Table-Name where this Foreign-Key is Primary Key(<I><FONT color=#FF0000>char FkTableName[DB_MAX_TABLE_NAME_LEN+1]</I>),<BR> + and a Pointer (<I><A HREF="#WXCOLFOR">wxColFor*</A><FONT color=#FF0000> pColFor</I>) Structure is stored. + </B></TH> + </TR></TBODY></TABLE> <!--------------------------------> <A NAME="WXCOLFOR"><P> - <TABLE border=1><B><TBODY><TR> - <TR><TH bgcolor=#FFFFAA><B><A HREF="#WXCOLFOR">wxColFor</A></B></FONT></TH></TR> - </TBODY></TABLE> - <TABLE border=1><B><TBODY><TR> - <TR><TH bgcolor=#FFFFE0> - <B>This Class stores how this Column should be formated in a String : <HR> - Output String (<I><FONT color=#FF0000>wxString s_Field</I></FONT>),<BR> - Formatted Objects (TIMESTAMP needs 7) (<I><FONT color=#FF0000>wxString s_Format[7]</I></FONT>),<BR> - Formatted Objects (<I><FONT color=#FF0000>wxString s_Menge[7]</I></FONT>),<BR> - Formatted Objects (TT MM YYYY HH MM SS m) (<I><FONT color=#FF0000>int i_Menge[7]</I></FONT>),<BR> - National (0=timestamp,1=EU,2=UK,3=International,4=US)<I><FONT color=#FF0000>int i_Nation</I></FONT>),<BR> - Datatype (from wxDB) (<I><FONT color=#FF0000>int I_dbDataType</I></FONT>),<BR> - Datatype (from SQL) (<I><FONT color=#FF0000>SWORD i_sqlDataType</I></FONT>),<HR> - int Format(int Nation, int dbDataType,SWORD sqlDataType,short columnSize,short decimalDigits);<BR> - The Formatted Objects receive Standard Values and Format() is called.<BR> - The Programmers can, if they want something special , change these Values and call Format() again - </B></FONT></TH></TR> - </TBODY></TABLE> - <TABLE border=1><B><TBODY> - <TR><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)</A></B></TH></TR> - </TBODY></TABLE><P> + <TABLE BORDER=1><TBODY><TR> + <TH BGCOLOR=#FFFFAA><B><A HREF="#WXCOLFOR">wxColFor</A></B></TH> + </TR></TBODY></TABLE> + <TABLE BORDER=1><TBODY><TR> + <TH BGCOLOR=#FFFFE0> + <B>This Class stores how this Column should be formated in a String : <HR> + Output String (<I><FONT color=#FF0000>wxString s_Field</I>),<BR> + Formatted Objects (TIMESTAMP needs 7) (<I><FONT color=#FF0000>wxString s_Format[7]</I>),<BR> + Formatted Objects (<I><FONT color=#FF0000>wxString s_Menge[7]</I>),<BR> + Formatted Objects (TT MM YYYY HH MM SS m) (<I><FONT color=#FF0000>int i_Menge[7]</I>),<BR> + National (0=timestamp,1=EU,2=UK,3=International,4=US)<I><FONT color=#FF0000>int i_Nation</I>),<BR> + Datatype (from wxDB) (<I><FONT color=#FF0000>int I_dbDataType</I>),<BR> + Datatype (from SQL) (<I><FONT color=#FF0000>SWORD i_sqlDataType</I>),<HR> + int Format(int Nation, int dbDataType,SWORD sqlDataType,short columnSize,short decimalDigits);<BR> + The Formatted Objects receive Standard Values and Format() is called.<BR> + The Programmers can, if they want something special , change these Values and call Format() again + </B></TH> + </TR></TBODY></TABLE> + <TABLE BORDER=1><TBODY><TR> + <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> + </TR></TBODY></TABLE><P> <!-----------------------------------------------------------------------------------------------------------> - <TABLE border=1><B><TBODY><TR> - <TR><TH bgcolor=#FFF777><B>Well now, <A HREF="getcolsh.htm">that makes everything clear</A> does't it?</B></FONT></TH></TR> - </TBODY></TABLE><HR> + <TABLE BORDER=1><TBODY><TR> + <TH BGCOLOR=#FFF777><B>Well now, <A HREF="getcolsh.htm">that makes everything clear</A> does't it?</B></TH> + </TR></TBODY></TABLE><HR> <!-----------------------------------------------------------------------------------------------------------> </BODY></HTML>