X-Git-Url: https://git.saurik.com/wxWidgets.git/blobdiff_plain/e72403492b3e78f8114d89baae6f81ea24c74647..a9249b2eb2a40d8c71f828669045c4ddaa8dc5ff:/docs/latex/wx/db.tex diff --git a/docs/latex/wx/db.tex b/docs/latex/wx/db.tex index 8959651674..1714f47118 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}} +\func{const wxChar *}{wxDbLogExtendedErrorMsg}{\param{const wxChar *}{userText}, \param{wxDb *}{pDb}, \param{wxChar *}{ErrFile}, \param{int }{ErrLine}} -\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} - -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}} @@ -1340,6 +1346,52 @@ When called with {\it sqlLogON}, all commands sent to the datasource engine are When called with {\it sqlLogOFF}, the logging file is closed, and any calls to \helpref{wxDb::WriteSqlLog}{wxdbwritesqllog} are ignored. +\membersection{wxDb::SQLColumnName}\label{wxdbsqlcolumnname} + +\func{const wxString}{SQLColumnName}{\param{const char *}{ colName}} + +Returns the column name in a form ready for use in SQL statements. +In most cases, the column name is returned verbatim. But some databases +(e.g. MS Access, SQL Server, MSDE) allow for spaces in column names, which +must be specially quoted. For example, if the datasource allows spaces +in the column name, the returned string will have the correct enclosing +marks around the name to allow it to be properly included in a SQL statement +for the DBMS that is currently connected to with this connection. + +\wxheading{Parameters} + +\docparam{colName}{Native name of the column in the table that is to be +evaluated to determine if any special quoting marks needed to be added to it +before including the column name in a SQL statement} + +\wxheading{See also} + +\helpref{wxDb::SQLTableName}{wxdbsqltablename} + + +\membersection{wxDb::SQLTableName}\label{wxdbsqltablename} + +\func{const wxString}{SQLTableName}{\param{const char *}{ tableName}} + +Returns the table name in a form ready for use in SQL statements. +In most cases, the table name is returned verbatim. But some databases +(e.g. MS Access, SQL Server, MSDE) allow for spaces in table names, which +must be specially quoted. For example, if the datasource allows spaces +in the table name, the returned string will have the correct enclosing +marks around the name to allow it to be properly included in a SQL statement +for the data source that is currently connected to with this connection. + +\wxheading{Parameters} + +\docparam{tableName}{Native name of the table that is to be evaluated to +determine if any special quoting marks needed to be added to it +before including the table name in a SQL statement} + +\wxheading{See also} + +\helpref{wxDb::SQLColumnName}{wxdbsqlcolumnname} + + \membersection{wxDb::TableExists}\label{wxdbtableexists} \func{bool}{TableExists}{\param{const wxString &}{tableName}, \param{const wxChar *}{userID=NULL}, \param{const wxString &}{path=""}} @@ -3036,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: @@ -3057,7 +3109,7 @@ this function to commit or rollback the insertion. \membersection{wxDbTable::IsColNull}\label{wxdbtableiscolnull} -\func{bool }{IsColNull}{\param{UWORD }{colNo}} +\func{bool }{IsColNull}{\param{UWORD }{colNo}} const Used primarily in the ODBC class library to determine if a column value is set to "NULL". Works for all data types supported by the ODBC class library.