dbaccess/source/ui/dlg/tablespage.cxx

   1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
   2 /*************************************************************************
   3  *
   4  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   5  *
   6  * Copyright 2000, 2010 Oracle and/or its affiliates.
   7  *
   8  * OpenOffice.org - a multi-platform office productivity suite
   9  *
  10  * This file is part of OpenOffice.org.
  11  *
  12  * OpenOffice.org is free software: you can redistribute it and/or modify
  13  * it under the terms of the GNU Lesser General Public License version 3
  14  * only, as published by the Free Software Foundation.
  15  *
  16  * OpenOffice.org is distributed in the hope that it will be useful,
  17  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  18  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  19  * GNU Lesser General Public License version 3 for more details
  20  * (a copy is included in the LICENSE file that accompanied this code).
  21  *
  22  * You should have received a copy of the GNU Lesser General Public License
  23  * version 3 along with OpenOffice.org.  If not, see
  24  * <http://www.openoffice.org/license.html>
  25  * for a copy of the LGPLv3 License.
  26  *
  27  ************************************************************************/
  28
  29
  30 #include "tablespage.hxx"
  31 #include "dbu_dlg.hrc"
  32 #include "dbadmin.hrc"
  33 #include "dsitems.hxx"
  34 #include "browserids.hxx"
  35 #include "datasourceconnector.hxx"
  36 #include <comphelper/types.hxx>
  37 #include <connectivity/dbtools.hxx>
  38 #include <connectivity/dbexception.hxx>
  39 #include "stringlistitem.hxx"
  40 #include <svl/eitem.hxx>
  41 #include <svl/stritem.hxx>
  42 #include "dbustrings.hrc"
  43 #include <vcl/svapp.hxx>
  44 #include <vcl/waitobj.hxx>
  45 #include <com/sun/star/sdb/SQLContext.hpp>
  46 #include <com/sun/star/sdbcx/XTablesSupplier.hpp>
  47 #include <com/sun/star/sdbcx/XAppend.hpp>
  48 #include <com/sun/star/util/XModifiable.hpp>
  49 #include <com/sun/star/sdbcx/XDrop.hpp>
  50 #include <com/sun/star/sdbcx/XDataDefinitionSupplier.hpp>
  51 #include "sqlmessage.hxx"
  52 #include <vcl/msgbox.hxx>
  53 #include "dbaccess_helpid.hrc"
  54 #include "UITools.hxx"
  55 #include <osl/mutex.hxx>
  56 #include <osl/diagnose.h>
  57 #include <svtools/imgdef.hxx>
  58 #include "TablesSingleDlg.hxx"
  59 #include <tools/diagnose_ex.h>
  60 #include <cppuhelper/exc_hlp.hxx>
  61 #include "AutoControls.hrc"
  62
  63 //.........................................................................
  64 namespace dbaui
  65 {
  66 //.........................................................................
  67
  68     using namespace ::com::sun::star::uno;
  69     using namespace ::com::sun::star::sdbc;
  70     using namespace ::com::sun::star::sdbcx;
  71     using namespace ::com::sun::star::sdb;
  72     using namespace ::com::sun::star::beans;
  73     using namespace ::com::sun::star::lang;
  74     using namespace ::com::sun::star::i18n;
  75     using namespace ::com::sun::star::container;
  76     using namespace ::com::sun::star::frame;
  77     using namespace ::com::sun::star::util;
  78     using namespace ::dbtools;
  79     using namespace ::comphelper;
  80
  81     //========================================================================
  82     //= OTableSubscriptionPage
  83     //========================================================================
  84 DBG_NAME(OTableSubscriptionPage)
  85 //------------------------------------------------------------------------
  86     OTableSubscriptionPage::OTableSubscriptionPage( Window* pParent, const SfxItemSet& _rCoreAttrs,OTableSubscriptionDialog* _pTablesDlg )
  87         :OGenericAdministrationPage( pParent, ModuleRes(PAGE_TABLESUBSCRIPTION), _rCoreAttrs )
  88         ,m_aTables              (this, ModuleRes(FL_SEPARATOR1))
  89         ,m_aTablesList          (this, NULL,ModuleRes(CTL_TABLESUBSCRIPTION),sal_True)
  90         ,m_aExplanation         (this, ModuleRes(FT_FILTER_EXPLANATION))
  91         ,m_bCheckedAll          ( sal_False )
  92         ,m_bCatalogAtStart      ( sal_True )
  93         ,m_pTablesDlg(_pTablesDlg)
  94     {
  95         DBG_CTOR(OTableSubscriptionPage,NULL);
  96
  97         m_aTablesList.SetCheckHandler(getControlModifiedLink());
  98
  99         // initialize the TabListBox
 100         m_aTablesList.SetSelectionMode( MULTIPLE_SELECTION );
 101         m_aTablesList.SetDragDropMode( 0 );
 102         m_aTablesList.EnableInplaceEditing( sal_False );
 103         m_aTablesList.SetStyle(m_aTablesList.GetStyle() | WB_BORDER | WB_HASLINES | WB_HASLINESATROOT | WB_SORT | WB_HASBUTTONS | WB_HSCROLL |WB_HASBUTTONSATROOT);
 104
 105         m_aTablesList.Clear();
 106
 107         FreeResource();
 108
 109         m_aTablesList.SetCheckButtonHdl(LINK(this, OTableSubscriptionPage, OnTreeEntryChecked));
 110         m_aTablesList.SetCheckHandler(LINK(this, OTableSubscriptionPage, OnTreeEntryChecked));
 111     }
 112
 113     //------------------------------------------------------------------------
 114     OTableSubscriptionPage::~OTableSubscriptionPage()
 115     {
 116         // just to make sure that our connection will be removed
 117         try
 118         {
 119             ::comphelper::disposeComponent(m_xCurrentConnection);
 120         }
 121         catch (RuntimeException&) { }
 122
 123         DBG_DTOR(OTableSubscriptionPage,NULL);
 124     }
 125
 126     // -----------------------------------------------------------------------------
 127     void OTableSubscriptionPage::StateChanged( StateChangedType nType )
 128     {
 129         OGenericAdministrationPage::StateChanged( nType );
 130
 131         if ( nType == STATE_CHANGE_CONTROLBACKGROUND )
 132         {
 133             // Check if we need to get new images for normal/high contrast mode
 134             m_aTablesList.notifyHiContrastChanged();
 135         }
 136     }
 137     // -----------------------------------------------------------------------------
 138     void OTableSubscriptionPage::DataChanged( const DataChangedEvent& rDCEvt )
 139     {
 140         OGenericAdministrationPage::DataChanged( rDCEvt );
 141
 142         if ((( rDCEvt.GetType() == DATACHANGED_SETTINGS )   ||
 143             ( rDCEvt.GetType() == DATACHANGED_DISPLAY   ))  &&
 144             ( rDCEvt.GetFlags() & SETTINGS_STYLE        ))
 145         {
 146             // Check if we need to get new images for normal/high contrast mode
 147             m_aTablesList.notifyHiContrastChanged();
 148         }
 149     }
 150     //------------------------------------------------------------------
 151     void OTableSubscriptionPage::resizeControls(const Size& _rDiff)
 152     {
 153         if ( _rDiff.Height() )
 154         {
 155             Size aOldSize = m_aTablesList.GetSizePixel();
 156             aOldSize.Height() -= _rDiff.Height();
 157             m_aTablesList.SetPosSizePixel(
 158                     m_aTablesList.GetPosPixel()+Point(0,_rDiff.Height()),
 159                     aOldSize
 160                     );
 161         }
 162     }
 163     //------------------------------------------------------------------------
 164     void OTableSubscriptionPage::implCheckTables(const Sequence< ::rtl::OUString >& _rTables)
 165     {
 166         // the meta data for the current connection, used for splitting up table names
 167         Reference< XDatabaseMetaData > xMeta;
 168         try
 169         {
 170             if (m_xCurrentConnection.is())
 171                 xMeta = m_xCurrentConnection->getMetaData();
 172         }
 173         catch(SQLException&)
 174         {
 175             OSL_FAIL("OTableSubscriptionPage::implCheckTables : could not retrieve the current connection's meta data!");
 176         }
 177
 178         // uncheck all
 179         CheckAll(sal_False);
 180
 181         // check the ones which are in the list
 182         String aListBoxTable;
 183         ::rtl::OUString sCatalog, sSchema, sName;
 184
 185         SvLBoxEntry* pRootEntry = m_aTablesList.getAllObjectsEntry();
 186         sal_Bool bAllTables = sal_False;
 187         sal_Bool bAllSchemas = sal_False;
 188
 189         const ::rtl::OUString* pIncludeTable = _rTables.getConstArray();
 190         for (sal_Int32 i=0; i<_rTables.getLength(); ++i, ++pIncludeTable)
 191         {
 192             if (xMeta.is())
 193                 qualifiedNameComponents(xMeta, pIncludeTable->getStr(), sCatalog, sSchema, sName,::dbtools::eInDataManipulation);
 194             else
 195                 sName = pIncludeTable->getStr();
 196
 197             bAllTables = (1 == sName.getLength()) && ('%' == sName[0]);
 198             bAllSchemas = (1 == sSchema.getLength()) && ('%' == sSchema[0]);
 199
 200             // the catalog entry
 201             SvLBoxEntry* pCatalog = m_aTablesList.GetEntryPosByName(sCatalog, pRootEntry);
 202             if (!(pCatalog || sCatalog.isEmpty()))
 203                 // the table (resp. its catalog) refered in this filter entry does not exist anymore
 204                 continue;
 205
 206             if (bAllSchemas && pCatalog)
 207             {
 208                 m_aTablesList.checkWildcard(pCatalog);
 209                 continue;
 210             }
 211
 212             // the schema entry
 213             SvLBoxEntry* pSchema = m_aTablesList.GetEntryPosByName(sSchema, (pCatalog ? pCatalog : pRootEntry));
 214             if (!(pSchema || sSchema.isEmpty()))
 215                 // the table (resp. its schema) refered in this filter entry does not exist anymore
 216                 continue;
 217
 218             if (bAllTables && pSchema)
 219             {
 220                 m_aTablesList.checkWildcard(pSchema);
 221                 continue;
 222             }
 223
 224             SvLBoxEntry* pEntry = m_aTablesList.GetEntryPosByName(sName, pSchema ? pSchema : (pCatalog ? pCatalog : pRootEntry) );
 225             if (pEntry)
 226                 m_aTablesList.SetCheckButtonState(pEntry, SV_BUTTON_CHECKED);
 227         }
 228         m_aTablesList.CheckButtons();
 229     }
 230
 231     //------------------------------------------------------------------------
 232     void OTableSubscriptionPage::implCompleteTablesCheck( const ::com::sun::star::uno::Sequence< ::rtl::OUString >& _rTableFilter )
 233     {
 234         if (!_rTableFilter.getLength())
 235         {   // no tables visible
 236             CheckAll(sal_False);
 237         }
 238         else
 239         {
 240             if ((1 == _rTableFilter.getLength()) && _rTableFilter[0].equalsAsciiL("%", 1))
 241             {   // all tables visible
 242                 CheckAll(sal_True);
 243             }
 244             else
 245                 implCheckTables( _rTableFilter );
 246         }
 247     }
 248
 249     //-------------------------------------------------------------------------
 250     void OTableSubscriptionPage::implInitControls(const SfxItemSet& _rSet, sal_Bool _bSaveValue)
 251     {
 252         // check whether or not the selection is invalid or readonly (invalid implies readonly, but not vice versa)
 253         sal_Bool bValid, bReadonly;
 254         getFlags(_rSet, bValid, bReadonly);
 255
 256         // get the name of the data source we're working for
 257         SFX_ITEMSET_GET(_rSet, pNameItem, SfxStringItem, DSID_NAME, sal_True);
 258         OSL_ENSURE(pNameItem, "OTableSubscriptionPage::implInitControls: missing the name attribute!");
 259         String sDSName = pNameItem->GetValue();
 260
 261         if (bValid && sDSName.Len() && !m_xCurrentConnection.is() )
 262         {   // get the current table list from the connection for the current settings
 263
 264             // the PropertyValues for the current dialog settings
 265             Sequence< PropertyValue > aConnectionParams;
 266             OSL_ENSURE(m_pTablesDlg, "OTableSubscriptionPage::implInitControls: need a parent dialog doing the translation!");
 267             if ( m_pTablesDlg )
 268             {
 269                 if (!m_pTablesDlg->getCurrentSettings(aConnectionParams))
 270                 {
 271                     m_aTablesList.Clear();
 272                     m_pTablesDlg->endExecution();
 273                     return;
 274                 }
 275             }
 276
 277             if (!m_xCollator.is())
 278             {
 279                 // the collator for the string compares
 280                 try
 281                 {
 282                     m_xCollator = Reference< XCollator >(m_xORB->createInstance(SERVICE_I18N_COLLATOR), UNO_QUERY);
 283                     if (m_xCollator.is())
 284                         m_xCollator->loadDefaultCollator(Application::GetSettings().GetLocale(), 0);
 285                 }
 286                 catch(const Exception&)
 287                 {
 288                     DBG_UNHANDLED_EXCEPTION();
 289                 }
 290             }
 291
 292             // fill the table list with this connection information
 293             SQLExceptionInfo aErrorInfo;
 294             // the current DSN
 295             String sURL;
 296             if ( m_pTablesDlg )
 297                 sURL = m_pTablesDlg->getConnectionURL();
 298
 299             try
 300             {
 301                 WaitObject aWaitCursor(this);
 302                 m_aTablesList.GetModel()->SetSortMode(SortAscending);
 303                 m_aTablesList.GetModel()->SetCompareHdl(LINK(this, OTableSubscriptionPage, OnTreeEntryCompare));
 304
 305                 Reference< XDriver > xDriver;
 306                 m_aTablesList.setORB(m_xORB);
 307                 Reference<XPropertySet> xProp = m_pTablesDlg->getCurrentDataSource();
 308                 OSL_ENSURE(xProp.is(),"No data source set!");
 309                 if ( xProp.is() )
 310                 {
 311                     Any aTableFilter = xProp->getPropertyValue(PROPERTY_TABLEFILTER);
 312                     Any aTableTypeFilter = xProp->getPropertyValue(PROPERTY_TABLETYPEFILTER);
 313
 314                     Reference<XModifiable> xModi(getDataSourceOrModel(xProp),UNO_QUERY);
 315                     sal_Bool bModified = ( xModi.is() && xModi->isModified() );
 316
 317                     Sequence< ::rtl::OUString > aNewTableFilter(1);
 318                     aNewTableFilter[0] = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("%"));
 319                     xProp->setPropertyValue(PROPERTY_TABLEFILTER,makeAny(aNewTableFilter));
 320
 321                     xProp->setPropertyValue( PROPERTY_TABLETYPEFILTER, makeAny( Sequence< ::rtl::OUString >() ) );
 322                     Reference< ::com::sun::star::lang::XEventListener> xEvt;
 323                     aErrorInfo = ::dbaui::createConnection(xProp,m_xORB,xEvt,m_xCurrentConnection);
 324
 325                     xProp->setPropertyValue(PROPERTY_TABLEFILTER,aTableFilter);
 326                     xProp->setPropertyValue(PROPERTY_TABLETYPEFILTER,aTableTypeFilter);
 327
 328                     if ( xModi.is() && !bModified )
 329                         xModi->setModified(sal_False);
 330
 331                 }
 332
 333                 if ( m_xCurrentConnection.is() )
 334                 {
 335                     m_aTablesList.UpdateTableList( m_xCurrentConnection );
 336                     if (m_pTablesDlg)
 337                         m_pTablesDlg->successfullyConnected();
 338                 }
 339             }
 340             catch (const SQLException&)
 341             {
 342                 aErrorInfo = ::cppu::getCaughtException();
 343             }
 344
 345             if (aErrorInfo.isValid())
 346             {
 347                 // establishing the connection failed. Show an error window and exit.
 348                 OSQLMessageBox aMessageBox( GetParent()->GetParent(), aErrorInfo );
 349                 aMessageBox.Execute();
 350                 m_aTables.Enable(sal_False);
 351                 m_aTablesList.Enable(sal_False);
 352                 m_aExplanation.Enable(sal_False);
 353                 m_aTablesList.Clear();
 354
 355                 if ( m_pTablesDlg )
 356                 {
 357                     m_pTablesDlg->clearPassword();
 358                     m_pTablesDlg->endExecution();
 359                 }
 360             }
 361             else
 362             {
 363                 // in addition, we need some infos about the connection used
 364                 m_sCatalogSeparator = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("."));    // (default)
 365                 m_bCatalogAtStart = sal_True;   // (default)
 366                 try
 367                 {
 368                     Reference< XDatabaseMetaData > xMeta;
 369                     if (m_xCurrentConnection.is())
 370                         xMeta = m_xCurrentConnection->getMetaData();
 371                     if (xMeta.is() && xMeta->supportsCatalogsInDataManipulation())
 372                     {
 373                         m_sCatalogSeparator = xMeta->getCatalogSeparator();
 374                         m_bCatalogAtStart = xMeta->isCatalogAtStart();
 375                     }
 376                 }
 377                 catch(Exception&)
 378                 {
 379                     DBG_UNHANDLED_EXCEPTION();
 380                 }
 381             }
 382         }
 383
 384         bValid = bValid && m_xCurrentConnection.is();
 385         bReadonly = bReadonly || !bValid;
 386
 387         // get the current table filter
 388         SFX_ITEMSET_GET(_rSet, pTableFilter, OStringListItem, DSID_TABLEFILTER, sal_True);
 389         Sequence< ::rtl::OUString > aTableFilter;
 390         if (pTableFilter)
 391             aTableFilter = pTableFilter->getList();
 392
 393         implCompleteTablesCheck( aTableFilter );
 394
 395         // expand the first entry by default
 396         SvLBoxEntry* pExpand = m_aTablesList.getAllObjectsEntry();
 397         while (pExpand)
 398         {
 399             m_aTablesList.Expand(pExpand);
 400             pExpand = m_aTablesList.FirstChild(pExpand);
 401             if (pExpand && m_aTablesList.NextSibling(pExpand))
 402                 pExpand = NULL;
 403         }
 404
 405         // update the toolbox according the the current selection and check state
 406         OGenericAdministrationPage::implInitControls(_rSet, _bSaveValue);
 407     }
 408
 409     //------------------------------------------------------------------------
 410     void OTableSubscriptionPage::CheckAll( sal_Bool _bCheck )
 411     {
 412         SvButtonState eState = _bCheck ? SV_BUTTON_CHECKED : SV_BUTTON_UNCHECKED;
 413         SvLBoxEntry* pEntry = m_aTablesList.First();
 414         while (pEntry)
 415         {
 416             m_aTablesList.SetCheckButtonState( pEntry, eState);
 417             pEntry = m_aTablesList.Next(pEntry);
 418         }
 419
 420         if (_bCheck && m_aTablesList.getAllObjectsEntry())
 421             m_aTablesList.checkWildcard(m_aTablesList.getAllObjectsEntry());
 422     }
 423
 424     //------------------------------------------------------------------------
 425     int OTableSubscriptionPage::DeactivatePage(SfxItemSet* _pSet)
 426     {
 427         int nResult = OGenericAdministrationPage::DeactivatePage(_pSet);
 428
 429         // dispose the connection, we don't need it anymore, so we're not wasting resources
 430         try
 431         {
 432             ::comphelper::disposeComponent(m_xCurrentConnection);
 433         }
 434         catch (RuntimeException&) { }
 435
 436         return nResult;
 437     }
 438     //------------------------------------------------------------------------
 439     IMPL_LINK( OTableSubscriptionPage, OnTreeEntryChecked, Control*, _pControl )
 440     {
 441         return OnControlModified(_pControl);
 442     }
 443     //------------------------------------------------------------------------
 444     IMPL_LINK( OTableSubscriptionPage, OnTreeEntryCompare, const SvSortData*, _pSortData )
 445     {
 446         SvLBoxEntry* pLHS = static_cast<SvLBoxEntry*>(_pSortData->pLeft);
 447         SvLBoxEntry* pRHS = static_cast<SvLBoxEntry*>(_pSortData->pRight);
 448         OSL_ENSURE(pLHS && pRHS, "SbaTableQueryBrowser::OnTreeEntryCompare: invalid tree entries!");
 449
 450         SvLBoxString* pLeftTextItem = static_cast<SvLBoxString*>(pLHS->GetFirstItem(SV_ITEM_ID_LBOXSTRING));
 451         SvLBoxString* pRightTextItem = static_cast<SvLBoxString*>(pRHS->GetFirstItem(SV_ITEM_ID_LBOXSTRING));
 452         OSL_ENSURE(pLeftTextItem && pRightTextItem, "SbaTableQueryBrowser::OnTreeEntryCompare: invalid text items!");
 453
 454         String sLeftText = pLeftTextItem->GetText();
 455         String sRightText = pRightTextItem->GetText();
 456
 457         sal_Int32 nCompareResult = 0;   // equal by default
 458
 459         if (m_xCollator.is())
 460         {
 461             try
 462             {
 463                 nCompareResult = m_xCollator->compareString(sLeftText, sRightText);
 464             }
 465             catch(Exception&)
 466             {
 467             }
 468         }
 469         else
 470             // default behaviour if we do not have a collator -> do the simple string compare
 471             nCompareResult = sLeftText.CompareTo(sRightText);
 472
 473         return nCompareResult;
 474     }
 475
 476     //------------------------------------------------------------------------
 477     Sequence< ::rtl::OUString > OTableSubscriptionPage::collectDetailedSelection() const
 478     {
 479         Sequence< ::rtl::OUString > aTableFilter;
 480         static const ::rtl::OUString sDot(RTL_CONSTASCII_USTRINGPARAM("."));
 481         static const ::rtl::OUString sWildcard(RTL_CONSTASCII_USTRINGPARAM("%"));
 482
 483         ::rtl::OUString sComposedName;
 484         const SvLBoxEntry* pAllObjectsEntry = m_aTablesList.getAllObjectsEntry();
 485         if (!pAllObjectsEntry)
 486             return aTableFilter;
 487         SvLBoxEntry* pEntry = m_aTablesList.GetModel()->Next(const_cast<SvLBoxEntry*>(pAllObjectsEntry));
 488         while(pEntry)
 489         {
 490             sal_Bool bCatalogWildcard = sal_False;
 491             sal_Bool bSchemaWildcard =  sal_False;
 492             SvLBoxEntry* pSchema = NULL;
 493             SvLBoxEntry* pCatalog = NULL;
 494
 495             if (m_aTablesList.GetCheckButtonState(pEntry) == SV_BUTTON_CHECKED && !m_aTablesList.GetModel()->HasChildren(pEntry))
 496             {   // checked and a leaf, which means it's no catalog, no schema, but a real table
 497                 ::rtl::OUString sCatalog;
 498                 if(m_aTablesList.GetModel()->HasParent(pEntry))
 499                 {
 500                     pSchema = m_aTablesList.GetModel()->GetParent(pEntry);
 501                     if (pAllObjectsEntry == pSchema)
 502                         // do not want to have the root entry
 503                         pSchema = NULL;
 504
 505                     if (pSchema)
 506                     {   // it's a real schema entry, not the "all objects" root
 507                         if(m_aTablesList.GetModel()->HasParent(pSchema))
 508                         {
 509                             pCatalog = m_aTablesList.GetModel()->GetParent(pSchema);
 510                             if (pAllObjectsEntry == pCatalog)
 511                                 // do not want to have the root entry
 512                                 pCatalog = NULL;
 513
 514                             if (pCatalog)
 515                             {   // it's a real catalog entry, not the "all objects" root
 516                                 bCatalogWildcard = m_aTablesList.isWildcardChecked(pCatalog);
 517                                 if (m_bCatalogAtStart)
 518                                 {
 519                                     sComposedName += m_aTablesList.GetEntryText( pCatalog );
 520                                     sComposedName += m_sCatalogSeparator;
 521                                     if (bCatalogWildcard)
 522                                         sComposedName += sWildcard;
 523                                 }
 524                                 else
 525                                 {
 526                                     if (bCatalogWildcard)
 527                                         sCatalog = sWildcard;
 528                                     else
 529                                         sCatalog = ::rtl::OUString();
 530                                     sCatalog += m_sCatalogSeparator;
 531                                     sCatalog += m_aTablesList.GetEntryText( pCatalog );
 532                                 }
 533                             }
 534                         }
 535                         bSchemaWildcard = m_aTablesList.isWildcardChecked(pSchema);
 536                         sComposedName += m_aTablesList.GetEntryText( pSchema );
 537                         sComposedName += sDot;
 538                     }
 539
 540                     if (bSchemaWildcard)
 541                         sComposedName += sWildcard;
 542                 }
 543                 if (!bSchemaWildcard && !bCatalogWildcard)
 544                     sComposedName += m_aTablesList.GetEntryText( pEntry );
 545
 546                 if (!m_bCatalogAtStart && !bCatalogWildcard)
 547                     sComposedName += sCatalog;
 548
 549                 // need some space
 550                 sal_Int32 nOldLen = aTableFilter.getLength();
 551                 aTableFilter.realloc(nOldLen + 1);
 552                 // add the new name
 553                 aTableFilter[nOldLen] = sComposedName;
 554
 555                 // reset the composed name
 556                 sComposedName = ::rtl::OUString();
 557             }
 558
 559             if (bCatalogWildcard)
 560                 pEntry = implNextSibling(pCatalog);
 561             else if (bSchemaWildcard)
 562                 pEntry = implNextSibling(pSchema);
 563             else
 564                 pEntry = m_aTablesList.GetModel()->Next(pEntry);
 565         }
 566
 567         return aTableFilter;
 568     }
 569
 570     //------------------------------------------------------------------------
 571     SvLBoxEntry* OTableSubscriptionPage::implNextSibling(SvLBoxEntry* _pEntry) const
 572     {
 573         SvLBoxEntry* pReturn = NULL;
 574         if (_pEntry)
 575         {
 576             pReturn = m_aTablesList.NextSibling(_pEntry);
 577             if (!pReturn)
 578                 pReturn = implNextSibling(m_aTablesList.GetParent(_pEntry));
 579         }
 580         return pReturn;
 581     }
 582
 583     //------------------------------------------------------------------------
 584     sal_Bool OTableSubscriptionPage::FillItemSet( SfxItemSet& _rCoreAttrs )
 585     {
 586         sal_Bool bValid, bReadonly;
 587         getFlags(_rCoreAttrs, bValid, bReadonly);
 588
 589         if (!bValid || bReadonly)
 590             // don't store anything if the data we're working with is invalid or readonly
 591             return sal_True;
 592
 593         /////////////////////////////////////////////////////////////////////////
 594         // create the output string which contains all the table names
 595         if ( m_xCurrentConnection.is() )
 596         {   // collect the table filter data only if we have a connection - else no tables are displayed at all
 597             Sequence< ::rtl::OUString > aTableFilter;
 598             if (m_aTablesList.isWildcardChecked(m_aTablesList.getAllObjectsEntry()))
 599             {
 600                 aTableFilter.realloc(1);
 601                 aTableFilter[0] = ::rtl::OUString("%", 1, RTL_TEXTENCODING_ASCII_US);
 602             }
 603             else
 604             {
 605                 aTableFilter = collectDetailedSelection();
 606             }
 607             _rCoreAttrs.Put( OStringListItem(DSID_TABLEFILTER, aTableFilter) );
 608         }
 609
 610         return sal_True;
 611     }
 612
 613     // -----------------------------------------------------------------------
 614     void OTableSubscriptionPage::fillControls(::std::vector< ISaveValueWrapper* >& /*_rControlList*/)
 615     {
 616     }
 617     // -----------------------------------------------------------------------
 618     void OTableSubscriptionPage::fillWindows(::std::vector< ISaveValueWrapper* >& _rControlList)
 619     {
 620         _rControlList.push_back(new ODisableWrapper<OTableTreeListBox>(&m_aTablesList));
 621         _rControlList.push_back(new ODisableWrapper<FixedLine>(&m_aTables));
 622         _rControlList.push_back(new ODisableWrapper<FixedText>(&m_aExplanation));
 623     }
 624     // -----------------------------------------------------------------------
 625 //.........................................................................
 626 }   // namespace dbaui
 627 //.........................................................................
 628
 629 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */