Lines Matching defs:wxDb
3 // Purpose: Implementation of the wxDb class. The wxDb class represents a connection
4 // to an ODBC data source. The wxDb class allows operations on the data
78 // The wxDb::errorList is copied to this variable when the wxDb object
82 // why the connection failed. Note: as each wxDb object is closed, it
83 // will overwrite the errors of the previously destroyed wxDb object in
460 /********** wxDb Constructor **********/
461 wxDb::wxDb(const HENV &aHenv, bool FwdOnlyCursors)
468 } // wxDb::wxDb()
471 /********** wxDb Destructor **********/
472 wxDb::~wxDb()
480 } // wxDb destructor
484 /********** PRIVATE! wxDb::initialize PRIVATE! **********/
485 /********** wxDb::initialize() **********/
486 void wxDb::initialize()
488 * Private member function that sets all wxDb member variables to
489 * known values at creation of the wxDb
556 } // wxDb::initialize()
559 /********** PRIVATE! wxDb::convertUserID PRIVATE! **********/
565 const wxChar *wxDb::convertUserID(const wxChar *userID, wxString &UserID)
589 } // wxDb::convertUserID()
592 bool wxDb::determineDataTypes(bool failOnDataTypeUnsupported)
787 } // wxDb::determineDataTypes
790 bool wxDb::open(bool failOnDataTypeUnsupported)
828 bool wxDb::Open(const wxString& inConnectStr, bool failOnDataTypeUnsupported)
834 bool wxDb::Open(const wxString& inConnectStr, SQLHWND parentWnd, bool failOnDataTypeUnsupported)
879 /********** wxDb::Open() **********/
880 bool wxDb::Open(const wxString &Dsn, const wxString &Uid, const wxString &AuthStr, bool failOnDataTypeUnsupported)
919 } // wxDb::Open()
922 bool wxDb::Open(wxDbConnectInf *dbConnectInf, bool failOnDataTypeUnsupported)
932 } // wxDb::Open()
935 bool wxDb::Open(wxDb *copyDb)
1013 // from the wxDb instance that was passed in (copyDb).
1100 } // wxDb::Open() 2
1103 /********** wxDb::setConnectionOptions() **********/
1104 bool wxDb::setConnectionOptions(void)
1174 } // wxDb::setConnectionOptions()
1177 /********** wxDb::getDbInfo() **********/
1178 bool wxDb::getDbInfo(bool failOnDataTypeUnsupported)
1634 } // wxDb::getDbInfo()
1637 /********** wxDb::getDataTypeInfo() **********/
1638 bool wxDb::getDataTypeInfo(SWORD fSqlType, wxDbSqlTypeInfo &structSQLTypeInfo)
1722 } // wxDb::getDataTypeInfo()
1725 /********** wxDb::Close() **********/
1726 void wxDb::Close(void)
1785 } // wxDb::Close()
1788 /********** wxDb::CommitTrans() **********/
1789 bool wxDb::CommitTrans(void)
1801 } // wxDb::CommitTrans()
1804 /********** wxDb::RollbackTrans() **********/
1805 bool wxDb::RollbackTrans(void)
1814 } // wxDb::RollbackTrans()
1817 /********** wxDb::DispAllErrors() **********/
1818 bool wxDb::DispAllErrors(HENV aHenv, HDBC aHdbc, HSTMT aHstmt)
1858 } // wxDb::DispAllErrors()
1861 /********** wxDb::GetNextError() **********/
1862 bool wxDb::GetNextError(HENV aHenv, HDBC aHdbc, HSTMT aHstmt)
1869 } // wxDb::GetNextError()
1872 /********** wxDb::DispNextError() **********/
1873 void wxDb::DispNextError(void)
1895 } // wxDb::DispNextError()
1898 /********** wxDb::logError() **********/
1899 void wxDb::logError(const wxString &errMsg, const wxString &SQLState)
1924 } // wxDb::logError()
1927 /**********wxDb::TranslateSqlState() **********/
1928 int wxDb::TranslateSqlState(const wxString &SQLState)
2112 } // wxDb::TranslateSqlState()
2115 /********** wxDb::Grant() **********/
2116 bool wxDb::Grant(int privileges, const wxString &tableName, const wxString &userList)
2165 } // wxDb::Grant()
2168 /********** wxDb::CreateView() **********/
2169 bool wxDb::CreateView(const wxString &viewName, const wxString &colList,
2200 } // wxDb::CreateView()
2203 /********** wxDb::DropView() **********/
2204 bool wxDb::DropView(const wxString &viewName)
2245 } // wxDb::DropView()
2248 /********** wxDb::ExecSql() **********/
2249 bool wxDb::ExecSql(const wxString &pSqlStmt)
2267 } // wxDb::ExecSql()
2270 /********** wxDb::ExecSql() with column info **********/
2271 bool wxDb::ExecSql(const wxString &pSqlStmt, wxDbColInf** columns, short& numcols)
2367 } // wxDb::ExecSql()
2369 /********** wxDb::GetNext() **********/
2370 bool wxDb::GetNext(void)
2380 } // wxDb::GetNext()
2383 /********** wxDb::GetData() **********/
2384 bool wxDb::GetData(UWORD colNo, SWORD cType, PTR pData, SDWORD maxLen, SQLLEN FAR *cbReturned)
2402 } // wxDb::GetData()
2405 /********** wxDb::GetKeyFields() **********/
2406 int wxDb::GetKeyFields(const wxString &tableName, wxDbColInf* colInf, UWORD noCols)
2543 } // wxDb::GetKeyFields()
2547 /********** wxDb::GetColumns() **********/
2548 wxDbColInf *wxDb::GetColumns(wxChar *tableName[], const wxChar *userID)
2571 * NOTE: ALL column bindings associated with this wxDb instance are unbound
2572 * by this function. This function should use its own wxDb instance
2673 // Determine the wxDb data type that is used to represent the native data type of this data source
2714 } // wxDb::GetColumns()
2717 /********** wxDb::GetColumns() **********/
2719 wxDbColInf *wxDb::GetColumns(const wxString &tableName, UWORD *numCols, const wxChar *userID)
2730 // NOTE: ALL column bindings associated with this wxDb instance are unbound
2731 // by this function. This function should use its own wxDb instance
2845 // Determine the wxDb data type that is used to represent the native data type of this data source
2895 } // wxDb::GetColumns()
2907 - The first one (wxDbColInf *wxDb::GetColumns(wxChar *tableName[], const
2911 - wxDbColInf *wxDb::GetColumns(const wxString &tableName, int *numCols, const
2926 wxDbColInf *wxDb::GetColumns(wxChar *tableName[], const wxChar *userID)
2973 } // wxDb::GetColumns() -- NEW
2976 wxDbColInf *wxDb::GetColumns(const wxString &tableName, int *numCols, const wxChar *userID)
2987 // NOTE: ALL column bindings associated with this wxDb instance are unbound
2988 // by this function. This function should use its own wxDb instance
3102 // Determine the wxDb data type that is used to represent the native data type of this data source
3242 } // wxDb::GetColumns()
3248 /********** wxDb::GetColumnCount() **********/
3249 int wxDb::GetColumnCount(const wxString &tableName, const wxChar *userID)
3260 * NOTE: ALL column bindings associated with this wxDb instance are unbound
3261 * by this function. This function should use its own wxDb instance
3326 } // wxDb::GetColumnCount()
3329 /********** wxDb::GetCatalog() *******/
3330 wxDbInf *wxDb::GetCatalog(const wxChar *userID)
3348 * NOTE: ALL column bindings associated with this wxDb instance are unbound
3349 * by this function. This function should use its own wxDb instance
3444 } // wxDb::GetCatalog()
3447 /********** wxDb::Catalog() **********/
3448 bool wxDb::Catalog(const wxChar *userID, const wxString &fileName)
3459 * NOTE: ALL column bindings associated with this wxDb instance are unbound
3460 * by this function. This function should use its own wxDb instance
3568 } // wxDb::Catalog()
3571 bool wxDb::TableExists(const wxString &tableName, const wxChar *userID, const wxString &tablePath)
3654 } // wxDb::TableExists()
3657 /********** wxDb::TablePrivileges() **********/
3658 bool wxDb::TablePrivileges(const wxString &tableName, const wxString &priv, const wxChar *userID,
3775 } // wxDb::TablePrivileges
3778 const wxString wxDb::SQLTableName(const wxChar *tableName)
3789 } // wxDb::SQLTableName()
3792 const wxString wxDb::SQLColumnName(const wxChar *colName)
3803 } // wxDb::SQLColumnName()
3806 /********** wxDb::SetSqlLogging() **********/
3807 bool wxDb::SetSqlLogging(wxDbSqlLogState state, const wxString &filename, bool append)
3834 } // wxDb::SetSqlLogging()
3837 /********** wxDb::WriteSqlLog() **********/
3838 bool wxDb::WriteSqlLog(const wxString &logMsg)
3854 } // wxDb::WriteSqlLog()
3857 /********** wxDb::Dbms() **********/
3858 wxDBMS wxDb::Dbms(void)
3865 * If you find an inconsistency between the wxDb class and a specific database
4005 } // wxDb::Dbms()
4008 bool wxDb::ModifyColumn(const wxString &tableName, const wxString &columnName,
4099 } // wxDb::ModifyColumn()
4101 /********** wxDb::EscapeSqlChars() **********/
4102 wxString wxDb::EscapeSqlChars(const wxString& valueOrig)
4121 } // wxDb::EscapeSqlChars()
4125 wxDb WXDLLIMPEXP_ODBC *wxDbGetConnection(wxDbConnectInf *pDbConfig, bool FwdOnlyCursors)
4131 // data types can be copied from it (using the wxDb::Open(wxDb *) function)
4133 // using the wxDb::Open(Dsn,Uid,AuthStr) function
4134 wxDb *matchingDbConnection = NULL;
4207 pList->PtrDb = new wxDb(pDbConfig->GetHenv(), FwdOnlyCursors);
4239 pList->PtrDb->CommitTrans(); // Commit any open transactions on wxDb object
4240 pList->PtrDb->Close(); // Close the wxDb object
4241 delete pList->PtrDb; // Deletes the wxDb object
4250 bool WXDLLIMPEXP_ODBC wxDbFreeConnection(wxDb *pDb)
4276 pList->PtrDb->CommitTrans(); // Commit any open transactions on wxDb object
4277 pList->PtrDb->Close(); // Close the wxDb object
4278 pList->PtrDb->setCached(false); // Allows deletion of the wxDb instance
4279 delete pList->PtrDb; // Deletes the wxDb object
4311 wxDb *pDb,
4501 wxDb WXDLLIMPEXP_ODBC *GetDbConnection(DbStuff *pDbStuff, bool FwdOnlyCursors)
4506 bool WXDLLIMPEXP_ODBC FreeDbConnection(wxDb *pDb)