void PostgresPreparedStatement::SetParamBool(int nPosition, bool bValue) { int nIndex = FindStatementAndAdjustPositionIndex(&nPosition); if (nIndex > -1) { m_Statements[nIndex].SetParam(nPosition, bValue); } }
void PostgresPreparedStatement::SetParamDouble(int nPosition, double dblValue) { int nIndex = FindStatementAndAdjustPositionIndex(&nPosition); if (nIndex > -1) { m_Statements[nIndex].SetParam(nPosition, dblValue); } }
void PostgresPreparedStatement::SetParamBlob(int nPosition, const void* pData, long nDataLength) { int nIndex = FindStatementAndAdjustPositionIndex(&nPosition); if (nIndex > -1) { m_Statements[nIndex].SetParam(nPosition, pData, nDataLength); } }
void PostgresPreparedStatement::SetParamDate(int nPosition, const wxDateTime& dateValue) { int nIndex = FindStatementAndAdjustPositionIndex(&nPosition); if (nIndex > -1) { m_Statements[nIndex].SetParam(nPosition, dateValue); } }
void PostgresPreparedStatement::SetParamString(int nPosition, const wxString& strValue) { int nIndex = FindStatementAndAdjustPositionIndex(&nPosition); if (nIndex > -1) { m_Statements[nIndex].SetParam(nPosition, strValue); } }
void wxSqlitePreparedStatement::SetParamDate(int nPosition, const wxDateTime& dateValue) { ResetErrorCodes(); if (dateValue.IsValid()) { int nIndex = FindStatementAndAdjustPositionIndex(&nPosition); if (nIndex > -1) { sqlite3_reset(m_Statements[nIndex]); wxCharBuffer valueBuffer = ConvertToUnicodeStream(dateValue.Format(_("%Y-%m-%d %H:%M:%S"))); int nReturn = sqlite3_bind_text(m_Statements[nIndex], nPosition, valueBuffer, -1, SQLITE_TRANSIENT); if (nReturn != SQLITE_OK) { SetErrorCode(wxSqliteDatabase::TranslateErrorCode(nReturn)); SetErrorMessage(ConvertFromUnicodeStream(sqlite3_errmsg(m_pDatabase))); ThrowDatabaseException(); } } } else { int nIndex = FindStatementAndAdjustPositionIndex(&nPosition); if (nIndex > -1) { sqlite3_reset(m_Statements[nIndex]); int nReturn = sqlite3_bind_null(m_Statements[nIndex], nPosition); if (nReturn != SQLITE_OK) { SetErrorCode(wxSqliteDatabase::TranslateErrorCode(nReturn)); SetErrorMessage(ConvertFromUnicodeStream(sqlite3_errmsg(m_pDatabase))); ThrowDatabaseException(); } } } }
void wxSqlitePreparedStatement::SetParamDouble(int nPosition, double dblValue) { ResetErrorCodes(); int nIndex = FindStatementAndAdjustPositionIndex(&nPosition); if (nIndex > -1) { sqlite3_reset(m_Statements[nIndex]); int nReturn = sqlite3_bind_double(m_Statements[nIndex], nPosition, dblValue); if (nReturn != SQLITE_OK) { SetErrorCode(wxSqliteDatabase::TranslateErrorCode(nReturn)); SetErrorMessage(ConvertFromUnicodeStream(sqlite3_errmsg(m_pDatabase))); ThrowDatabaseException(); } } }
void wxSqlitePreparedStatement::SetParamBlob(int nPosition, const void* pData, long nDataLength) { ResetErrorCodes(); int nIndex = FindStatementAndAdjustPositionIndex(&nPosition); if (nIndex > -1) { sqlite3_reset(m_Statements[nIndex]); int nReturn = sqlite3_bind_blob(m_Statements[nIndex], nPosition, (const void*)pData, nDataLength, SQLITE_STATIC); if (nReturn != SQLITE_OK) { SetErrorCode(wxSqliteDatabase::TranslateErrorCode(nReturn)); SetErrorMessage(ConvertFromUnicodeStream(sqlite3_errmsg(m_pDatabase))); ThrowDatabaseException(); } } }
void wxSqlitePreparedStatement::SetParamString(int nPosition, const wxString& strValue) { ResetErrorCodes(); int nIndex = FindStatementAndAdjustPositionIndex(&nPosition); if (nIndex > -1) { sqlite3_reset(m_Statements[nIndex]); wxCharBuffer valueBuffer = ConvertToUnicodeStream(strValue); int nReturn = sqlite3_bind_text(m_Statements[nIndex], nPosition, valueBuffer, -1, SQLITE_TRANSIENT); if (nReturn != SQLITE_OK) { SetErrorCode(wxSqliteDatabase::TranslateErrorCode(nReturn)); SetErrorMessage(ConvertFromUnicodeStream(sqlite3_errmsg(m_pDatabase))); ThrowDatabaseException(); } } }