AOO410/main/connectivity/source/parse/PColumn.cxx - openoffice - Git at Google

 /**************************************************************
  *
  * Licensed to the Apache Software Foundation (ASF) under one
  * or more contributor license agreements.  See the NOTICE file
  * distributed with this work for additional information
  * regarding copyright ownership.  The ASF licenses this file
  * to you under the Apache License, Version 2.0 (the
  * "License"); you may not use this file except in compliance
  * with the License.  You may obtain a copy of the License at
  *
  *   http://www.apache.org/licenses/LICENSE-2.0
  *
  * Unless required by applicable law or agreed to in writing,
  * software distributed under the License is distributed on an
  * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
  * KIND, either express or implied.  See the License for the
  * specific language governing permissions and limitations
  * under the License.
  *
  *************************************************************/


 // MARKER(update_precomp.py): autogen include statement, do not remove
 #include "precompiled_connectivity.hxx"

 #include "connectivity/PColumn.hxx"
 #include "connectivity/dbtools.hxx"
 #include "TConnection.hxx"

 #include <comphelper/types.hxx>
 #include <tools/diagnose_ex.h>

 using namespace ::comphelper;
 using namespace connectivity;
 using namespace dbtools;
 using namespace connectivity::parse;
 using namespace ::com::sun::star::uno;
 using namespace ::com::sun::star::sdbc;
 using namespace ::com::sun::star::beans;
 using namespace ::com::sun::star::container;

 // -------------------------------------------------------------------------
 OParseColumn::OParseColumn(const Reference<XPropertySet>& _xColumn,sal_Bool		_bCase)
 	: connectivity::sdbcx::OColumn(	getString(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_NAME)))
 								,	getString(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPENAME)))
 								,	getString(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_DEFAULTVALUE)))
                                 ,	getString(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_DESCRIPTION)))
 								,	getINT32(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISNULLABLE)))
 								,	getINT32(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_PRECISION)))
 								,	getINT32(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_SCALE)))
 								,	getINT32(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPE)))
 								,	getBOOL(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISAUTOINCREMENT)))
 								,	sal_False
 								,	getBOOL(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISCURRENCY)))
 								,	_bCase
 								)
 	, m_bFunction(sal_False)
 	, m_bDbasePrecisionChanged(sal_False)
 	, m_bAggregateFunction(sal_False)
     , m_bIsSearchable( sal_True )
 {
 	construct();
 }

 // -------------------------------------------------------------------------
 OParseColumn::OParseColumn(	const ::rtl::OUString& _Name,
 					const ::rtl::OUString& _TypeName,
 					const ::rtl::OUString& _DefaultValue,
                     const ::rtl::OUString& _Description,
 					sal_Int32		_IsNullable,
 					sal_Int32		_Precision,
 					sal_Int32		_Scale,
 					sal_Int32		_Type,
 					sal_Bool		_IsAutoIncrement,
 					sal_Bool		_IsCurrency,
 					sal_Bool		_bCase
 				) : connectivity::sdbcx::OColumn(_Name,
 								  _TypeName,
 								  _DefaultValue,
                                   _Description,
 								  _IsNullable,
 								  _Precision,
 								  _Scale,
 								  _Type,
 								  _IsAutoIncrement,
 								  sal_False,
 								  _IsCurrency,
 								  _bCase)
 	, m_bFunction(sal_False)
 	, m_bDbasePrecisionChanged(sal_False)
 	, m_bAggregateFunction(sal_False)
     , m_bIsSearchable( sal_True )
 {
 	construct();
 }

 // -------------------------------------------------------------------------
 ::vos::ORef< OSQLColumns > OParseColumn::createColumnsForResultSet( const Reference< XResultSetMetaData >& _rxResMetaData,
     const Reference< XDatabaseMetaData >& _rxDBMetaData,const Reference< XNameAccess>& i_xQueryColumns )
 {
     sal_Int32 nColumnCount = _rxResMetaData->getColumnCount();
     ::vos::ORef< OSQLColumns > aReturn( new OSQLColumns ); aReturn->get().reserve( nColumnCount );

 	StringMap aColumnMap;
     for ( sal_Int32 i = 1; i <= nColumnCount; ++i )
     {
         OParseColumn* pColumn = createColumnForResultSet( _rxResMetaData, _rxDBMetaData, i,aColumnMap );
         aReturn->get().push_back( pColumn );
         if ( i_xQueryColumns.is() && i_xQueryColumns->hasByName(pColumn->getRealName()) )
         {
             Reference<XPropertySet> xColumn(i_xQueryColumns->getByName(pColumn->getRealName()),UNO_QUERY_THROW);
             ::rtl::OUString sLabel;
             xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_LABEL)) >>= sLabel;
             if ( sLabel.getLength() )
                 pColumn->setLabel(sLabel);
         }
     }

     return aReturn;
 }

 // -------------------------------------------------------------------------
 OParseColumn* OParseColumn::createColumnForResultSet( const Reference< XResultSetMetaData >& _rxResMetaData,
     const Reference< XDatabaseMetaData >& _rxDBMetaData, sal_Int32 _nColumnPos,StringMap& _rColumns )
 {
     ::rtl::OUString sLabel = _rxResMetaData->getColumnLabel( _nColumnPos );
     // retrieve the name of the column
 	// check for duplicate entries
 	if(_rColumns.find(sLabel) != _rColumns.end())
 	{
 		::rtl::OUString sAlias(sLabel);
 		sal_Int32 searchIndex=1;
 		while(_rColumns.find(sAlias) != _rColumns.end())
 		{
             (sAlias = sLabel) += ::rtl::OUString::valueOf(searchIndex++);
 		}
 		sLabel = sAlias;
 	}
     _rColumns.insert(StringMap::value_type(sLabel,0));
 	OParseColumn* pColumn = new OParseColumn(
         sLabel,
 		_rxResMetaData->getColumnTypeName( _nColumnPos ),
         ::rtl::OUString(),
         ::rtl::OUString(),
         _rxResMetaData->isNullable( _nColumnPos ),
         _rxResMetaData->getPrecision( _nColumnPos ),
         _rxResMetaData->getScale( _nColumnPos ),
         _rxResMetaData->getColumnType( _nColumnPos ),
         _rxResMetaData->isAutoIncrement( _nColumnPos ),
         _rxResMetaData->isCurrency( _nColumnPos ),
         _rxDBMetaData->supportsMixedCaseQuotedIdentifiers()
     );
     const ::rtl::OUString sTableName = _rxResMetaData->getTableName( _nColumnPos );
     if ( sTableName.getLength() )
         pColumn->setTableName(  ::dbtools::composeTableName( _rxDBMetaData,
             _rxResMetaData->getCatalogName( _nColumnPos ),
             _rxResMetaData->getSchemaName( _nColumnPos ),
             sTableName,
             sal_False,
             eComplete
         ) );
     pColumn->setIsSearchable( _rxResMetaData->isSearchable( _nColumnPos ) );
     pColumn->setRealName(_rxResMetaData->getColumnName( _nColumnPos ));
     pColumn->setLabel(sLabel);
     return pColumn;
 }

 // -------------------------------------------------------------------------
 OParseColumn::~OParseColumn()
 {
 }
 // -------------------------------------------------------------------------
 void OParseColumn::construct()
 {
 	registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_FUNCTION),				PROPERTY_ID_FUNCTION,				0,  &m_bFunction,		        ::getCppuType(reinterpret_cast< sal_Bool*>(NULL)));
 	registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_AGGREGATEFUNCTION),		PROPERTY_ID_AGGREGATEFUNCTION,		0,  &m_bAggregateFunction,		::getCppuType(reinterpret_cast< sal_Bool*>(NULL)));
 	registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TABLENAME),				PROPERTY_ID_TABLENAME,				0,  &m_aTableName,		        ::getCppuType(reinterpret_cast< ::rtl::OUString*>(NULL)));
 	registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_REALNAME),				PROPERTY_ID_REALNAME,				0,  &m_aRealName,		        ::getCppuType(reinterpret_cast< ::rtl::OUString*>(NULL)));
 	registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_DBASEPRECISIONCHANGED),	PROPERTY_ID_DBASEPRECISIONCHANGED,	0,  &m_bDbasePrecisionChanged,	::getCppuType(reinterpret_cast<sal_Bool*>(NULL)));
     registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISSEARCHABLE),	        PROPERTY_ID_ISSEARCHABLE,			0,  &m_bIsSearchable,           ::getCppuType(reinterpret_cast< sal_Bool*>(NULL)));
     registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_LABEL),				    PROPERTY_ID_LABEL,				    0,  &m_sLabel,		            ::getCppuType(reinterpret_cast< ::rtl::OUString*>(NULL)));
 }
 // -----------------------------------------------------------------------------
 ::cppu::IPropertyArrayHelper* OParseColumn::createArrayHelper() const
 {
     return doCreateArrayHelper();
 }
 // -----------------------------------------------------------------------------
 ::cppu::IPropertyArrayHelper & SAL_CALL OParseColumn::getInfoHelper()
 {
     OSL_ENSURE( !isNew(), "OParseColumn::getInfoHelper: a *new* ParseColumn?" );
 	return *OParseColumn_PROP::getArrayHelper();
 }

 // -----------------------------------------------------------------------------
 namespace
 {
     ::rtl::OUString lcl_getColumnTableName( const Reference< XPropertySet >& i_parseColumn )
     {
         ::rtl::OUString sColumnTableName;
         try
         {
             OSL_VERIFY( i_parseColumn->getPropertyValue( OMetaConnection::getPropMap().getNameByIndex( PROPERTY_ID_TABLENAME ) ) >>= sColumnTableName );
         }
         catch( const Exception& )
         {
         	DBG_UNHANDLED_EXCEPTION();
         }
         return sColumnTableName;
     }
 }

 // -----------------------------------------------------------------------------
 OOrderColumn::OOrderColumn(	const Reference<XPropertySet>& _xColumn, const ::rtl::OUString& i_rOriginatingTableName,
                             sal_Bool	_bCase, sal_Bool _bAscending )
 	: connectivity::sdbcx::OColumn(
         getString(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_NAME))),
 		getString(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPENAME))),
 		getString(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_DEFAULTVALUE))),
         getString(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_DESCRIPTION))),
 		getINT32(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISNULLABLE))),
 		getINT32(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_PRECISION))),
 		getINT32(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_SCALE))),
 		getINT32(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPE))),
 		getBOOL(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISAUTOINCREMENT))),
 		sal_False,
 		getBOOL(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISCURRENCY))),
 		_bCase
     )
 	,m_bAscending(_bAscending)
     ,m_sTableName( i_rOriginatingTableName )
 {
 	construct();
 }

 // -----------------------------------------------------------------------------
 OOrderColumn::OOrderColumn(	const Reference<XPropertySet>& _xColumn, sal_Bool _bCase, sal_Bool _bAscending )
 	: connectivity::sdbcx::OColumn(
         getString(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_NAME))),
 		getString(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPENAME))),
 		getString(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_DEFAULTVALUE))),
         getString(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_DESCRIPTION))),
 		getINT32(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISNULLABLE))),
 		getINT32(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_PRECISION))),
 		getINT32(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_SCALE))),
 		getINT32(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPE))),
 		getBOOL(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISAUTOINCREMENT))),
 		sal_False,
 		getBOOL(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISCURRENCY))),
 		_bCase
     )
 	,m_bAscending(_bAscending)
     ,m_sTableName( lcl_getColumnTableName( _xColumn ) )
 {
 	construct();
 }

 // -------------------------------------------------------------------------
 OOrderColumn::~OOrderColumn()
 {
 }

 // -------------------------------------------------------------------------
 void OOrderColumn::construct()
 {
 	registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISASCENDING), PROPERTY_ID_ISASCENDING,
         PropertyAttribute::READONLY,  const_cast< sal_Bool* >( &m_bAscending ),    ::getCppuType( reinterpret_cast< sal_Bool* >( NULL ) ) );
     registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TABLENAME),   PROPERTY_ID_TABLENAME,
         PropertyAttribute::READONLY,  const_cast< ::rtl::OUString* >( &m_sTableName ),  ::getCppuType(reinterpret_cast< ::rtl::OUString*>(NULL)));
 }
 // -----------------------------------------------------------------------------
 ::cppu::IPropertyArrayHelper* OOrderColumn::createArrayHelper() const
 {
     return doCreateArrayHelper();
 }
 // -----------------------------------------------------------------------------
 ::cppu::IPropertyArrayHelper & SAL_CALL OOrderColumn::getInfoHelper()
 {
     OSL_ENSURE( !isNew(), "OOrderColumn::getInfoHelper: a *new* OrderColumn?" );
 	return *OOrderColumn_PROP::getArrayHelper();
 }
 // -----------------------------------------------------------------------------
 ::com::sun::star::uno::Sequence< ::rtl::OUString > SAL_CALL OOrderColumn::getSupportedServiceNames(  ) throw(::com::sun::star::uno::RuntimeException)
 {
 	::com::sun::star::uno::Sequence< ::rtl::OUString > aSupported(1);
 	aSupported[0] = ::rtl::OUString::createFromAscii("com.sun.star.sdb.OrderColumn");

 	return aSupported;
 }
 // -----------------------------------------------------------------------------
	/**************************************************************
	*
	* Licensed to the Apache Software Foundation (ASF) under one
	* or more contributor license agreements. See the NOTICE file
	* distributed with this work for additional information
	* regarding copyright ownership. The ASF licenses this file
	* to you under the Apache License, Version 2.0 (the
	* "License"); you may not use this file except in compliance
	* with the License. You may obtain a copy of the License at
	*
	* http://www.apache.org/licenses/LICENSE-2.0
	*
	* Unless required by applicable law or agreed to in writing,
	* software distributed under the License is distributed on an
	* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
	* KIND, either express or implied. See the License for the
	* specific language governing permissions and limitations
	* under the License.
	*
	*************************************************************/



	// MARKER(update_precomp.py): autogen include statement, do not remove
	#include "precompiled_connectivity.hxx"

	#include "connectivity/PColumn.hxx"
	#include "connectivity/dbtools.hxx"
	#include "TConnection.hxx"

	#include <comphelper/types.hxx>
	#include <tools/diagnose_ex.h>

	using namespace ::comphelper;
	using namespace connectivity;
	using namespace dbtools;
	using namespace connectivity::parse;
	using namespace ::com::sun::star::uno;
	using namespace ::com::sun::star::sdbc;
	using namespace ::com::sun::star::beans;
	using namespace ::com::sun::star::container;

	// -------------------------------------------------------------------------
	OParseColumn::OParseColumn(const Reference<XPropertySet>& _xColumn,sal_Bool _bCase)
	: connectivity::sdbcx::OColumn( getString(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_NAME)))
	, getString(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPENAME)))
	, getString(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_DEFAULTVALUE)))
	, getString(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_DESCRIPTION)))
	, getINT32(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISNULLABLE)))
	, getINT32(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_PRECISION)))
	, getINT32(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_SCALE)))
	, getINT32(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPE)))
	, getBOOL(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISAUTOINCREMENT)))
	, sal_False
	, getBOOL(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISCURRENCY)))
	, _bCase
	)
	, m_bFunction(sal_False)
	, m_bDbasePrecisionChanged(sal_False)
	, m_bAggregateFunction(sal_False)
	, m_bIsSearchable( sal_True )
	{
	construct();
	}

	// -------------------------------------------------------------------------
	OParseColumn::OParseColumn( const ::rtl::OUString& _Name,
	const ::rtl::OUString& _TypeName,
	const ::rtl::OUString& _DefaultValue,
	const ::rtl::OUString& _Description,
	sal_Int32 _IsNullable,
	sal_Int32 _Precision,
	sal_Int32 _Scale,
	sal_Int32 _Type,
	sal_Bool _IsAutoIncrement,
	sal_Bool _IsCurrency,
	sal_Bool _bCase
	) : connectivity::sdbcx::OColumn(_Name,
	_TypeName,
	_DefaultValue,
	_Description,
	_IsNullable,
	_Precision,
	_Scale,
	_Type,
	_IsAutoIncrement,
	sal_False,
	_IsCurrency,
	_bCase)
	, m_bFunction(sal_False)
	, m_bDbasePrecisionChanged(sal_False)
	, m_bAggregateFunction(sal_False)
	, m_bIsSearchable( sal_True )
	{
	construct();
	}

	// -------------------------------------------------------------------------
	::vos::ORef< OSQLColumns > OParseColumn::createColumnsForResultSet( const Reference< XResultSetMetaData >& _rxResMetaData,
	const Reference< XDatabaseMetaData >& _rxDBMetaData,const Reference< XNameAccess>& i_xQueryColumns )
	{
	sal_Int32 nColumnCount = _rxResMetaData->getColumnCount();
	::vos::ORef< OSQLColumns > aReturn( new OSQLColumns ); aReturn->get().reserve( nColumnCount );

	StringMap aColumnMap;
	for ( sal_Int32 i = 1; i <= nColumnCount; ++i )
	{
	OParseColumn* pColumn = createColumnForResultSet( _rxResMetaData, _rxDBMetaData, i,aColumnMap );
	aReturn->get().push_back( pColumn );
	if ( i_xQueryColumns.is() && i_xQueryColumns->hasByName(pColumn->getRealName()) )
	{
	Reference<XPropertySet> xColumn(i_xQueryColumns->getByName(pColumn->getRealName()),UNO_QUERY_THROW);
	::rtl::OUString sLabel;
	xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_LABEL)) >>= sLabel;
	if ( sLabel.getLength() )
	pColumn->setLabel(sLabel);
	}
	}

	return aReturn;
	}

	// -------------------------------------------------------------------------
	OParseColumn* OParseColumn::createColumnForResultSet( const Reference< XResultSetMetaData >& _rxResMetaData,
	const Reference< XDatabaseMetaData >& _rxDBMetaData, sal_Int32 _nColumnPos,StringMap& _rColumns )
	{
	::rtl::OUString sLabel = _rxResMetaData->getColumnLabel( _nColumnPos );
	// retrieve the name of the column
	// check for duplicate entries
	if(_rColumns.find(sLabel) != _rColumns.end())
	{
	::rtl::OUString sAlias(sLabel);
	sal_Int32 searchIndex=1;
	while(_rColumns.find(sAlias) != _rColumns.end())
	{
	(sAlias = sLabel) += ::rtl::OUString::valueOf(searchIndex++);
	}
	sLabel = sAlias;
	}
	_rColumns.insert(StringMap::value_type(sLabel,0));
	OParseColumn* pColumn = new OParseColumn(
	sLabel,
	_rxResMetaData->getColumnTypeName( _nColumnPos ),
	::rtl::OUString(),
	::rtl::OUString(),
	_rxResMetaData->isNullable( _nColumnPos ),
	_rxResMetaData->getPrecision( _nColumnPos ),
	_rxResMetaData->getScale( _nColumnPos ),
	_rxResMetaData->getColumnType( _nColumnPos ),
	_rxResMetaData->isAutoIncrement( _nColumnPos ),
	_rxResMetaData->isCurrency( _nColumnPos ),
	_rxDBMetaData->supportsMixedCaseQuotedIdentifiers()
	);
	const ::rtl::OUString sTableName = _rxResMetaData->getTableName( _nColumnPos );
	if ( sTableName.getLength() )
	pColumn->setTableName( ::dbtools::composeTableName( _rxDBMetaData,
	_rxResMetaData->getCatalogName( _nColumnPos ),
	_rxResMetaData->getSchemaName( _nColumnPos ),
	sTableName,
	sal_False,
	eComplete
	) );
	pColumn->setIsSearchable( _rxResMetaData->isSearchable( _nColumnPos ) );
	pColumn->setRealName(_rxResMetaData->getColumnName( _nColumnPos ));
	pColumn->setLabel(sLabel);
	return pColumn;
	}

	// -------------------------------------------------------------------------
	OParseColumn::~OParseColumn()
	{
	}
	// -------------------------------------------------------------------------
	void OParseColumn::construct()
	{
	registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_FUNCTION), PROPERTY_ID_FUNCTION, 0, &m_bFunction, ::getCppuType(reinterpret_cast< sal_Bool*>(NULL)));
	registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_AGGREGATEFUNCTION), PROPERTY_ID_AGGREGATEFUNCTION, 0, &m_bAggregateFunction, ::getCppuType(reinterpret_cast< sal_Bool*>(NULL)));
	registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TABLENAME), PROPERTY_ID_TABLENAME, 0, &m_aTableName, ::getCppuType(reinterpret_cast< ::rtl::OUString*>(NULL)));
	registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_REALNAME), PROPERTY_ID_REALNAME, 0, &m_aRealName, ::getCppuType(reinterpret_cast< ::rtl::OUString*>(NULL)));
	registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_DBASEPRECISIONCHANGED), PROPERTY_ID_DBASEPRECISIONCHANGED, 0, &m_bDbasePrecisionChanged, ::getCppuType(reinterpret_cast<sal_Bool*>(NULL)));
	registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISSEARCHABLE), PROPERTY_ID_ISSEARCHABLE, 0, &m_bIsSearchable, ::getCppuType(reinterpret_cast< sal_Bool*>(NULL)));
	registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_LABEL), PROPERTY_ID_LABEL, 0, &m_sLabel, ::getCppuType(reinterpret_cast< ::rtl::OUString*>(NULL)));
	}
	// -----------------------------------------------------------------------------
	::cppu::IPropertyArrayHelper* OParseColumn::createArrayHelper() const
	{
	return doCreateArrayHelper();
	}
	// -----------------------------------------------------------------------------
	::cppu::IPropertyArrayHelper & SAL_CALL OParseColumn::getInfoHelper()
	{
	OSL_ENSURE( !isNew(), "OParseColumn::getInfoHelper: a new ParseColumn?" );
	return *OParseColumn_PROP::getArrayHelper();
	}

	// -----------------------------------------------------------------------------
	namespace
	{
	::rtl::OUString lcl_getColumnTableName( const Reference< XPropertySet >& i_parseColumn )
	{
	::rtl::OUString sColumnTableName;
	try
	{
	OSL_VERIFY( i_parseColumn->getPropertyValue( OMetaConnection::getPropMap().getNameByIndex( PROPERTY_ID_TABLENAME ) ) >>= sColumnTableName );
	}
	catch( const Exception& )
	{
	DBG_UNHANDLED_EXCEPTION();
	}
	return sColumnTableName;
	}
	}

	// -----------------------------------------------------------------------------
	OOrderColumn::OOrderColumn( const Reference<XPropertySet>& _xColumn, const ::rtl::OUString& i_rOriginatingTableName,
	sal_Bool _bCase, sal_Bool _bAscending )
	: connectivity::sdbcx::OColumn(
	getString(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_NAME))),
	getString(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPENAME))),
	getString(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_DEFAULTVALUE))),
	getString(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_DESCRIPTION))),
	getINT32(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISNULLABLE))),
	getINT32(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_PRECISION))),
	getINT32(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_SCALE))),
	getINT32(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPE))),
	getBOOL(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISAUTOINCREMENT))),
	sal_False,
	getBOOL(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISCURRENCY))),
	_bCase
	)
	,m_bAscending(_bAscending)
	,m_sTableName( i_rOriginatingTableName )
	{
	construct();
	}

	// -----------------------------------------------------------------------------
	OOrderColumn::OOrderColumn( const Reference<XPropertySet>& _xColumn, sal_Bool _bCase, sal_Bool _bAscending )
	: connectivity::sdbcx::OColumn(
	getString(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_NAME))),
	getString(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPENAME))),
	getString(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_DEFAULTVALUE))),
	getString(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_DESCRIPTION))),
	getINT32(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISNULLABLE))),
	getINT32(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_PRECISION))),
	getINT32(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_SCALE))),
	getINT32(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPE))),
	getBOOL(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISAUTOINCREMENT))),
	sal_False,
	getBOOL(_xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISCURRENCY))),
	_bCase
	)
	,m_bAscending(_bAscending)
	,m_sTableName( lcl_getColumnTableName( _xColumn ) )
	{
	construct();
	}

	// -------------------------------------------------------------------------
	OOrderColumn::~OOrderColumn()
	{
	}

	// -------------------------------------------------------------------------
	void OOrderColumn::construct()
	{
	registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISASCENDING), PROPERTY_ID_ISASCENDING,
	PropertyAttribute::READONLY, const_cast< sal_Bool* >( &m_bAscending ), ::getCppuType( reinterpret_cast< sal_Bool* >( NULL ) ) );
	registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TABLENAME), PROPERTY_ID_TABLENAME,
	PropertyAttribute::READONLY, const_cast< ::rtl::OUString* >( &m_sTableName ), ::getCppuType(reinterpret_cast< ::rtl::OUString*>(NULL)));
	}
	// -----------------------------------------------------------------------------
	::cppu::IPropertyArrayHelper* OOrderColumn::createArrayHelper() const
	{
	return doCreateArrayHelper();
	}
	// -----------------------------------------------------------------------------
	::cppu::IPropertyArrayHelper & SAL_CALL OOrderColumn::getInfoHelper()
	{
	OSL_ENSURE( !isNew(), "OOrderColumn::getInfoHelper: a new OrderColumn?" );
	return *OOrderColumn_PROP::getArrayHelper();
	}
	// -----------------------------------------------------------------------------
	::com::sun::star::uno::Sequence< ::rtl::OUString > SAL_CALL OOrderColumn::getSupportedServiceNames( ) throw(::com::sun::star::uno::RuntimeException)
	{
	::com::sun::star::uno::Sequence< ::rtl::OUString > aSupported(1);
	aSupported[0] = ::rtl::OUString::createFromAscii("com.sun.star.sdb.OrderColumn");

	return aSupported;
	}
	// -----------------------------------------------------------------------------