Lines Matching refs:rtl
151 static const ::rtl::OUString C_AND = ::rtl::OUString::createFromAscii(" AND ");
152 static const ::rtl::OUString C_OR = ::rtl::OUString::createFromAscii(" OR ");
183 …::rtl::OUString quoteTableAlias(sal_Bool _bQuote, const ::rtl::OUString& _sAliasName, const ::rtl:… in quoteTableAlias()
185 ::rtl::OUString sRet; in quoteTableAlias()
189 const static ::rtl::OUString sTableSeparater('.'); in quoteTableAlias()
195 …::rtl::OUString getTableRange(const OQueryDesignView* _pView,const ::connectivity::OSQLParseNode* … in getTableRange()
198 ::rtl::OUString sTableRange; in getTableRange()
227 …Sequence< ::rtl::OUString> aSeq = aInfoData->getReferencingTable()->getColumns()->getElementNames(… in insertConnection()
228 const ::rtl::OUString* pIter = aSeq.getConstArray(); in insertConnection()
229 const ::rtl::OUString* pEnd = pIter + aSeq.getLength(); in insertConnection()
249 ::rtl::OUString aSourceFieldName(_aDragLeft->GetField()); in insertConnection()
250 ::rtl::OUString aDestFieldName(_aDragRight->GetField()); in insertConnection()
254 ::rtl::OUString aTmp(aSourceFieldName); in insertConnection()
270 ::rtl::OUString ParseCondition( OQueryController& rController in ParseCondition()
272 ,const ::rtl::OUString _sDecimal in ParseCondition()
276 ::rtl::OUString aCondition; in ParseCondition()
334 ::rtl::OUString aTableRange,aColumnName; in FillDragInfo()
371 ::rtl::OUString BuildJoinCriteria( const Reference< XConnection>& _xConnection, in BuildJoinCriteria()
375 ::rtl::OUStringBuffer aCondition; in BuildJoinCriteria()
383 const ::rtl::OUString aQuote = xMetaData->getIdentifierQuoteString(); in BuildJoinCriteria()
384 const ::rtl::OUString sEqual(RTL_CONSTASCII_USTRINGPARAM(" = ")); in BuildJoinCriteria()
416 ::rtl::OUString& _rJoin ) in JoinCycle()
427 _rJoin = _rJoin.replaceAt(_rJoin.getLength()-1,1,::rtl::OUString(' ')); in JoinCycle()
431 _rJoin += ::rtl::OUString(')'); in JoinCycle()
436 ::rtl::OUString BuildTable( const Reference< XConnection>& _xConnection, in BuildTable()
441 ::rtl::OUString aDBName(pEntryTab->GetComposedName()); in BuildTable()
450 ::rtl::OUString sCatalog, sSchema, sTable; in BuildTable()
452 …::rtl::OUString aTableListStr = ::dbtools::composeTableNameForSelect( _xConnection, sCatalog, sSch… in BuildTable()
454 ::rtl::OUString aQuote = xMetaData->getIdentifierQuoteString(); in BuildTable()
457 aTableListStr += ::rtl::OUString::createFromAscii(" "); in BuildTable()
459 aTableListStr += ::rtl::OUString::createFromAscii("AS "); in BuildTable()
472 ::rtl::OUString BuildJoin( const Reference< XConnection>& _xConnection, in BuildJoin()
473 const ::rtl::OUString& rLh, in BuildJoin()
474 const ::rtl::OUString& rRh, in BuildJoin()
512 ::rtl::OUString BuildJoin( const Reference< XConnection>& _xConnection, in BuildJoin()
522 ::rtl::OUString BuildJoin( const Reference< XConnection>& _xConnection, in BuildJoin()
523 const ::rtl::OUString &rLh, in BuildJoin()
531 ::rtl::OUString BuildJoin( const Reference< XConnection>& _xConnection, in BuildJoin()
533 const ::rtl::OUString &rRh, in BuildJoin()
543 ::rtl::OUString &aJoin) in GetNextJoin()
668 ::rtl::OUString GenerateSelectList( const OQueryDesignView* _pView, in GenerateSelectList()
674 return ::rtl::OUString(); in GenerateSelectList()
676 ::rtl::OUStringBuffer aTmpStr,aFieldListStr; in GenerateSelectList()
698 const ::rtl::OUString aQuote = xMetaData->getIdentifierQuoteString(); in GenerateSelectList()
702 const static ::rtl::OUString sFieldSeparator(RTL_CONSTASCII_USTRINGPARAM(", ")); in GenerateSelectList()
703 const static ::rtl::OUString s_sAs(RTL_CONSTASCII_USTRINGPARAM(" AS ")); in GenerateSelectList()
709 ::rtl::OUString rFieldName = pEntryField->GetField(); in GenerateSelectList()
712 aTmpStr = ::rtl::OUString(); in GenerateSelectList()
713 const ::rtl::OUString rAlias = pEntryField->GetAlias(); in GenerateSelectList()
714 const ::rtl::OUString rFieldAlias = pEntryField->GetFieldAlias(); in GenerateSelectList()
750 ::rtl::OUStringBuffer aTmpStr2( pEntryField->GetFunction()); in GenerateSelectList()
780 ::rtl::OUStringBuffer& rRetStr, in GenerateCriterias()
781 ::rtl::OUStringBuffer& rHavingStr, in GenerateCriterias()
788 ::rtl::OUString aFieldName,aCriteria,aWhereStr,aHavingStr,aWork/*,aOrderStr*/; in GenerateCriterias()
803 const ::rtl::OUString aQuote = xMetaData->getIdentifierQuoteString(); in GenerateCriterias()
808 aHavingStr = aWhereStr = ::rtl::OUString(); in GenerateCriterias()
829 aWork = ::rtl::OUString(); in GenerateCriterias()
842 aHavingStr += ::rtl::OUString('('); // Klammern in GenerateCriterias()
850 aHavingStr += ::rtl::OUString('('); // Klammern in GenerateCriterias()
852 aHavingStr += ::rtl::OUString(')'); // Klammern in GenerateCriterias()
857 ::rtl::OUString aTmp = aCriteria; in GenerateCriterias()
858 ::rtl::OUString aErrorMsg; in GenerateCriterias()
865 ::rtl::OUString sHavingStr = aHavingStr; in GenerateCriterias()
882 aWhereStr += ::rtl::OUString('('); // Klammern in GenerateCriterias()
886 aWhereStr += ::rtl::OUString(' '); in GenerateCriterias()
888 ::rtl::OUString aTmp = aCriteria; in GenerateCriterias()
889 ::rtl::OUString aErrorMsg; in GenerateCriterias()
896 ::rtl::OUString aWhere = aWhereStr; in GenerateCriterias()
907 aWhereStr += ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("=")); in GenerateCriterias()
916 aWhereStr += ::rtl::OUString('('); // Klammern in GenerateCriterias()
924 aWhereStr += ::rtl::OUString(')'); // Klammern zu fuer 'AND' Zweig in GenerateCriterias()
933 aHavingStr += ::rtl::OUString(')'); // Klammern zu fuer 'AND' Zweig in GenerateCriterias()
957 ::rtl::OUString& _rsRet) in GenerateOrder()
966 ::rtl::OUString aColumnName; in GenerateOrder()
967 ::rtl::OUString aWorkStr; in GenerateOrder()
972 ::rtl::OUString aQuote = xMetaData->getIdentifierQuoteString(); in GenerateOrder()
1004 aWorkStr += ::rtl::OUString('('); in GenerateOrder()
1012 aWorkStr += ::rtl::OUString(')'); in GenerateOrder()
1023 aWorkStr += ::rtl::OUString(' '); in GenerateOrder()
1025 aWorkStr += ::rtl::OUString(','); in GenerateOrder()
1043 _rsRet = ::rtl::OUString::createFromAscii(" ORDER BY "); in GenerateOrder()
1058 ::rtl::OUString& _rJoinCrit, in GenerateInnerJoinCriterias()
1078 ::std::map< ::rtl::OUString,sal_Bool,::comphelper::UStringMixLess>& _rTableNames, in searchAndAppendName()
1079 ::rtl::OUString& _rsTableListStr in searchAndAppendName()
1082 ::rtl::OUString sTabName(BuildTable(_xConnection,_pTableWindow)); in searchAndAppendName()
1088 _rsTableListStr += ::rtl::OUString(','); in searchAndAppendName()
1092 ::rtl::OUString GenerateFromClause( const Reference< XConnection>& _xConnection, in GenerateFromClause()
1098 ::rtl::OUString aTableListStr; in GenerateFromClause()
1100 ::std::map< ::rtl::OUString,sal_Bool,::comphelper::UStringMixLess> aTableNames; in GenerateFromClause()
1139 ::rtl::OUString aJoin; in GenerateFromClause()
1148 ::rtl::OUString sTabName(BuildTable(_xConnection,pEntryTabFrom)); in GenerateFromClause()
1155 ::rtl::OUString aStr; in GenerateFromClause()
1164 aStr += ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("{ OJ ")); in GenerateFromClause()
1167 aStr += ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(" }")); in GenerateFromClause()
1174 aStr += ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(",")); in GenerateFromClause()
1209 aTableListStr += ::rtl::OUString(','); in GenerateFromClause()
1214 aTableListStr = aTableListStr.replaceAt(aTableListStr.getLength()-1,1, ::rtl::OUString() ); in GenerateFromClause()
1218 …::rtl::OUString GenerateGroupBy(const OQueryDesignView* _pView,OTableFields& _rFieldList, sal_Bool… in GenerateGroupBy()
1223 return ::rtl::OUString(); in GenerateGroupBy()
1225 ::std::map< rtl::OUString,bool> aGroupByNames; in GenerateGroupBy()
1227 ::rtl::OUString aGroupByStr; in GenerateGroupBy()
1231 const ::rtl::OUString aQuote = xMetaData->getIdentifierQuoteString(); in GenerateGroupBy()
1241 ::rtl::OUString sGroupByPart = quoteTableAlias(bMulti,pEntryField->GetAlias(),aQuote); in GenerateGroupBy()
1250 ::rtl::OUString aTmp = pEntryField->GetField(); in GenerateGroupBy()
1251 ::rtl::OUString aErrorMsg; in GenerateGroupBy()
1256 ::rtl::OUString sGroupBy; in GenerateGroupBy()
1269 … aGroupByNames.insert(::std::map< rtl::OUString,bool>::value_type(sGroupByPart,true)); in GenerateGroupBy()
1271 aGroupByStr += ::rtl::OUString(','); in GenerateGroupBy()
1277 aGroupByStr = aGroupByStr.replaceAt(aGroupByStr.getLength()-1,1, ::rtl::OUString(' ') ); in GenerateGroupBy()
1278 ::rtl::OUString aGroupByStr2 = ::rtl::OUString::createFromAscii(" GROUP BY "); in GenerateGroupBy()
1424 const ::rtl::OUString sDecimal = _pView->getDecimalSeparator(); in GetANDCriteria()
1463 ::rtl::OUString aColumnName; in GetANDCriteria()
1464 ::rtl::OUString aCondition; in GetANDCriteria()
1531 ::rtl::OUString sCondition = ParseCondition(rController,pCondition,sDecimal,aLocale,1); in GetANDCriteria()
1543 ::rtl::OUString sCondition = ParseCondition(rController,pCondition,sDecimal,aLocale,1); in GetANDCriteria()
1547 ::rtl::OUString sName; in GetANDCriteria()
1567 ::rtl::OUString aCondition = ParseCondition(rController,pCondition,sDecimal,aLocale,0); in GetANDCriteria()
1597 ::rtl::OUString aCondition; in AddFunctionCondition()
1600 ::rtl::OUString aColumnName; in AddFunctionCondition()
1643 if (pTabWin->ExistsField( ::rtl::OUString::createFromAscii("*"), aDragLeft )) in AddFunctionCondition()
1654 ::rtl::OUString sParameterValue; in AddFunctionCondition()
1696 ::rtl::OUString aCondition; in ComparisonPredicate()
1757 aCondition = aCondition + ::rtl::OUString::createFromAscii(">"); in ComparisonPredicate()
1762 aCondition = aCondition + ::rtl::OUString::createFromAscii(">="); in ComparisonPredicate()
1767 aCondition = aCondition + ::rtl::OUString::createFromAscii("<"); in ComparisonPredicate()
1772 aCondition = aCondition + ::rtl::OUString::createFromAscii("<="); in ComparisonPredicate()
1813 ::rtl::OUString aName,aCondition; in ComparisonPredicate()
1847 …OQueryTableWindow* lcl_findColumnInTables( const ::rtl::OUString& _rColumName, const OJoinTableVie… in lcl_findColumnInTables()
1864 ::rtl::OUString& aColumnName, in InsertColumnRef()
1865 const ::rtl::OUString& aColumnAlias, in InsertColumnRef()
1866 ::rtl::OUString& aTableRange, in InsertColumnRef()
1898 _raInfo->SetTable(::rtl::OUString()); in InsertColumnRef()
1899 _raInfo->SetAlias(::rtl::OUString()); in InsertColumnRef()
2088 ::rtl::OUString sComposedName; in InitFromParseNodeImpl()
2089 ::rtl::OUString aQualifierName; in InitFromParseNodeImpl()
2090 ::rtl::OUString sAlias; in InitFromParseNodeImpl()
2116 ::rtl::OUString sCatalog, sSchema, sTable; in InitFromParseNodeImpl()
2198 ::rtl::OUString sAsterix(RTL_CONSTASCII_USTRINGPARAM("*")); in fillSelectSubList()
2237 ::rtl::OUString aColumnName,aTableRange; in InstallFields()
2252 …::rtl::OUString aColumnAlias(rController.getParseIterator().getColumnAlias(pColumnRef)); // kann l… in InstallFields()
2273 ::rtl::OUString aColumns; in InstallFields()
2307 if (pTabWin->ExistsField( ::rtl::OUString::createFromAscii("*"), aInfo )) in InstallFields()
2317 ::rtl::OUString sFieldName = aColumns; in InstallFields()
2322 sFieldName = ::rtl::OUString(); in InstallFields()
2356 ::rtl::OUString aColumns; in InstallFields()
2427 ::rtl::OUString aTableRange,aColumnName; in GetOrderCriteria()
2452 ::rtl::OUString sCondition; in GetOrderCriteria()
2521 ::rtl::OUString sGroupByExpression; in GetGroupCriteria()
2752 void OQueryDesignView::setStatement(const ::rtl::OUString& /*_rsStatement*/) in setStatement()
2814 void OQueryDesignView::TableDeleted(const ::rtl::OUString& rAliasName) in TableDeleted()
2821 void OQueryDesignView::DeleteFields( const ::rtl::OUString& rAliasName ) in DeleteFields()
2826 bool OQueryDesignView::HasFieldByAliasName(const ::rtl::OUString& rFieldName, OTableFieldDescRef& r… in HasFieldByAliasName()
2845 void OQueryDesignView::fillValidFields(const ::rtl::OUString& sAliasName, ComboBox* pFieldList) in fillValidFields()
2853 ::rtl::OUString strCurrentPrefix; in fillValidFields()
2854 ::std::vector< ::rtl::OUString> aFields; in fillValidFields()
2863 strCurrentPrefix += ::rtl::OUString('.'); in fillValidFields()
2867 ::std::vector< ::rtl::OUString>::iterator aStrIter = aFields.begin(); in fillValidFields()
2868 ::std::vector< ::rtl::OUString>::iterator aStrEnd = aFields.end(); in fillValidFields()
2872 pFieldList->InsertEntry(::rtl::OUString(strCurrentPrefix) += *aStrIter); in fillValidFields()
2919 ::rtl::OUString OQueryDesignView::getStatement() in getStatement()
2948 return ::rtl::OUString(); in getStatement()
2954 ::rtl::OUString aFieldListStr(GenerateSelectList(this,rFieldList,nTabcount>1)); in getStatement()
2956 return ::rtl::OUString(); in getStatement()
2965 ::rtl::OUString aTableListStr(GenerateFromClause(xConnection,pTabList,pConnList)); in getStatement()
2970 ::rtl::OUStringBuffer aHavingStr,aCriteriaListStr; in getStatement()
2973 return ::rtl::OUString(); in getStatement()
2975 ::rtl::OUString aJoinCrit; in getStatement()
2979 ::rtl::OUString aTmp = ::rtl::OUString::createFromAscii("( "); in getStatement()
2981 aTmp += ::rtl::OUString::createFromAscii(" )"); in getStatement()
2990 ::rtl::OUStringBuffer aSqlCmd(::rtl::OUString::createFromAscii("SELECT ")); in getStatement()
2992 aSqlCmd.append(::rtl::OUString::createFromAscii(" DISTINCT ")); in getStatement()
2994 aSqlCmd.append(::rtl::OUString::createFromAscii(" FROM ")); in getStatement()
2999 aSqlCmd.append(::rtl::OUString::createFromAscii(" WHERE ")); in getStatement()
3014 aSqlCmd.append(::rtl::OUString::createFromAscii(" HAVING ")); in getStatement()
3018 ::rtl::OUString sOrder; in getStatement()
3030 ::rtl::OUString sSQL = aSqlCmd.makeStringAndClear(); in getStatement()
3034 ::rtl::OUString sErrorMessage; in getStatement()
3045 ::rtl::OUString sTemp; in getStatement()
3113 ::rtl::OUString& _rsErrorMessage, in getPredicateTreeFromEntry()
3145 ::rtl::OUString sSql; in getPredicateTreeFromEntry()
3146 sSql += ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("SELECT * ")); in getPredicateTreeFromEntry()
3147 sSql += ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(" FROM x WHERE ")); in getPredicateTreeFromEntry()
3168 ::rtl::OUString(), in getPredicateTreeFromEntry()
3169 ::rtl::OUString(), in getPredicateTreeFromEntry()
3170 ::rtl::OUString(), in getPredicateTreeFromEntry()
3278 ,const ::rtl::OUString& sFunctionTerm in fillFunctionInfo()
3284 ::rtl::OUString sFieldName = sFunctionTerm; in fillFunctionInfo()
3291 ::rtl::OUString sFunctionName = pFunctionName->getTokenValue(); in fillFunctionInfo()
3293 …sFunctionName = ::rtl::OStringToOUString(OSQLParser::TokenIDToStr(pFunctionName->getTokenID()),RTL… in fillFunctionInfo()