X-Git-Url: https://git.saurik.com/wxWidgets.git/blobdiff_plain/32d77178d821841cd65fea27b1057ff929ffdee1..645420d872f190409a1451d165aecf98dab22986:/docs/latex/wx/db.tex?ds=sidebyside diff --git a/docs/latex/wx/db.tex b/docs/latex/wx/db.tex index 49b27cd225..65d6f3e267 100644 --- a/docs/latex/wx/db.tex +++ b/docs/latex/wx/db.tex @@ -268,6 +268,47 @@ both types of cursors. The following functions are used in conjunction with the wxDb class. +\func{void}{wxDbCloseConnections}{\void} + +\wxheading{Remarks} + +Closes all cached connections that have been made through use of the +\helpref{wxDbGetConnection}{wxdbfunctions} function. + +NOTE: These connections are closed regardless of whether they are in use +or not. This function should only be called after the program has +finished using the connections and all wxDbTable instances that use any of +the connections have been closed. + +This function performs a \helpref{wxDb::CommitTrans}{wxdbcommittrans} +on the connection before closing it to commit any changes that are still +pending, as well as to avoid any function sequence errors upon closing +each connection. + + +\func{int }{wxDbConnectionsInUse}{\void} + +\wxheading{Remarks} + +Returns a count of how many database connections are currently free ( not +being used) that have been cached through use of the \helpref{wxDbGetConnection}{wxdbfunctions} +function. + + +\func{bool}{wxDbFreeConnection}{\param{wxDb *}{pDb}} + +\wxheading{Remarks} + +Searches the list of cached database connections connection for one matching +the passed in wxDb instance. If found, that cached connection is freed. + +Freeing a connection means that it is marked as available (free) in the +cache of connections, so that a call to \helpref{wxDbGetConnection}{wxdbfunctions} +is able to return a pointer to the wxDb instance for use. Freeing a +connection does NOT close the connection, it only makes the connection +available again. + + \func{wxDb *}{wxDbGetConnection}{\param{wxDbConnectInf *}{pDbConfig}, \param{bool }{FwdOnlyCursors=(bool)wxODBC\_FWD\_ONLY\_CURSORS}} @@ -310,45 +351,10 @@ When exiting the program, call wxDbCloseConnections() to close all the cached connections created by calls to wxDbGetConnection(). -\func{bool}{wxDbFreeConnection}{\param{wxDb *}{pDb}} - -\wxheading{Remarks} - -Searches the list of cached database connections connection for one matching -the passed in wxDb instance. If found, that cached connection is freed. - -Freeing a connection means that it is marked as available (free) in the -cache of connections, so that a call to \helpref{wxDbGetConnection}{wxdbfunctions} -is able to return a pointer to the wxDb instance for use. Freeing a -connection does NOT close the connection, it only makes the connection -available again. - - -\func{void}{wxDbCloseConnections}{\void} - -\wxheading{Remarks} +\func{const wxChar *}{wxDbLogExtendedErrorMsg}{\param{const wxChar *}{userText}, \param{wxDb *}{pDb}, \param{wxChar *}{ErrFile}, \param{int }{ErrLine}} -Closes all cached connections that have been made through use of the -\helpref{wxDbGetConnection}{wxdbfunctions} function. - -NOTE: These connections are closed regardless of whether they are in use -or not. This function should only be called after the program has -finished using the connections and all wxDbTable instances that use any of -the connections have been closed. - -This function performs a \helpref{wxDb::CommitTrans}{wxdbcommittrans} -on the connection before closing it to commit any changes that are still -pending, as well as to avoid any function sequence errors upon closing -each connection. - - -\func{int }{wxDbConnectionsInUse}{\void} - -\wxheading{Remarks} - -Returns a count of how many database connections are currently free ( not -being used) that have been cached through use of the \helpref{wxDbGetConnection}{wxdbfunctions} -function. +Writes a message to the wxLog window (stdout usually) when an internal +error situation occurs. This function only works in DEBUG builds \func{bool}{wxDbSqlLog}{\param{wxDbSqlLogState }{state}, \param{const wxString &}{filename = SQL\_LOG\_FILENAME}} @@ -1598,6 +1604,52 @@ Simply initializes all member variables to a cleared state. Called by the constructor automatically. +\section{\class{wxDbColFor}}\label{wxdbcolfor} + +Beginning support for handling international formatting specifically on dates +and floats. + +\begin{verbatim} + wxString s_Field; // Formated String for Output + wxString s_Format[7]; // Formated Objects - TIMESTAMP has + the biggest (7) + wxString s_Amount[7]; // Formated Objects - amount of + things that can be formatted + int i_Amount[7]; // Formated Objects - + TT MM YYYY HH MM SS m + int i_Nation; // 0 = timestamp + 1 = EU + 2 = UK + 3 = International + 4 = US + int i_dbDataType; // conversion of the 'sqlDataType' + to the generic data type used by + these classes + SWORD i_sqlDataType; +\end{verbatim} + +The constructor for this class initializes all the values to zero or NULL. + +The destructor does nothing at this time. + +Only one function is provided with this class currently: + + +\membersection{wxDbColFor::Format}\label{wxdbcolforformat} + +\func{int }{Format}{\param{int }{Nation}, \param{int }{dbDataType}, +\param{SWORD }{sqlDataType}, \param{short }{columnSize}, +\param{short }{decimalDigits}}\label{wxdbcolforformat} + +Work in progress, and should be inter-related with wxLocale eventually. + + +\membersection{wxDbColFor::Initialize}\label{wxdbcolforinitialize} + +Simply initializes all member variables to a cleared state. Called by +the constructor automatically. + + \section{\class{wxDbColInf}}\label{wxdbcolinf} Used with the \helpref{wxDb::GetColumns}{wxdbgetcolumns} functions for obtaining all retrievable information about a column's definition. @@ -1646,52 +1698,6 @@ the constructor automatically. -\section{\class{wxDbColFor}}\label{wxdbcolfor} - -Beginning support for handling international formatting specifically on dates -and floats. - -\begin{verbatim} - wxString s_Field; // Formated String for Output - wxString s_Format[7]; // Formated Objects - TIMESTAMP has - the biggest (7) - wxString s_Amount[7]; // Formated Objects - amount of - things that can be formatted - int i_Amount[7]; // Formated Objects - - TT MM YYYY HH MM SS m - int i_Nation; // 0 = timestamp - 1 = EU - 2 = UK - 3 = International - 4 = US - int i_dbDataType; // conversion of the 'sqlDataType' - to the generic data type used by - these classes - SWORD i_sqlDataType; -\end{verbatim} - -The constructor for this class initializes all the values to zero or NULL. - -The destructor does nothing at this time. - -Only one function is provided with this class currently: - - -\membersection{wxDbColFor::Format}\label{wxdbcolforformat} - -\func{int }{Format}{\param{int }{Nation}, \param{int }{dbDataType}, -\param{SWORD }{sqlDataType}, \param{short }{columnSize}, -\param{short }{decimalDigits}}\label{wxdbcolforformat} - -Work in progress, and should be inter-related with wxLocale eventually. - - -\membersection{wxDbColFor::Initialize}\label{wxdbcolforinitialize} - -Simply initializes all member variables to a cleared state. Called by -the constructor automatically. - - \section{\class{wxDbConnectInf}}\label{wxdbconnectinf} This class is used for holding the data necessary for connecting to the ODBC @@ -3082,7 +3088,7 @@ this function to commit or rollback the insertion. wxStrcpy(parts->PartName, "10"); wxStrcpy(parts->PartDesc, "Part #10"); parts->Qty = 1000; - RETCODE retcode = parts.Insert(); + RETCODE retcode = parts->Insert(); switch(retcode) { case DB_SUCCESS: