Home
last modified time | relevance | path

Searched refs:aSql (Results 1 – 25 of 33) sorted by relevance

12

/trunk/main/connectivity/source/drivers/adabas/
H A DBTables.cxx126 xStmt->execute(aSql); in setComments()
151 xStmt->execute(aSql); in setComments()
184 aSql += sDot; in dropObject()
186 xStmt->execute(aSql); in dropObject()
274 aSql = aSql.replaceAt(aSql.getLength()-1,1,::rtl::OUString::createFromAscii(")")); in createTable()
291 aSql = aSql.replaceAt(aSql.getLength()-1,1,::rtl::OUString::createFromAscii(")")); in createTable()
308 aSql += aQuote + aSchema + aQuote + sDot in createTable()
319 aSql = aSql.replaceAt(aSql.getLength()-1,1,::rtl::OUString::createFromAscii(")")); in createTable()
343 if(aSql.lastIndexOf(',') == (aSql.getLength()-1)) in createTable()
344 aSql = aSql.replaceAt(aSql.getLength()-1,1,::rtl::OUString::createFromAscii(")")); in createTable()
[all …]
H A DBIndexes.cxx108 aSql = aSql + ::rtl::OUString::createFromAscii("UNIQUE "); in appendObject()
109 aSql = aSql + ::rtl::OUString::createFromAscii("INDEX "); in appendObject()
114 aSql = aSql + aQuote + _rForName + aQuote in appendObject()
127 …aSql = aSql + aQuote + getString(xColProp->getPropertyValue(OMetaConnection::getPropMap().getNameB… in appendObject()
128 …aSql = aSql + (getBOOL(xColProp->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PRO… in appendObject()
135 aSql = aSql.replaceAt(aSql.getLength()-1,1,::rtl::OUString::createFromAscii(")")); in appendObject()
139 …aSql = aSql + aQuote + m_pTable->getSchema() + aQuote + sDot + aQuote + m_pTable->getTableName() +… in appendObject()
149 …aSql = aSql + sDot + aQuote + getString(xColProp->getPropertyValue(OMetaConnection::getPropMap().g… in appendObject()
153 xStmt->execute(aSql); in appendObject()
174 (((aSql += aQuote) += aSchema) += aQuote) += sDot; in dropObject()
[all …]
H A DBKeys.cxx71 aSql = aSql + ::rtl::OUString::createFromAscii(" ALTER PRIMARY KEY ("); in appendObject()
75 aSql = aSql + ::rtl::OUString::createFromAscii(" FOREIGN KEY ("); in appendObject()
87 …aSql = aSql + aQuote + getString(xColProp->getPropertyValue(OMetaConnection::getPropMap().getNameB… in appendObject()
90 aSql = aSql.replaceAt(aSql.getLength()-1,1,::rtl::OUString::createFromAscii(")")); in appendObject()
104 aSql += ::rtl::OUString::createFromAscii(" REFERENCES ") in appendObject()
106 aSql += ::rtl::OUString::createFromAscii(" ("); in appendObject()
112 …aSql = aSql + aQuote + getString(xColProp->getPropertyValue(OMetaConnection::getPropMap().getNameB… in appendObject()
115 aSql = aSql.replaceAt(aSql.getLength()-1,1,::rtl::OUString::createFromAscii(")")); in appendObject()
120 aSql += ::rtl::OUString::createFromAscii(" ON DELETE CASCADE "); in appendObject()
123 aSql += ::rtl::OUString::createFromAscii(" ON DELETE RESTRICT "); in appendObject()
[all …]
H A DBColumns.cxx128 ::rtl::OUString aSql(RTL_CONSTASCII_USTRINGPARAM("ALTER TABLE ")); in appendObject()
136 aSql += ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(" ADD (")); in appendObject()
137 aSql += ::dbtools::quoteName(sQuote,_rForName); in appendObject()
138 aSql += ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(" ")); in appendObject()
139 aSql += OTables::getColumnSqlType(descriptor); in appendObject()
140 aSql += ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(" )")); in appendObject()
143 xStmt->execute(aSql); in appendObject()
164 ::rtl::OUString aSql(RTL_CONSTASCII_USTRINGPARAM("ALTER TABLE ")); in dropObject()
169 aSql += ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(" DROP ")); in dropObject()
170 aSql += ::dbtools::quoteName(sQuote,_sElementName); in dropObject()
[all …]
H A DBViews.cxx140 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("DROP VIEW"); in dropObject()
143 …aSql = aSql + m_xMetaData->getIdentifierQuoteString( ) + aSchema + m_xMetaData->getIdentifierQuot… in dropObject()
144 aSql = aSql + sDot; in dropObject()
145 …aSql = aSql + m_xMetaData->getIdentifierQuoteString( ) + aName + m_xMetaData->getIdentifierQuoteS… in dropObject()
146 xStmt->execute(aSql); in dropObject()
160 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("CREATE VIEW "); in createView()
167 aSql += ::dbtools::quoteName(aQuote, sSchema) + sDot; in createView()
171 …aSql += ::dbtools::quoteName(aQuote, getString(descriptor->getPropertyValue(OMetaConnection::getPr… in createView()
174 aSql += sCommand; in createView()
178 xStmt->execute(aSql); in createView()
H A DBGroups.cxx63 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("CREATE USERGROUP "); in appendObject()
66 aSql = aSql + aQuote + _rForName + aQuote; in appendObject()
69 xStmt->execute(aSql); in appendObject()
78 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("DROP USERGROUP "); in dropObject()
81 aSql = aSql + aQuote + _sElementName + aQuote; in dropObject()
84 xStmt->execute(aSql); in dropObject()
H A DBUsers.cxx67 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("CREATE USER "); in appendObject()
73 aSql += ::dbtools::quoteName(aQuote,sUserName) in appendObject()
76 aSql += ::rtl::OUString::createFromAscii(" RESOURCE NOT EXCLUSIVE"); in appendObject()
80 xStmt->execute(aSql); in appendObject()
113 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("DROP USER "); in dropObject()
115 aSql += ::dbtools::quoteName(aQuote,_sElementName); in dropObject()
119 xStmt->execute(aSql); in dropObject()
H A DBGroup.cxx70 …::rtl::OUString aSql = ::rtl::OUString::createFromAscii("SELECT DISTINCT USERNAME FROM DOMAIN.USER… in refreshUsers()
71 aSql += getName( ); in refreshUsers()
72 aSql += ::rtl::OUString::createFromAscii("'"); in refreshUsers()
74 Reference< XResultSet > xResult = xStmt->executeQuery(aSql); in refreshUsers()
H A DBUser.cxx67 …::rtl::OUString aSql = ::rtl::OUString::createFromAscii("SELECT DISTINCT GROUPNAME FROM DOMAIN.USE… in refreshGroups()
68 aSql += getName( ); in refreshGroups()
69 aSql += ::rtl::OUString::createFromAscii("'"); in refreshGroups()
71 Reference< XResultSet > xResult = xStmt->executeQuery(aSql); in refreshGroups()
/trunk/main/connectivity/source/commontools/
H A Ddbtools2.cxx84 aSql.appendAscii(" "); in createStandardColumnPart()
139 aSql.appendAscii("("); in createStandardColumnPart()
153 aSql.append(nScale); in createStandardColumnPart()
156 aSql.appendAscii(")"); in createStandardColumnPart()
180 aSql.appendAscii(" "); in createStandardColumnPart()
353 if ( aSql.charAt(aSql.getLength()-1) == ',' ) in createStandardKeyStatement()
354 aSql.setCharAt(aSql.getLength()-1,')'); in createStandardKeyStatement()
371 aSql += sKeyStmt; in createSqlCreateTableStatement()
374 if ( aSql.lastIndexOf(',') == (aSql.getLength()-1) ) in createSqlCreateTableStatement()
375 aSql = aSql.replaceAt(aSql.getLength()-1,1,::rtl::OUString::createFromAscii(")")); in createSqlCreateTableStatement()
[all …]
H A DTKeys.cxx166 ::rtl::OUStringBuffer aSql; in appendObject()
167 aSql.appendAscii("ALTER TABLE "); in appendObject()
172 aSql.appendAscii(" ADD "); in appendObject()
176 aSql.appendAscii(" PRIMARY KEY ("); in appendObject()
191 aSql.appendAscii(","); in appendObject()
196 aSql.appendAscii(")"); in appendObject()
200 aSql.appendAscii(" REFERENCES "); in appendObject()
202 aSql.appendAscii(" ("); in appendObject()
212 aSql.appendAscii(")"); in appendObject()
283 ::rtl::OUStringBuffer aSql; in dropObject()
[all …]
H A DTIndexes.cxx151 aSql.appendAscii("UNIQUE "); in appendObject()
152 aSql.appendAscii("INDEX "); in appendObject()
163 aSql.appendAscii(" ON "); in appendObject()
164 aSql.append(aComposedName); in appendObject()
165 aSql.appendAscii(" ( "); in appendObject()
186 aSql.appendAscii(","); in appendObject()
188 aSql.setCharAt(aSql.getLength()-1,')'); in appendObject()
192 aSql.append(aComposedName); in appendObject()
202 aSql.append(aDot); in appendObject()
242 aSql += sIndexName in dropObject()
[all …]
H A DTColumnsHelper.cxx180 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("ALTER TABLE "); in appendObject()
183 …aSql += ::dbtools::composeTableName( xMetaData, m_pTable, ::dbtools::eInTableDefinitions, false, f… in appendObject()
184 aSql += ::rtl::OUString::createFromAscii(" ADD "); in appendObject()
185 …aSql += ::dbtools::createStandardColumnPart(descriptor,m_pTable->getConnection(),NULL,m_pTable->ge… in appendObject()
190 xStmt->execute(aSql); in appendObject()
202 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("ALTER TABLE "); in dropObject()
206 …aSql += ::dbtools::composeTableName( xMetaData, m_pTable, ::dbtools::eInTableDefinitions, false, f… in dropObject()
207 aSql += ::rtl::OUString::createFromAscii(" DROP "); in dropObject()
208 aSql += ::dbtools::quoteName( aQuote,_sElementName); in dropObject()
213 xStmt->execute(aSql); in dropObject()
/trunk/main/dbaccess/source/core/api/
H A DCacheSet.cxx207 aSql.append(m_aComposedTableName); in insertRow()
208 aSql.append(::rtl::OUString::createFromAscii(" ( ")); in insertRow()
220 aSql.append(aComma); in insertRow()
224 aSql.setCharAt(aSql.getLength()-1,')'); in insertRow()
227 aSql.append(aValues.makeStringAndClear()); in insertRow()
355 aSql.append(m_aComposedTableName); in updateRow()
356 aSql.append(::rtl::OUString::createFromAscii(" SET ")); in updateRow()
362 aSql.setCharAt(aSql.getLength()-1,' '); in updateRow()
368 aSql.append(aCondition.makeStringAndClear()); in updateRow()
403 aSql.append(m_aComposedTableName); in deleteRow()
[all …]
H A DKeySet.cxx450 aSql.append(m_aComposedTableName); in deleteRows()
483 aSql.append(sCon); in deleteRows()
484 aSql.append(aOr); in deleteRows()
486 aSql.setLength(aSql.getLength()-3); in deleteRows()
606 aSql.append(aPara); in updateRow()
612 aSql.setLength(aSql.getLength()-1); in updateRow()
633 aSql.setLength(aSql.getLength()-5); // remove the last AND in updateRow()
739 aSql.append(aComma); in insertRow()
747 aSql.setCharAt(aSql.getLength()-1,')'); in insertRow()
1038 aSql.append(aAnd); in deleteRow()
[all …]
H A DOptimisticSet.cxx195 TSQLStatements aSql; in updateRow() local
229 if( aSql.empty() ) in updateRow()
240 TSQLStatements::iterator aSqlIter = aSql.begin(); in updateRow()
241 TSQLStatements::iterator aSqlEnd = aSql.end(); in updateRow()
269 TSQLStatements aSql; in insertRow() local
315 TSQLStatements::iterator aSqlIter = aSql.begin(); in insertRow()
316 TSQLStatements::iterator aSqlEnd = aSql.end(); in insertRow()
388 TSQLStatements aSql; in deleteRow() local
680 TSQLStatements aSql; in fillMissingValues() local
703 TSQLStatements::iterator aSqlIter = aSql.begin(); in fillMissingValues()
[all …]
H A Dtablecontainer.cxx321 ::rtl::OUString aSql = ::dbtools::createSqlCreateTableStatement(descriptor,m_xConnection); in appendObject()
329 xStmt->execute(aSql); in appendObject()
416 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("DROP "); in dropObject()
420 aSql += ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("VIEW ")); in dropObject()
422 aSql += ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("TABLE ")); in dropObject()
423 aSql += sComposedName; in dropObject()
430 xStmt->execute(aSql); in dropObject()
H A DSingleSelectQueryComposer.cxx596 ::rtl::OUStringBuffer aSql( m_aPureSelectSQL ); in composeStatementFromParts()
601 aSql.append( _rParts[ eLoopParts ] ); in composeStatementFromParts()
604 return aSql.makeStringAndClear(); in composeStatementFromParts()
692 ::rtl::OUStringBuffer aSql(m_aPureSelectSQL); in setSingleAdditiveClause()
694 aSql.append(aClauses[ eLoopParts ]); in setSingleAdditiveClause()
697 setQuery_Impl(aSql.makeStringAndClear()); in setSingleAdditiveClause()
707 aSql = m_aPureSelectSQL; in setSingleAdditiveClause()
715 aSql.append(aClauses[ eLoopParts ]); in setSingleAdditiveClause()
1786 ::rtl::OUString aSql(m_aPureSelectSQL); in getStructuredCondition()
1790 aSql += STR_WHERE; in getStructuredCondition()
[all …]
/trunk/main/connectivity/source/drivers/hsqldb/
H A DHUsers.cxx79 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("GRANT USAGE ON * TO "); in appendObject()
82 aSql += ::dbtools::quoteName(aQuote,sUserName) in appendObject()
88 aSql += ::rtl::OUString::createFromAscii(" IDENTIFIED BY '"); in appendObject()
89 aSql += sPassword; in appendObject()
90 aSql += ::rtl::OUString::createFromAscii("'"); in appendObject()
95 xStmt->execute(aSql); in appendObject()
105 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("REVOKE ALL ON * FROM "); in dropObject()
107 aSql += ::dbtools::quoteName(aQuote,_sElementName); in dropObject()
111 xStmt->execute(aSql); in dropObject()
H A DHViews.cxx117 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("DROP VIEW"); in dropObject()
120 …aSql += ::dbtools::composeTableName( m_xMetaData, xProp, ::dbtools::eInTableDefinitions, false, fa… in dropObject()
124 xStmt->execute(aSql); in dropObject()
140 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("CREATE VIEW "); in createView()
144 …aSql += ::dbtools::composeTableName( m_xMetaData, descriptor, ::dbtools::eInTableDefinitions, fals… in createView()
146 aSql += ::rtl::OUString::createFromAscii(" AS "); in createView()
148 aSql += sCommand; in createView()
153 xStmt->execute(aSql); in createView()
H A DHTables.cxx138 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("DROP "); in dropObject()
143 aSql += ::rtl::OUString::createFromAscii("VIEW "); in dropObject()
145 aSql += ::rtl::OUString::createFromAscii("TABLE "); in dropObject()
149 aSql += sComposedName; in dropObject()
153 xStmt->execute(aSql); in dropObject()
169 ::rtl::OUString aSql = ::dbtools::createSqlCreateTableStatement(descriptor,xConnection); in createTable()
174 xStmt->execute(aSql); in createTable()
/trunk/main/connectivity/source/drivers/mysql/
H A DYUsers.cxx79 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("GRANT USAGE ON * TO "); in appendObject()
82 aSql += ::dbtools::quoteName(aQuote,sUserName) in appendObject()
88 aSql += ::rtl::OUString::createFromAscii(" IDENTIFIED BY '"); in appendObject()
89 aSql += sPassword; in appendObject()
90 aSql += ::rtl::OUString::createFromAscii("'"); in appendObject()
95 xStmt->execute(aSql); in appendObject()
104 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("REVOKE ALL ON * FROM "); in dropObject()
106 aSql += ::dbtools::quoteName(aQuote,_sElementName); in dropObject()
110 xStmt->execute(aSql); in dropObject()
H A DYViews.cxx111 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("DROP VIEW"); in dropObject()
114 …aSql += ::dbtools::composeTableName( m_xMetaData, xProp, ::dbtools::eInTableDefinitions, false, fa… in dropObject()
118 xStmt->execute(aSql); in dropObject()
134 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("CREATE VIEW "); in createView()
138 …aSql += ::dbtools::composeTableName( m_xMetaData, descriptor, ::dbtools::eInTableDefinitions, fals… in createView()
140 aSql += ::rtl::OUString::createFromAscii(" AS "); in createView()
142 aSql += sCommand; in createView()
147 xStmt->execute(aSql); in createView()
H A DYTables.cxx155 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("DROP "); in dropObject()
160 aSql += ::rtl::OUString::createFromAscii("VIEW "); in dropObject()
162 aSql += ::rtl::OUString::createFromAscii("TABLE "); in dropObject()
166 aSql += sComposedName; in dropObject()
170 xStmt->execute(aSql); in dropObject()
203 …const ::rtl::OUString aSql = adjustSQL(::dbtools::createSqlCreateTableStatement(descriptor,xConnec… in createTable() local
207 xStmt->execute(aSql); in createTable()
/trunk/main/dbaccess/source/ui/misc/
H A DDExport.cxx842 ::rtl::OUString aSql(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("INSERT INTO "))); in createPreparedStatment()
845 aSql += sComposedTableName; in createPreparedStatment()
846 aSql += ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(" ( ")); in createPreparedStatment()
886 aSql += *aInsertIter; in createPreparedStatment()
887 aSql += aComma; in createPreparedStatment()
892 aSql = aSql.replaceAt(aSql.getLength()-1,1,::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(")"))); in createPreparedStatment()
895 aSql += aValues; in createPreparedStatment()
897 return Reference< XPreparedStatement >(_xMetaData->getConnection()->prepareStatement(aSql)); in createPreparedStatment()

Completed in 162 milliseconds

12