Lines Matching defs:pSqlStmt
648 bool wxDbTable::execDelete(const wxString &pSqlStmt)
653 retcode = SQLExecDirect(hstmtDelete, (SQLTCHAR FAR *) pSqlStmt.c_str(), SQL_NTS);
670 bool wxDbTable::execUpdate(const wxString &pSqlStmt)
675 retcode = SQLExecDirect(hstmtUpdate, (SQLTCHAR FAR *) pSqlStmt.c_str(), SQL_NTS);
724 bool wxDbTable::query(int queryType, bool forUpdate, bool distinct, const wxString &pSqlStmt)
747 retcode = SQLExecDirect(hstmt, (SQLTCHAR FAR *) (queryType == DB_SELECT_STATEMENT ? pSqlStmt.c_str() : sqlStmt.c_str()), SQL_NTS);
909 bool wxDbTable::QueryBySqlStmt(const wxString &pSqlStmt)
911 pDb->WriteSqlLog(pSqlStmt);
913 return(query(DB_SELECT_STATEMENT, false, false, pSqlStmt));
993 void wxDbTable::BuildDeleteStmt(wxString &pSqlStmt, int typeOfDel, const wxString &pWhereClause)
1007 pSqlStmt.Printf(wxT("DELETE FROM %s"),
1012 pSqlStmt.Printf(wxT("DELETE FROM %s WHERE "),
1032 pSqlStmt += wxT("ROWID = '");
1033 pSqlStmt += rowid;
1034 pSqlStmt += wxT("'");
1041 pSqlStmt += whereClause;
1044 pSqlStmt += pWhereClause;
1048 pSqlStmt += whereClause;
1056 void wxDbTable::BuildDeleteStmt(wxChar *pSqlStmt, int typeOfDel, const wxString &pWhereClause)
1060 wxStrcpy(pSqlStmt, tempSqlStmt);
1065 void wxDbTable::BuildSelectStmt(wxString &pSqlStmt, int typeOfSelect, bool distinct)
1071 pSqlStmt = wxT("SELECT ");
1075 pSqlStmt += wxT("DISTINCT ");
1097 pSqlStmt += pDb->SQLTableName(queryTableName.c_str());
1098 pSqlStmt += wxT(".");
1100 pSqlStmt += pDb->SQLColumnName(colDefs[i].ColName);
1102 pSqlStmt += wxT(",");
1112 pSqlStmt += wxT(",");
1113 pSqlStmt += pDb->SQLTableName(queryTableName);
1114 pSqlStmt += wxT(".ROWID");
1117 pSqlStmt += wxT(",ROWID");
1121 pSqlStmt += wxT(" FROM ");
1122 pSqlStmt += pDb->SQLTableName(queryTableName);
1123 // pSqlStmt += queryTableName;
1131 pSqlStmt += wxT(" HOLDLOCK");
1134 pSqlStmt += from;
1147 pSqlStmt += wxT(" WHERE ");
1148 pSqlStmt += where;
1155 pSqlStmt += wxT(" WHERE ");
1156 pSqlStmt += whereClause;
1163 pSqlStmt += wxT(" WHERE ");
1164 pSqlStmt += whereClause;
1176 pSqlStmt += wxT(" ORDER BY ");
1177 pSqlStmt += orderBy;
1184 pSqlStmt += wxT(" FOR UPDATE");
1190 void wxDbTable::BuildSelectStmt(wxChar *pSqlStmt, int typeOfSelect, bool distinct)
1194 wxStrcpy(pSqlStmt, tempSqlStmt);
1199 void wxDbTable::BuildUpdateStmt(wxString &pSqlStmt, int typeOfUpdate, const wxString &pWhereClause)
1210 pSqlStmt.Printf(wxT("UPDATE %s SET "),
1221 pSqlStmt += wxT(",");
1225 pSqlStmt += pDb->SQLColumnName(colDefs[i].ColName);
1226 // pSqlStmt += colDefs[i].ColName;
1227 pSqlStmt += wxT(" = ?");
1232 pSqlStmt += wxT(" WHERE ");
1249 pSqlStmt += wxT("ROWID = '");
1250 pSqlStmt += rowid;
1251 pSqlStmt += wxT("'");
1258 pSqlStmt += whereClause;
1261 pSqlStmt += pWhereClause;
1268 void wxDbTable::BuildUpdateStmt(wxChar *pSqlStmt, int typeOfUpdate, const wxString &pWhereClause)
1272 wxStrcpy(pSqlStmt, tempSqlStmt);
2026 /********** wxDbTable::Update(pSqlStmt) **********/
2027 bool wxDbTable::Update(const wxString &pSqlStmt)
2033 pDb->WriteSqlLog(pSqlStmt);
2035 return(execUpdate(pSqlStmt));
2037 } // wxDbTable::Update(pSqlStmt)