Lines Matching refs:aSql
449 ::rtl::OUStringBuffer aSql = ::rtl::OUString::createFromAscii("DELETE FROM "); in deleteRows()
450 aSql.append(m_aComposedTableName); in deleteRows()
451 aSql.append(::rtl::OUString::createFromAscii(" WHERE ")); in deleteRows()
483 aSql.append(sCon); in deleteRows()
484 aSql.append(aOr); in deleteRows()
486 aSql.setLength(aSql.getLength()-3); in deleteRows()
490 … Reference< XPreparedStatement > xPrep(m_xConnection->prepareStatement(aSql.makeStringAndClear())); in deleteRows()
537 ::rtl::OUStringBuffer aSql = ::rtl::OUString::createFromAscii("UPDATE "); in updateRow()
538 aSql.append(m_aComposedTableName); in updateRow()
539 aSql.append(::rtl::OUString::createFromAscii(" SET ")); in updateRow()
565 const sal_Int32 nOldLength = aSql.getLength(); in updateRow()
605 aSql.append(::dbtools::quoteName( aQuote,aIter->second.sRealName)); in updateRow()
606 aSql.append(aPara); in updateRow()
610 if( aSql.getLength() != nOldLength ) in updateRow()
612 aSql.setLength(aSql.getLength()-1); in updateRow()
619 aSql.append(::rtl::OUString::createFromAscii(" WHERE ")); in updateRow()
622 aSql.append(sKeyCondition.makeStringAndClear()); in updateRow()
623 aSql.append(sIndexCondition.makeStringAndClear()); in updateRow()
627 aSql.append(sKeyCondition.makeStringAndClear()); in updateRow()
631 aSql.append(sIndexCondition.makeStringAndClear()); in updateRow()
633 aSql.setLength(aSql.getLength()-5); // remove the last AND in updateRow()
641 executeUpdate(_rInsertRow ,_rOrginalRow,aSql.makeStringAndClear(),sEmpty,aIndexColumnPositions); in updateRow()
713 ::rtl::OUStringBuffer aSql(::rtl::OUString::createFromAscii("INSERT INTO ")); in insertRow()
717 aSql.append(m_aComposedTableName); in insertRow()
718 aSql.append(::rtl::OUString::createFromAscii(" ( ")); in insertRow()
738 aSql.append(::dbtools::quoteName( aQuote,aIter->second.sRealName)); in insertRow()
739 aSql.append(aComma); in insertRow()
747 aSql.setCharAt(aSql.getLength()-1,')'); in insertRow()
749 aSql.append(aValues.makeStringAndClear()); in insertRow()
752 executeInsert(_rInsertRow,aSql.makeStringAndClear(),sEmpty,bRefetch); in insertRow()
999 ::rtl::OUStringBuffer aSql = ::rtl::OUString::createFromAscii("DELETE FROM "); in deleteRow()
1000 aSql.append(m_aComposedTableName); in deleteRow()
1001 aSql.append(::rtl::OUString::createFromAscii(" WHERE ")); in deleteRow()
1030 aSql.append(::dbtools::quoteName( aQuote,aIter->second.sRealName)); in deleteRow()
1034 aSql.append(::rtl::OUString::createFromAscii(" IS NULL")); in deleteRow()
1037 aSql.append(::rtl::OUString::createFromAscii(" = ?")); in deleteRow()
1038 aSql.append(aAnd); in deleteRow()
1063 aSql.append(sIndexCondition.makeStringAndClear()); in deleteRow()
1064 aSql.setLength(aSql.getLength()-5); in deleteRow()
1067 … Reference< XPreparedStatement > xPrep(m_xConnection->prepareStatement(aSql.makeStringAndClear())); in deleteRow()