dbaccess/source/ui/dlg/generalpage.cxx

   1 /*************************************************************************
   2  *
   3  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   4  *
   5  * Copyright 2008 by Sun Microsystems, Inc.
   6  *
   7  * OpenOffice.org - a multi-platform office productivity suite
   8  *
   9  * $RCSfile: generalpage.cxx,v $
  10  * $Revision: 1.56.68.2 $
  11  *
  12  * This file is part of OpenOffice.org.
  13  *
  14  * OpenOffice.org is free software: you can redistribute it and/or modify
  15  * it under the terms of the GNU Lesser General Public License version 3
  16  * only, as published by the Free Software Foundation.
  17  *
  18  * OpenOffice.org is distributed in the hope that it will be useful,
  19  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  20  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  21  * GNU Lesser General Public License version 3 for more details
  22  * (a copy is included in the LICENSE file that accompanied this code).
  23  *
  24  * You should have received a copy of the GNU Lesser General Public License
  25  * version 3 along with OpenOffice.org.  If not, see
  26  * <http://www.openoffice.org/license.html>
  27  * for a copy of the LGPLv3 License.
  28  *
  29  ************************************************************************/
  30
  31 // MARKER(update_precomp.py): autogen include statement, do not remove
  32 #include "precompiled_dbaccess.hxx"
  33
  34 #include "dsnItem.hxx"
  35 #include "generalpage.hxx"
  36 #include <connectivity/dbexception.hxx>
  37 #include "dbu_dlg.hrc"
  38 #include "dbadmin.hrc"
  39 #include "dsitems.hxx"
  40 #include "dbustrings.hrc"
  41 #include "dbadmin.hxx"
  42 #include <sfx2/filedlghelper.hxx>
  43 #include <sfx2/docfilt.hxx>
  44 #include <vcl/stdtext.hxx>
  45 #include "localresaccess.hxx"
  46 #include <vcl/msgbox.hxx>
  47 #include <svtools/stritem.hxx>
  48 #include <vcl/waitobj.hxx>
  49 #include <com/sun/star/sdbc/XDriverAccess.hpp>
  50 #include <com/sun/star/beans/PropertyValue.hpp>
  51 #include <com/sun/star/uno/Sequence.hxx>
  52 #include <com/sun/star/container/XNameAccess.hpp>
  53 #include "DriverSettings.hxx"
  54 #include "UITools.hxx"
  55 #include <comphelper/processfactory.hxx>
  56 #include <unotools/confignode.hxx>
  57
  58 //.........................................................................
  59 namespace dbaui
  60 {
  61 //.........................................................................
  62     using namespace ::com::sun::star::uno;
  63     using namespace ::com::sun::star::sdbc;
  64     using namespace ::com::sun::star::beans;
  65     using namespace ::com::sun::star::container;
  66
  67     //=========================================================================
  68     //= OGeneralPage
  69     //=========================================================================
  70     //-------------------------------------------------------------------------
  71     OGeneralPage::OGeneralPage(Window* pParent, const SfxItemSet& _rItems, sal_Bool _bDBWizardMode)
  72         :OGenericAdministrationPage(pParent, ModuleRes(PAGE_GENERAL), _rItems)
  73         ,m_aFTHeaderText                (this, ModuleRes(FT_GENERALHEADERTEXT))
  74         ,m_aFTHelpText                  (this, ModuleRes(FT_GENERALHELPTEXT))
  75         ,m_aFT_DatasourceTypeHeader     (this, ModuleRes(FT_DATASOURCEHEADER))
  76         ,m_aRB_CreateDatabase           (this, ModuleRes(RB_CREATEDBDATABASE))
  77         ,m_aRB_OpenDocument             (this, ModuleRes(RB_OPENEXISTINGDOC))
  78         ,m_aRB_GetExistingDatabase      (this, ModuleRes(RB_GETEXISTINGDATABASE))
  79         ,m_aFT_DocListLabel             (this, ModuleRes(FT_DOCLISTLABEL))
  80         ,m_pLB_DocumentList             ( new OpenDocumentListBox( this, "com.sun.star.sdb.OfficeDatabaseDocument", ModuleRes( LB_DOCUMENTLIST ) ) )
  81         ,m_aPB_OpenDocument             (this, "com.sun.star.sdb.OfficeDatabaseDocument", ModuleRes(PB_OPENDOCUMENT))
  82         ,m_aTypePreLabel                        (this, ModuleRes(FT_DATASOURCETYPE_PRE))
  83         ,m_aDatasourceTypeLabel         (this, ModuleRes(FT_DATATYPE))
  84         ,m_pDatasourceType                      ( new ListBox(this, ModuleRes(LB_DATATYPE)))
  85         ,m_aFTDataSourceAppendix        (this, ModuleRes(FT_DATATYPEAPPENDIX))
  86         ,m_aTypePostLabel                       (this, ModuleRes(FT_DATASOURCETYPE_POST))
  87         ,m_aSpecialMessage                      (this, ModuleRes(FT_SPECIAL_MESSAGE))
  88         ,m_DBWizardMode                 (_bDBWizardMode)
  89         ,m_sMySQLEntry                                  (ModuleRes(STR_MYSQLENTRY))
  90         ,m_eOriginalCreationMode        (eCreateNew)
  91         ,m_pCollection                  (NULL)
  92         ,m_eNotSupportedKnownType       ( ::dbaccess::DST_UNKNOWN)
  93         ,m_eLastMessage                 (smNone)
  94         ,m_bDisplayingInvalid           (sal_False)
  95         ,m_bUserGrabFocus               (sal_True)
  96         ,m_bInitTypeList                (true)
  97     {
  98         // fill the listbox with the UI descriptions for the possible types
  99         // and remember the respective DSN prefixes
 100         FreeResource();
 101         // extract the datasource type collection from the item set
 102         DbuTypeCollectionItem* pCollectionItem = PTR_CAST(DbuTypeCollectionItem, _rItems.GetItem(DSID_TYPECOLLECTION));
 103         if (pCollectionItem)
 104             m_pCollection = pCollectionItem->getCollection();
 105         DBG_ASSERT(m_pCollection, "OGeneralPage::OGeneralPage : really need a DSN type collection !");
 106
 107         // If no driver for embedded DBs is installed, and no dBase driver, then hide the "Create new database" option
 108         sal_Int32 nCreateNewDBIndex = m_pCollection->getIndexOf( m_pCollection->getEmbeddedDatabase() );
 109         if ( nCreateNewDBIndex == -1 )
 110             nCreateNewDBIndex = m_pCollection->getIndexOf( ::rtl::OUString::createFromAscii( "sdbc:dbase:" ) );
 111         bool bHideCreateNew = ( nCreateNewDBIndex == -1 );
 112
 113         // also, if our application policies tell us to hide the option, do it
 114         ::utl::OConfigurationTreeRoot aConfig( ::utl::OConfigurationTreeRoot::createWithServiceFactory(
 115             ::comphelper::getProcessServiceFactory(),
 116             ::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "/org.openoffice.Office.DataAccess/Policies/Features/Base" ) )
 117         ) );
 118         sal_Bool bAllowCreateLocalDatabase( sal_True );
 119         OSL_VERIFY( aConfig.getNodeValue( "CreateLocalDatabase" ) >>= bAllowCreateLocalDatabase );
 120         if ( !bAllowCreateLocalDatabase )
 121             bHideCreateNew = true;
 122
 123         if ( bHideCreateNew )
 124         {
 125             m_aRB_CreateDatabase.Hide();
 126             Window* pWindowsToMove[] = {
 127                 &m_aRB_OpenDocument, &m_aRB_GetExistingDatabase, &m_aFT_DocListLabel, m_pLB_DocumentList.get(),
 128                 &m_aPB_OpenDocument, &m_aDatasourceTypeLabel, m_pDatasourceType.get(), &m_aFTDataSourceAppendix,
 129                 &m_aTypePostLabel
 130             };
 131             const long nOffset = m_aRB_OpenDocument.GetPosPixel().Y() - m_aRB_CreateDatabase.GetPosPixel().Y();
 132             for ( size_t i=0; i < sizeof( pWindowsToMove ) / sizeof( pWindowsToMove[0] ); ++i )
 133             {
 134                 Point aPos( pWindowsToMove[i]->GetPosPixel() );
 135                 aPos.Y() -= nOffset;
 136                 pWindowsToMove[i]->SetPosPixel( aPos );
 137             }
 138         }
 139
 140         if ( bHideCreateNew )
 141             m_aRB_GetExistingDatabase.Check();
 142         else
 143             m_aRB_CreateDatabase.Check();
 144
 145         // do some knittings
 146         m_pDatasourceType->SetSelectHdl(LINK(this, OGeneralPage, OnDatasourceTypeSelected));
 147            m_aRB_CreateDatabase.SetClickHdl(LINK(this, OGeneralPage, OnSetupModeSelected));
 148            m_aRB_GetExistingDatabase.SetClickHdl(LINK(this, OGeneralPage, OnSetupModeSelected));
 149            m_aRB_OpenDocument.SetClickHdl(LINK(this, OGeneralPage, OnSetupModeSelected));
 150         m_pLB_DocumentList->SetSelectHdl( LINK( this, OGeneralPage, OnDocumentSelected ) );
 151         m_aPB_OpenDocument.SetClickHdl( LINK( this, OGeneralPage, OnOpenDocument ) );
 152     }
 153
 154     //-------------------------------------------------------------------------
 155     OGeneralPage::~OGeneralPage()
 156     {
 157         m_pDatasourceType.reset( NULL );
 158         m_pLB_DocumentList.reset( NULL );
 159     }
 160
 161     //-------------------------------------------------------------------------
 162     namespace
 163     {
 164         struct DisplayedType
 165         {
 166             ::rtl::OUString eType;
 167             String          sDisplayName;
 168
 169             DisplayedType( const ::rtl::OUString& _eType, const String& _rDisplayName ) : eType( _eType ), sDisplayName( _rDisplayName ) { }
 170         };
 171         typedef ::std::vector< DisplayedType > DisplayedTypes;
 172
 173         struct DisplayedTypeLess : ::std::binary_function< DisplayedType, DisplayedType, bool >
 174         {
 175             bool operator() ( const DisplayedType& _rLHS, const DisplayedType& _rRHS )
 176             {
 177                 return _rLHS.eType < _rRHS.eType;
 178             }
 179         };
 180     }
 181
 182     //-------------------------------------------------------------------------
 183     void OGeneralPage::initializeTypeList()
 184     {
 185         if ( m_bInitTypeList )
 186         {
 187             m_bInitTypeList = false;
 188             m_pDatasourceType->Clear();
 189
 190             if ( m_pCollection )
 191             {
 192                 DisplayedTypes aDisplayedTypes;
 193
 194                 ::dbaccess::ODsnTypeCollection::TypeIterator aEnd = m_pCollection->end();
 195                 for (   ::dbaccess::ODsnTypeCollection::TypeIterator aTypeLoop =  m_pCollection->begin();
 196                         aTypeLoop != aEnd;
 197                         ++aTypeLoop
 198                     )
 199                 {
 200                     const ::rtl::OUString sURLPrefix = aTypeLoop.getURLPrefix();
 201                     if ( sURLPrefix.getLength() )
 202                     {
 203                         String sDisplayName = aTypeLoop.getDisplayName();
 204                         if (   m_pDatasourceType->GetEntryPos( sDisplayName ) == LISTBOX_ENTRY_NOTFOUND
 205                             && approveDataSourceType( sURLPrefix, sDisplayName ) )
 206                         {
 207                             aDisplayedTypes.push_back( DisplayedTypes::value_type( sURLPrefix, sDisplayName ) );
 208                         }
 209                     }
 210                 }
 211                 ::std::sort( aDisplayedTypes.begin(), aDisplayedTypes.end(), DisplayedTypeLess() );
 212                 DisplayedTypes::const_iterator aDisplayEnd = aDisplayedTypes.end();
 213                 for (   DisplayedTypes::const_iterator loop = aDisplayedTypes.begin();
 214                         loop != aDisplayEnd;
 215                         ++loop
 216                     )
 217                     insertDatasourceTypeEntryData( loop->eType, loop->sDisplayName );
 218             } // if ( m_pCollection )
 219         }
 220     }
 221
 222
 223
 224     //-------------------------------------------------------------------------
 225     void OGeneralPage::setParentTitle(const ::rtl::OUString& _sURLPrefix)
 226     {
 227         if (!m_DBWizardMode)
 228         {
 229             const String sName = m_pCollection->getTypeDisplayName(_sURLPrefix);
 230             if ( m_pAdminDialog )
 231             {
 232                 LocalResourceAccess aStringResAccess( PAGE_GENERAL, RSC_TABPAGE );
 233                 String sMessage = String(ModuleRes(STR_PARENTTITLE));
 234                 sMessage.SearchAndReplaceAscii("#",sName);
 235                 m_pAdminDialog->setTitle(sMessage);
 236             }
 237         }
 238     }
 239
 240     //-------------------------------------------------------------------------
 241     OGeneralPage::CreationMode OGeneralPage::GetDatabaseCreationMode() const
 242     {
 243         if ( m_aRB_CreateDatabase.IsChecked() )
 244             return eCreateNew;
 245         if ( m_aRB_GetExistingDatabase.IsChecked() )
 246             return eConnectExternal;
 247         return eOpenExisting;
 248     }
 249
 250     //-------------------------------------------------------------------------
 251     void OGeneralPage::GetFocus()
 252     {
 253         OGenericAdministrationPage::GetFocus();
 254         if ( m_pLB_DocumentList.get() && m_pLB_DocumentList->IsEnabled() )
 255             m_pLB_DocumentList->GrabFocus();
 256         else if (m_pDatasourceType.get() && m_pDatasourceType->IsEnabled())
 257             m_pDatasourceType->GrabFocus();
 258     }
 259
 260     //-------------------------------------------------------------------------
 261     void OGeneralPage::switchMessage(const ::rtl::OUString& _sURLPrefix)
 262     {
 263         SPECIAL_MESSAGE eMessage = smNone;
 264         if ( !_sURLPrefix.getLength()/*_eType == m_eNotSupportedKnownType*/ )
 265         {
 266             eMessage = smUnsupportedType;
 267         }
 268
 269
 270         if ( eMessage != m_eLastMessage )
 271         {
 272             sal_uInt16 nResId = 0;
 273             if ( smUnsupportedType == eMessage )
 274                 nResId = STR_UNSUPPORTED_DATASOURCE_TYPE;
 275             String sMessage;
 276             if ( nResId )
 277             {
 278                 LocalResourceAccess aStringResAccess( PAGE_GENERAL, RSC_TABPAGE );
 279                 sMessage = String(ModuleRes(nResId));
 280             }
 281             m_aSpecialMessage.SetText(sMessage);
 282
 283             m_eLastMessage = eMessage;
 284         }
 285     }
 286
 287     //-------------------------------------------------------------------------
 288     void OGeneralPage::onTypeSelected(const ::rtl::OUString& _sURLPrefix)
 289     {
 290         // the the new URL text as indicated by the selection history
 291         implSetCurrentType( _sURLPrefix );
 292
 293         switchMessage(_sURLPrefix);
 294
 295         if ( m_aTypeSelectHandler.IsSet() )
 296             m_aTypeSelectHandler.Call(this);
 297     }
 298
 299     //-------------------------------------------------------------------------
 300     void OGeneralPage::implInitControls(const SfxItemSet& _rSet, sal_Bool _bSaveValue)
 301     {
 302         initializeTypeList();
 303
 304         // first check whether or not the selection is invalid or readonly (invalid implies readonly, but not vice versa)
 305         sal_Bool bValid, bReadonly;
 306         getFlags(_rSet, bValid, bReadonly);
 307         if (m_DBWizardMode)
 308         {
 309             m_aTypePreLabel.Hide();
 310             m_aTypePostLabel.Hide();
 311             m_aSpecialMessage.Hide();
 312             SetControlFontWeight(&m_aFTHeaderText);
 313             SetText(String());
 314
 315             LayoutHelper::positionBelow( m_aRB_GetExistingDatabase, *m_pDatasourceType, RelatedControls, INDENT_BELOW_RADIO );
 316
 317             if ( !bValid || bReadonly )
 318             {
 319                 m_aDatasourceTypeLabel.Enable( false );
 320                 m_pDatasourceType->Enable( false );
 321                 m_aFTDataSourceAppendix.Enable( false );
 322                 m_aPB_OpenDocument.Enable( false );
 323                 m_aFT_DocListLabel.Enable( false );
 324                 m_pLB_DocumentList->Enable( false );
 325             }
 326             else
 327             {
 328                 m_aControlDependencies.enableOnRadioCheck( m_aRB_GetExistingDatabase, m_aDatasourceTypeLabel, *m_pDatasourceType, m_aFTDataSourceAppendix );
 329                 m_aControlDependencies.enableOnRadioCheck( m_aRB_OpenDocument, m_aPB_OpenDocument, m_aFT_DocListLabel, *m_pLB_DocumentList );
 330             }
 331
 332             m_pLB_DocumentList->SetDropDownLineCount( 20 );
 333             if ( m_pLB_DocumentList->GetEntryCount() )
 334                 m_pLB_DocumentList->SelectEntryPos( 0 );
 335
 336             m_aDatasourceTypeLabel.Hide();
 337             m_aFTDataSourceAppendix.Hide();
 338
 339             m_eOriginalCreationMode = GetDatabaseCreationMode();
 340         }
 341         else
 342         {
 343             m_aFT_DatasourceTypeHeader.Hide();
 344             m_aRB_CreateDatabase.Hide();
 345             m_aRB_GetExistingDatabase.Hide();
 346             m_aRB_OpenDocument.Hide();
 347             m_aPB_OpenDocument.Hide();
 348             m_aFT_DocListLabel.Hide();
 349             m_pLB_DocumentList->Hide();
 350             m_aFTHeaderText.Hide();
 351             m_aFTHelpText.Hide();
 352             m_aTypePreLabel.Enable(bValid);
 353             m_aTypePostLabel.Enable(bValid);
 354             m_aDatasourceTypeLabel.Enable(bValid);
 355             m_pDatasourceType->Enable(bValid);
 356         }
 357         // if the selection is invalid, disable evrything
 358         String sName,sConnectURL;
 359         m_bDisplayingInvalid = !bValid;
 360         if ( bValid )
 361         {
 362             // collect some items and some values
 363             SFX_ITEMSET_GET(_rSet, pNameItem, SfxStringItem, DSID_NAME, sal_True);
 364             SFX_ITEMSET_GET(_rSet, pUrlItem, SfxStringItem, DSID_CONNECTURL, sal_True);
 365             DBG_ASSERT(pUrlItem, "OGeneralPage::implInitControls : missing the type attribute !");
 366             DBG_ASSERT(pNameItem, "OGeneralPage::implInitControls : missing the type attribute !");
 367             sName = pNameItem->GetValue();
 368             sConnectURL = pUrlItem->GetValue();
 369         }
 370
 371         ::rtl::OUString eOldSelection = m_eCurrentSelection;
 372         m_eNotSupportedKnownType =  ::dbaccess::DST_UNKNOWN;
 373         implSetCurrentType(  ::rtl::OUString() );
 374
 375         // compare the DSN prefix with the registered ones
 376         String sDisplayName;
 377
 378         if (m_pCollection && bValid)
 379         {
 380             implSetCurrentType( m_pCollection->getPrefix(sConnectURL) );
 381             sDisplayName = m_pCollection->getTypeDisplayName(m_eCurrentSelection);
 382         }
 383
 384         // select the correct datasource type
 385         if  (   approveDataSourceType( m_eCurrentSelection, sDisplayName )
 386             &&  ( LISTBOX_ENTRY_NOTFOUND == m_pDatasourceType->GetEntryPos( sDisplayName ) )
 387             )
 388         {       // this indicates it's really a type which is known in general, but not supported on the current platform
 389             // show a message saying so
 390             //  eSpecialMessage = smUnsupportedType;
 391             insertDatasourceTypeEntryData(m_eCurrentSelection, sDisplayName);
 392             // remember this type so we can show the special message again if the user selects this
 393             // type again (without changing the data source)
 394             m_eNotSupportedKnownType = m_pCollection->determineType(m_eCurrentSelection);
 395         }
 396
 397         if (m_aRB_CreateDatabase.IsChecked() && m_DBWizardMode)
 398             sDisplayName = m_pCollection->getTypeDisplayName( ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("jdbc:")));
 399         m_pDatasourceType->SelectEntry(sDisplayName);
 400
 401         // notify our listener that our type selection has changed (if so)
 402         if ( eOldSelection != m_eCurrentSelection )
 403         {
 404             setParentTitle(m_eCurrentSelection);
 405             onTypeSelected(m_eCurrentSelection);
 406         }
 407
 408         // a special message for the current page state
 409         switchMessage(m_eCurrentSelection);
 410
 411         OGenericAdministrationPage::implInitControls(_rSet, _bSaveValue);
 412     }
 413
 414
 415     // For the databaseWizard we only have one entry for the MySQL Database,
 416     // because we have a seperate tabpage to retrieve the respective datasource type
 417     // ( ::dbaccess::DST_MYSQL_ODBC ||  ::dbaccess::DST_MYSQL_JDBC). Therefore we use  ::dbaccess::DST_MYSQL_JDBC as a temporary
 418     // representative for all MySQl databases)
 419     // Also, embedded databases (embedded HSQL, at the moment), are not to appear in the list of
 420     // databases to connect to.
 421     bool OGeneralPage::approveDataSourceType( const ::rtl::OUString& _sURLPrefix, String& _inout_rDisplayName )
 422     {
 423         const ::dbaccess::DATASOURCE_TYPE eType = m_pCollection->determineType(_sURLPrefix);
 424
 425         if ( m_DBWizardMode )
 426         {
 427             switch ( eType )
 428             {
 429             case ::dbaccess::DST_MYSQL_JDBC:
 430                 _inout_rDisplayName = m_sMySQLEntry;
 431                 break;
 432             case ::dbaccess::DST_MYSQL_ODBC:
 433             case ::dbaccess::DST_MYSQL_NATIVE:
 434                 // don't display those, the decision whether the user connects via JDBC/ODBC/C-OOo is made on another
 435                 // page
 436                 _inout_rDisplayName = String();
 437                 break;
 438             case ::dbaccess::DST_MYSQL_NATIVE_DIRECT:
 439                 // do not display the Connector/OOo driver itself, it is always wrapped via the MySQL-Driver, if
 440                 // this driver is installed
 441                 if ( m_pCollection->hasDriver( "sdbc:mysql:mysqlc:" ) )
 442                     _inout_rDisplayName = String();
 443                 break;
 444             default:
 445                 break;
 446             }
 447         }
 448
 449         if ( eType ==  ::dbaccess::DST_EMBEDDED_HSQLDB )
 450             _inout_rDisplayName = String();
 451
 452         return _inout_rDisplayName.Len() > 0;
 453     }
 454
 455
 456     // -----------------------------------------------------------------------
 457     void OGeneralPage::insertDatasourceTypeEntryData(const ::rtl::OUString& _sType, String sDisplayName)
 458     {
 459         // insert a (temporary) entry
 460         sal_uInt16 nPos = m_pDatasourceType->InsertEntry(sDisplayName);
 461         if ( nPos >= m_aURLPrefixes.size() )
 462             m_aURLPrefixes.resize(nPos+1);
 463         m_aURLPrefixes[nPos] = _sType;
 464     }
 465
 466     // -----------------------------------------------------------------------
 467     void OGeneralPage::fillWindows(::std::vector< ISaveValueWrapper* >& _rControlList)
 468     {
 469         _rControlList.push_back(new ODisableWrapper<FixedText>(&m_aTypePreLabel));
 470         _rControlList.push_back(new ODisableWrapper<FixedText>(&m_aDatasourceTypeLabel));
 471         _rControlList.push_back(new ODisableWrapper<FixedText>(&m_aTypePostLabel));
 472         _rControlList.push_back(new ODisableWrapper<FixedText>(&m_aSpecialMessage));
 473         _rControlList.push_back(new ODisableWrapper<FixedText>(&m_aFTDataSourceAppendix));
 474     }
 475     // -----------------------------------------------------------------------
 476     void OGeneralPage::fillControls(::std::vector< ISaveValueWrapper* >& _rControlList)
 477     {
 478         _rControlList.push_back(new OSaveValueWrapper<ListBox>(m_pDatasourceType.get()));
 479     }
 480
 481     //-------------------------------------------------------------------------
 482     SfxTabPage* OGeneralPage::Create(Window* _pParent, const SfxItemSet& _rAttrSet, sal_Bool _bWizardMode)
 483     {
 484            return ( new OGeneralPage( _pParent, _rAttrSet, _bWizardMode ) );
 485     }
 486
 487     //-------------------------------------------------------------------------
 488     void OGeneralPage::implSetCurrentType( const ::rtl::OUString& _eType )
 489     {
 490         if ( _eType == m_eCurrentSelection )
 491             return;
 492
 493         m_eCurrentSelection = _eType;
 494     }
 495
 496     //-------------------------------------------------------------------------
 497     void OGeneralPage::Reset(const SfxItemSet& _rCoreAttrs)
 498     {
 499         // reset all locale data
 500         implSetCurrentType(  ::rtl::OUString() );
 501             // this ensures that our type selection link will be called, even if the new is is the same as the
 502             // current one
 503         OGenericAdministrationPage::Reset(_rCoreAttrs);
 504     }
 505
 506     //-------------------------------------------------------------------------
 507     BOOL OGeneralPage::FillItemSet(SfxItemSet& _rCoreAttrs)
 508     {
 509         sal_Bool bChangedSomething = sal_False;
 510
 511         bool bCommitTypeSelection = true;
 512         if ( m_DBWizardMode )
 513         {
 514             if ( m_aRB_CreateDatabase.IsChecked() )
 515             {
 516                 _rCoreAttrs.Put(SfxStringItem(DSID_CONNECTURL, ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("sdbc:dbase:"))));
 517                 bChangedSomething = sal_True;
 518                 bCommitTypeSelection = false;
 519             }
 520             else if ( m_aRB_OpenDocument.IsChecked() )
 521             {
 522                 if ( m_aRB_OpenDocument.GetSavedValue() != m_aRB_OpenDocument.IsChecked() )
 523                     bChangedSomething = sal_True;
 524
 525                 // TODO
 526                 bCommitTypeSelection = false;
 527             }
 528         }
 529
 530         if ( bCommitTypeSelection )
 531         {
 532             USHORT nEntry = m_pDatasourceType->GetSelectEntryPos();
 533             ::rtl::OUString sURLPrefix = m_aURLPrefixes[nEntry];
 534             if (m_DBWizardMode)
 535             {
 536                 if  (  ( m_pDatasourceType->GetSavedValue() != nEntry )
 537                     || ( GetDatabaseCreationMode() != m_eOriginalCreationMode )
 538                     )
 539                 {
 540                     _rCoreAttrs.Put(SfxStringItem(DSID_CONNECTURL,sURLPrefix ));
 541                     bChangedSomething = sal_True;
 542                 }
 543                 else
 544                     implSetCurrentType(sURLPrefix);
 545             }
 546             else
 547             {
 548                 if ( m_pDatasourceType->GetSavedValue() != nEntry)
 549                 {
 550                     _rCoreAttrs.Put(SfxStringItem(DSID_CONNECTURL, sURLPrefix));
 551                     bChangedSomething = sal_True;
 552                 }
 553             }
 554         }
 555         return bChangedSomething;
 556     }
 557
 558     //-------------------------------------------------------------------------
 559     IMPL_LINK(OGeneralPage, OnDatasourceTypeSelected, ListBox*, _pBox)
 560     {
 561         // get the type from the entry data
 562         sal_Int16 nSelected = _pBox->GetSelectEntryPos();
 563         const ::rtl::OUString sURLPrefix = m_aURLPrefixes[nSelected];
 564
 565         setParentTitle(sURLPrefix);
 566         // let the impl method do all the stuff
 567         onTypeSelected(sURLPrefix);
 568         // tell the listener we were modified
 569         callModifiedHdl();
 570         // outta here
 571         return 0L;
 572     }
 573
 574     //-------------------------------------------------------------------------
 575     OGeneralPage::DocumentDescriptor OGeneralPage::GetSelectedDocument() const
 576     {
 577         DocumentDescriptor aDocument;
 578         if ( m_aBrowsedDocument.sURL.Len() )
 579             aDocument = m_aBrowsedDocument;
 580         else
 581         {
 582             aDocument.sURL = m_pLB_DocumentList->GetSelectedDocumentURL();
 583             aDocument.sFilter = m_pLB_DocumentList->GetSelectedDocumentFilter();
 584         }
 585         return aDocument;
 586     }
 587
 588     //-------------------------------------------------------------------------
 589     IMPL_LINK(OGeneralPage, OnSetupModeSelected, RadioButton*, /*_pBox*/)
 590     {
 591         if ( m_aCreationModeHandler.IsSet() )
 592             m_aCreationModeHandler.Call(this);
 593         return 1L;
 594     }
 595
 596     //-------------------------------------------------------------------------
 597     IMPL_LINK(OGeneralPage, OnDocumentSelected, ListBox*, /*_pBox*/)
 598     {
 599         m_aDocumentSelectionHandler.Call( this );
 600         return 0L;
 601     }
 602
 603     //-------------------------------------------------------------------------
 604     IMPL_LINK(OGeneralPage, OnOpenDocument, PushButton*, /*_pBox*/)
 605     {
 606         ::sfx2::FileDialogHelper aFileDlg( WB_OPEN, ::String::CreateFromAscii("sdatabase") );
 607         const SfxFilter* pFilter = getStandardDatabaseFilter();
 608         if ( pFilter )
 609         {
 610 //                      aFileDlg.AddFilter(pFilter->GetUIName(),pFilter->GetDefaultExtension());
 611             aFileDlg.SetCurrentFilter(pFilter->GetUIName());
 612         }
 613         if ( aFileDlg.Execute() == ERRCODE_NONE )
 614         {
 615             String sPath = aFileDlg.GetPath();
 616             if ( aFileDlg.GetCurrentFilter() != pFilter->GetUIName() || !pFilter->GetWildcard().Matches(sPath) )
 617             {
 618                 String sMessage(ModuleRes(STR_ERR_USE_CONNECT_TO));
 619                 InfoBox aError(this, sMessage);
 620                 aError.Execute();
 621                 m_aRB_GetExistingDatabase.Check();
 622                 OnSetupModeSelected(&m_aRB_GetExistingDatabase);
 623                 return 0L;
 624             }
 625             m_aBrowsedDocument.sURL = sPath;
 626             m_aBrowsedDocument.sFilter = String();
 627             m_aChooseDocumentHandler.Call( this );
 628             return 1L;
 629         }
 630
 631         return 0L;
 632     }
 633
 634 //.........................................................................
 635 }       // namespace dbaui
 636 //.........................................................................
 637