xref: /aoo42x/main/connectivity/source/drivers/file/FResultSet.cxx (revision cdf0e10c)

/*************************************************************************
 *
 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
 *
 * Copyright 2000, 2010 Oracle and/or its affiliates.
 *
 * OpenOffice.org - a multi-platform office productivity suite
 *
 * This file is part of OpenOffice.org.
 *
 * OpenOffice.org is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Lesser General Public License version 3
 * only, as published by the Free Software Foundation.
 *
 * OpenOffice.org is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Lesser General Public License version 3 for more details
 * (a copy is included in the LICENSE file that accompanied this code).
 *
 * You should have received a copy of the GNU Lesser General Public License
 * version 3 along with OpenOffice.org.  If not, see
 * <http://www.openoffice.org/license.html>
 * for a copy of the LGPLv3 License.
 *
 ************************************************************************/

// MARKER(update_precomp.py): autogen include statement, do not remove
#include "precompiled_connectivity.hxx"
#include <limits>  // included here to prevent problems if compiling with C52

#ifdef GCC
#include <iostream>
#endif
#include "connectivity/sdbcx/VColumn.hxx"
#include "file/FResultSet.hxx"
#include "file/FResultSetMetaData.hxx"
#include <com/sun/star/sdbc/DataType.hpp>
#include <com/sun/star/sdbc/ColumnValue.hpp>
#include <comphelper/property.hxx>
#include <com/sun/star/lang/DisposedException.hpp>
#include <com/sun/star/beans/PropertyAttribute.hpp>
#include <com/sun/star/container/XIndexAccess.hpp>
#include <comphelper/sequence.hxx>
#include <cppuhelper/typeprovider.hxx>
#include "connectivity/dbconversion.hxx"
#include "connectivity/dbtools.hxx"
#include <cppuhelper/propshlp.hxx>
#include <iterator>
#include <tools/debug.hxx>
#include <com/sun/star/sdbc/ResultSetType.hpp>
#include <com/sun/star/sdbc/FetchDirection.hpp>
#include <com/sun/star/sdbc/ResultSetConcurrency.hpp>
#include <com/sun/star/sdbcx/XIndexesSupplier.hpp>

#include <algorithm>
#include <comphelper/extract.hxx>
#include "connectivity/dbexception.hxx"
#include <comphelper/types.hxx>
#include "resource/file_res.hrc"
#include "resource/sharedresources.hxx"
#include <rtl/logfile.hxx>


using namespace ::comphelper;
using namespace connectivity;
using namespace connectivity::file;
using namespace ::cppu;
using namespace dbtools;
using namespace com::sun::star::uno;
using namespace com::sun::star::lang;
using namespace com::sun::star::beans;
using namespace com::sun::star::sdbc;
using namespace com::sun::star::sdbcx;
using namespace com::sun::star::container;

// Maximale Anzahl von Rows, die mit ORDER BY sortiert durchlaufen werden koennen:
#define MAX_KEYSET_SIZE 0x40000 // 256K

namespace
{
    void lcl_throwError(sal_uInt16 _nErrorId,const ::com::sun::star::uno::Reference< ::com::sun::star::uno::XInterface>& _xContext)
    {
        ::connectivity::SharedResources aResources;
        const ::rtl::OUString sMessage = aResources.getResourceString(_nErrorId);
		::dbtools::throwGenericSQLException(sMessage ,_xContext);
    }
}
//------------------------------------------------------------------------------
IMPLEMENT_SERVICE_INFO(OResultSet,"com.sun.star.sdbcx.drivers.file.ResultSet","com.sun.star.sdbc.ResultSet");
DBG_NAME( file_OResultSet )
// -------------------------------------------------------------------------
OResultSet::OResultSet(OStatement_Base* pStmt,OSQLParseTreeIterator&	_aSQLIterator) :	OResultSet_BASE(m_aMutex)
						,::comphelper::OPropertyContainer(OResultSet_BASE::rBHelper)
                        ,m_aAssignValues(NULL)
                        ,m_pEvaluationKeySet(NULL)
                        ,m_aSkipDeletedSet(this)
                        ,m_pFileSet(NULL)
                        ,m_pSortIndex(NULL)
                        ,m_pTable(NULL)
                        ,m_pParseTree(pStmt->getParseTree())
                        ,m_pSQLAnalyzer(NULL)
                        ,m_aSQLIterator(_aSQLIterator)
                        ,m_nFetchSize(0)
                        ,m_nResultSetType(ResultSetType::SCROLL_INSENSITIVE)
                        ,m_nFetchDirection(FetchDirection::FORWARD)
                        ,m_nResultSetConcurrency(ResultSetConcurrency::UPDATABLE)
						,m_xStatement(*pStmt)
                        ,m_xMetaData(NULL)
                        ,m_xDBMetaData(pStmt->getOwnConnection()->getMetaData())
                        ,m_nTextEncoding(pStmt->getOwnConnection()->getTextEncoding())
						,m_nRowPos(-1)
                        ,m_nFilePos(0)
                        ,m_nLastVisitedPos(-1)
                        ,m_nRowCountResult(-1)
                        ,m_nCurrentPosition(0)
                        ,m_nColumnCount(0)
                        ,m_bWasNull(sal_False)
                        ,m_bEOF(sal_False)
						,m_bLastRecord(sal_False)
                        ,m_bInserted(sal_False)
                        ,m_bRowUpdated(sal_False)
                        ,m_bRowInserted(sal_False)
                        ,m_bRowDeleted(sal_False)
                        ,m_bShowDeleted(pStmt->getOwnConnection()->showDeleted())
                        ,m_bIsCount(sal_False)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::OResultSet" );
	DBG_CTOR( file_OResultSet, NULL );
	osl_incrementInterlockedCount( &m_refCount );
    m_bIsCount = (m_pParseTree &&
			m_pParseTree->count() > 2														&&
			SQL_ISRULE(m_pParseTree->getChild(2),scalar_exp_commalist)						&&
			SQL_ISRULE(m_pParseTree->getChild(2)->getChild(0),derived_column)				&&
			SQL_ISRULE(m_pParseTree->getChild(2)->getChild(0)->getChild(0),general_set_fct)	&&
			m_pParseTree->getChild(2)->getChild(0)->getChild(0)->count() == 4
			);

	m_nResultSetConcurrency = isCount() ? ResultSetConcurrency::READ_ONLY : ResultSetConcurrency::UPDATABLE;
	construct();
    m_aSkipDeletedSet.SetDeletedVisible(m_bShowDeleted);
	osl_decrementInterlockedCount( &m_refCount );
}

// -------------------------------------------------------------------------
OResultSet::~OResultSet()
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::~OResultSet" );
	osl_incrementInterlockedCount( &m_refCount );
	disposing();
	DBG_DTOR( file_OResultSet, NULL );
}
// -------------------------------------------------------------------------
void OResultSet::construct()
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::construct" );
	registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_FETCHSIZE),			PROPERTY_ID_FETCHSIZE,			0,&m_nFetchSize,		::getCppuType(reinterpret_cast<sal_Int32*>(NULL)));
    registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_RESULTSETTYPE),        PROPERTY_ID_RESULTSETTYPE,      PropertyAttribute::READONLY,&m_nResultSetType,       ::getCppuType(reinterpret_cast<sal_Int32*>(NULL)));
	registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_FETCHDIRECTION),		PROPERTY_ID_FETCHDIRECTION,		0,&m_nFetchDirection,	::getCppuType(reinterpret_cast<sal_Int32*>(NULL)));
    registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_RESULTSETCONCURRENCY), PROPERTY_ID_RESULTSETCONCURRENCY,PropertyAttribute::READONLY,&m_nResultSetConcurrency,                ::getCppuType(reinterpret_cast<sal_Int32*>(NULL)));
}
// -------------------------------------------------------------------------
void OResultSet::disposing(void)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::disposing" );
	OPropertySetHelper::disposing();

	::osl::MutexGuard aGuard(m_aMutex);
    m_xStatement.clear();
    m_xMetaData.clear();
	m_pParseTree	= NULL;
    m_xColNames.clear();
    m_xColumns = NULL;
    m_xParamColumns = NULL;
    m_xColsIdx.clear();

    Reference<XComponent> xComp = m_pTable;
	if ( xComp.is() )
		xComp->removeEventListener(this);
	if(m_pTable)
	{
		m_pTable->release();
		m_pTable = NULL;
	}
	clear();
}
// -----------------------------------------------------------------------------
void OResultSet::clear()
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::clear" );
	m_pFileSet = NULL;
	DELETEZ(m_pSortIndex);

	if(m_aInsertRow.isValid())
		m_aInsertRow->get().clear();

	m_aSkipDeletedSet.clear();
}
// -------------------------------------------------------------------------
Any SAL_CALL OResultSet::queryInterface( const Type & rType ) throw(RuntimeException)
{
    //RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::queryInterface" );
	Any aRet = OPropertySetHelper::queryInterface(rType);
	return aRet.hasValue() ? aRet : OResultSet_BASE::queryInterface(rType);
}
// -------------------------------------------------------------------------
Sequence< Type > SAL_CALL OResultSet::getTypes(  ) throw(RuntimeException)
{
    //RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getTypes" );
	::osl::MutexGuard aGuard( m_aMutex );

	OTypeCollection aTypes(	::getCppuType( (const Reference< ::com::sun::star::beans::XMultiPropertySet > *)0 ),
							::getCppuType( (const Reference< ::com::sun::star::beans::XPropertySet > *)0 ),
							::getCppuType( (const Reference< ::com::sun::star::beans::XPropertySet > *)0 ));

	return ::comphelper::concatSequences(aTypes.getTypes(),OResultSet_BASE::getTypes());
}
// -------------------------------------------------------------------------

sal_Int32 SAL_CALL OResultSet::findColumn( const ::rtl::OUString& columnName ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::findColumn" );
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);


	Reference< XResultSetMetaData > xMeta = getMetaData();
	sal_Int32 nLen = xMeta->getColumnCount();
	sal_Int32 i = 1;
	for(;i<=nLen;++i)
		if(xMeta->isCaseSensitive(i) ? columnName == xMeta->getColumnName(i) :
				columnName.equalsIgnoreAsciiCase(xMeta->getColumnName(i)))
			break;
	return i;
}
// -----------------------------------------------------------------------------
const ORowSetValue& OResultSet::getValue(sal_Int32 columnIndex ) throw(::com::sun::star::sdbc::SQLException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getValue" );
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);

	//columnIndex = mapColumn(columnIndex);
	checkIndex(columnIndex );


	m_bWasNull = (m_aSelectRow->get())[columnIndex]->getValue().isNull();
	return *(m_aSelectRow->get())[columnIndex];
}
// -----------------------------------------------------------------------------
void OResultSet::checkIndex(sal_Int32 columnIndex ) throw(::com::sun::star::sdbc::SQLException)
{
    //RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::checkIndex" );
	if (   columnIndex <= 0
		//	|| columnIndex > (sal_Int32)m_xColumns->size()
           || columnIndex >= m_nColumnCount )
        ::dbtools::throwInvalidIndexException(*this);
}
// -------------------------------------------------------------------------
Reference< ::com::sun::star::io::XInputStream > SAL_CALL OResultSet::getBinaryStream( sal_Int32 /*columnIndex*/ ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getBinaryStream" );
	return NULL;
}
// -------------------------------------------------------------------------
Reference< ::com::sun::star::io::XInputStream > SAL_CALL OResultSet::getCharacterStream( sal_Int32 /*columnIndex*/ ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getCharacterStream" );
	return NULL;
}

// -------------------------------------------------------------------------
sal_Bool SAL_CALL OResultSet::getBoolean( sal_Int32 columnIndex ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getBoolean" );
	return getValue(columnIndex);
}
// -------------------------------------------------------------------------

sal_Int8 SAL_CALL OResultSet::getByte( sal_Int32 columnIndex ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getByte" );
	return getValue(columnIndex);
}
// -------------------------------------------------------------------------

Sequence< sal_Int8 > SAL_CALL OResultSet::getBytes( sal_Int32 columnIndex ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getBytes" );
	return getValue(columnIndex);
}
// -------------------------------------------------------------------------

::com::sun::star::util::Date SAL_CALL OResultSet::getDate( sal_Int32 columnIndex ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getDate" );
	return getValue(columnIndex);
}
// -------------------------------------------------------------------------

double SAL_CALL OResultSet::getDouble( sal_Int32 columnIndex ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getDouble" );
	return getValue(columnIndex);
}
// -------------------------------------------------------------------------

float SAL_CALL OResultSet::getFloat( sal_Int32 columnIndex ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getFloat" );
	return getValue(columnIndex);
}
// -------------------------------------------------------------------------

sal_Int32 SAL_CALL OResultSet::getInt( sal_Int32 columnIndex ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getInt" );
	return getValue(columnIndex);
}
// -------------------------------------------------------------------------

sal_Int32 SAL_CALL OResultSet::getRow(  ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getRow" );
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);

	OSL_ENSURE((m_bShowDeleted || !m_aRow->isDeleted()),"getRow called for deleted row");

	return m_aSkipDeletedSet.getMappedPosition((m_aRow->get())[0]->getValue());
}
// -------------------------------------------------------------------------

sal_Int64 SAL_CALL OResultSet::getLong( sal_Int32 columnIndex ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getLong" );
	return getValue(columnIndex);
}
// -------------------------------------------------------------------------

Reference< XResultSetMetaData > SAL_CALL OResultSet::getMetaData(  ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getMetaData" );
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);


	if(!m_xMetaData.is())
		m_xMetaData = new OResultSetMetaData(m_xColumns,m_aSQLIterator.getTables().begin()->first,m_pTable);
	return m_xMetaData;
}
// -------------------------------------------------------------------------
Reference< XArray > SAL_CALL OResultSet::getArray( sal_Int32 /*columnIndex*/ ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getArray" );
	return NULL;
}

// -------------------------------------------------------------------------

Reference< XClob > SAL_CALL OResultSet::getClob( sal_Int32 /*columnIndex*/ ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getClob" );
	return NULL;
}
// -------------------------------------------------------------------------
Reference< XBlob > SAL_CALL OResultSet::getBlob( sal_Int32 /*columnIndex*/ ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getBlob" );
	return NULL;
}
// -------------------------------------------------------------------------

Reference< XRef > SAL_CALL OResultSet::getRef( sal_Int32 /*columnIndex*/ ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getRef" );
	return NULL;
}
// -------------------------------------------------------------------------

Any SAL_CALL OResultSet::getObject( sal_Int32 columnIndex, const Reference< ::com::sun::star::container::XNameAccess >& /*typeMap*/ ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getObject" );
	return getValue(columnIndex).makeAny();
}
// -------------------------------------------------------------------------

sal_Int16 SAL_CALL OResultSet::getShort( sal_Int32 columnIndex ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getShort" );
	return getValue(columnIndex);
}
// -------------------------------------------------------------------------
::rtl::OUString SAL_CALL OResultSet::getString( sal_Int32 columnIndex ) throw(SQLException, RuntimeException)
{
    //RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getString" );
	return getValue(columnIndex);
}
// -------------------------------------------------------------------------
::com::sun::star::util::Time SAL_CALL OResultSet::getTime( sal_Int32 columnIndex ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getTime" );
	return getValue(columnIndex);
}
// -------------------------------------------------------------------------
::com::sun::star::util::DateTime SAL_CALL OResultSet::getTimestamp( sal_Int32 columnIndex ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getTimestamp" );
	return getValue(columnIndex);
}
// -------------------------------------------------------------------------

sal_Bool SAL_CALL OResultSet::isAfterLast(  ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::isAfterLast" );
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);


	return m_nRowPos == sal_Int32(m_pFileSet->get().size());
}
// -------------------------------------------------------------------------
sal_Bool SAL_CALL OResultSet::isFirst(  ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::isFirst" );
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);


	return m_nRowPos == 0;
}
// -------------------------------------------------------------------------
sal_Bool SAL_CALL OResultSet::isLast(  ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::isLast" );
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);


	return m_nRowPos == sal_Int32(m_pFileSet->get().size() - 1);
}
// -------------------------------------------------------------------------
void SAL_CALL OResultSet::beforeFirst(  ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::beforeFirst" );
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);


	if(first())
		previous();
}
// -------------------------------------------------------------------------
void SAL_CALL OResultSet::afterLast(  ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::afterLast" );
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);


	if(last())
		next();
	m_bEOF = sal_True;
}
// -------------------------------------------------------------------------

void SAL_CALL OResultSet::close(  ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::close" );
	dispose();
}
// -------------------------------------------------------------------------

sal_Bool SAL_CALL OResultSet::first(  ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::first" );
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);
	return m_pTable ? m_aSkipDeletedSet.skipDeleted(IResultSetHelper::FIRST,1,sal_True) : sal_False;
}
// -------------------------------------------------------------------------

sal_Bool SAL_CALL OResultSet::last(  ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::last" );
	// here I know definitely that I stand on the last record
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);
	return m_pTable ? m_aSkipDeletedSet.skipDeleted(IResultSetHelper::LAST,1,sal_True) : sal_False;
}
// -------------------------------------------------------------------------
sal_Bool SAL_CALL OResultSet::absolute( sal_Int32 row ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::absolute" );
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);
	return m_pTable ? m_aSkipDeletedSet.skipDeleted(IResultSetHelper::ABSOLUTE,row,sal_True) : sal_False;
}
// -------------------------------------------------------------------------
sal_Bool SAL_CALL OResultSet::relative( sal_Int32 row ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::relative" );
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);
	return m_pTable ? m_aSkipDeletedSet.skipDeleted(IResultSetHelper::RELATIVE,row,sal_True) : sal_False;
}
// -------------------------------------------------------------------------
sal_Bool SAL_CALL OResultSet::previous(  ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::previous" );
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);
	return m_pTable ? m_aSkipDeletedSet.skipDeleted(IResultSetHelper::PRIOR,0,sal_True) : sal_False;
}
// -------------------------------------------------------------------------
Reference< XInterface > SAL_CALL OResultSet::getStatement(  ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getStatement" );
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);


	return m_xStatement;
}
// -------------------------------------------------------------------------

sal_Bool SAL_CALL OResultSet::rowDeleted(  ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::rowDeleted" );
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);


	return m_bRowDeleted;
}
// -------------------------------------------------------------------------
sal_Bool SAL_CALL OResultSet::rowInserted(  ) throw(SQLException, RuntimeException)
{	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);


	return m_bRowInserted;
}
// -------------------------------------------------------------------------
sal_Bool SAL_CALL OResultSet::rowUpdated(  ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::rowInserted" );
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);


	return m_bRowUpdated;
}
// -------------------------------------------------------------------------

sal_Bool SAL_CALL OResultSet::isBeforeFirst(  ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::isBeforeFirst" );
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);


	return m_nRowPos == -1;
}
// -------------------------------------------------------------------------
sal_Bool OResultSet::evaluate()
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::evaluate" );
	OSL_ENSURE(m_pSQLAnalyzer,"OResultSet::evaluate: Analyzer isn't set!");
	sal_Bool bRet = sal_True;
	while(!m_pSQLAnalyzer->evaluateRestriction())
	{
		if(m_pEvaluationKeySet)
		{
			if(m_aEvaluateIter == m_pEvaluationKeySet->end())
				return sal_False;
			bRet = m_pTable->seekRow(IResultSetHelper::BOOKMARK,(*m_aEvaluateIter),m_nRowPos);
			++m_aEvaluateIter;
		}
		else
			bRet = m_pTable->seekRow(IResultSetHelper::NEXT,1,m_nRowPos);
		if(bRet)
		{
			if(m_pEvaluationKeySet)
			{
				bRet = m_pTable->fetchRow(m_aEvaluateRow,m_pTable->getTableColumns().getBody(),sal_True,sal_True);
				evaluate();

			}
			else
				bRet = m_pTable->fetchRow(m_aRow,m_xColumns.getBody(),sal_False,sal_True);
		}
	}

	return bRet;
}
// -------------------------------------------------------------------------

sal_Bool SAL_CALL OResultSet::next(  ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::next" );
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);

	return m_pTable ? m_aSkipDeletedSet.skipDeleted(IResultSetHelper::NEXT,1,sal_True) : sal_False;
}
// -------------------------------------------------------------------------

sal_Bool SAL_CALL OResultSet::wasNull(  ) throw(SQLException, RuntimeException)
{
    //RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::wasNull" );
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);

	return m_bWasNull;
}
// -------------------------------------------------------------------------

void SAL_CALL OResultSet::cancel(  ) throw(RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::cancel" );
}
// -------------------------------------------------------------------------
void SAL_CALL OResultSet::clearWarnings(  ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::clearWarnings" );
}
// -------------------------------------------------------------------------
Any SAL_CALL OResultSet::getWarnings(  ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getWarnings" );
	return Any();
}
// -------------------------------------------------------------------------
void SAL_CALL OResultSet::insertRow(  ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::insertRow" );
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);


	if(!m_bInserted || !m_pTable)
		throwFunctionSequenceException(*this);

	// we know that we append new rows at the end
	// so we have to know where the end is
	m_aSkipDeletedSet.skipDeleted(IResultSetHelper::LAST,1,sal_False);
	m_bRowInserted = m_pTable->InsertRow(m_aInsertRow.getBody(), sal_True,m_xColsIdx);
	if(m_bRowInserted && m_pFileSet.isValid())
	{
		sal_Int32 nPos = (m_aInsertRow->get())[0]->getValue();
		m_pFileSet->get().push_back(nPos);
		*(m_aInsertRow->get())[0] = sal_Int32(m_pFileSet->get().size());
		clearInsertRow();

		m_aSkipDeletedSet.insertNewPosition((m_aRow->get())[0]->getValue());
	}
}
// -------------------------------------------------------------------------
void SAL_CALL OResultSet::updateRow(  ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::updateRow" );
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);

	if(!m_pTable || m_pTable->isReadOnly())
        lcl_throwError(STR_TABLE_READONLY,*this);

	m_bRowUpdated = m_pTable->UpdateRow(m_aInsertRow.getBody(), m_aRow,m_xColsIdx);
	*(m_aInsertRow->get())[0] = (sal_Int32)(m_aRow->get())[0]->getValue();

	clearInsertRow();
}
// -------------------------------------------------------------------------
void SAL_CALL OResultSet::deleteRow() throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::deleteRow" );
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);


	if(!m_pTable || m_pTable->isReadOnly())
        lcl_throwError(STR_TABLE_READONLY,*this);
	if (m_bShowDeleted)
        lcl_throwError(STR_DELETE_ROW,*this);
	if(m_aRow->isDeleted())
        lcl_throwError(STR_ROW_ALREADY_DELETED,*this);

	sal_Int32 nPos = (sal_Int32)(m_aRow->get())[0]->getValue();
	m_bRowDeleted = m_pTable->DeleteRow(m_xColumns.getBody());
	if(m_bRowDeleted && m_pFileSet.isValid())
	{
		m_aRow->setDeleted(sal_True);
		// don't touch the m_pFileSet member here
		m_aSkipDeletedSet.deletePosition(nPos);
	}
}
// -------------------------------------------------------------------------
void SAL_CALL OResultSet::cancelRowUpdates(  ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::cancelRowUpdates" );
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);


	m_bInserted		= sal_False;
	m_bRowUpdated	= sal_False;
	m_bRowInserted	= sal_False;
	m_bRowDeleted	= sal_False;

	if(m_aInsertRow.isValid())
	{
		OValueRefVector::Vector::iterator aIter = m_aInsertRow->get().begin()+1;
		for(;aIter != m_aInsertRow->get().end();++aIter)
		{
			(*aIter)->setBound(sal_False);
			(*aIter)->setNull();
		}
	}
}
// -------------------------------------------------------------------------

void SAL_CALL OResultSet::moveToInsertRow(  ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::moveToInsertRow" );
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);

	if(!m_pTable || m_pTable->isReadOnly())
        lcl_throwError(STR_TABLE_READONLY,*this);

	m_bInserted		= sal_True;

	OValueRefVector::Vector::iterator aIter = m_aInsertRow->get().begin()+1;
	for(;aIter != m_aInsertRow->get().end();++aIter)
	{
		(*aIter)->setBound(sal_False);
		(*aIter)->setNull();
	}
}
// -------------------------------------------------------------------------

void SAL_CALL OResultSet::moveToCurrentRow(  ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::moveToCurrentRow" );
}
// -------------------------------------------------------------------------
void OResultSet::updateValue(sal_Int32 columnIndex ,const ORowSetValue& x) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::updateValue" );
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);

	checkIndex(columnIndex );
    columnIndex = mapColumn(columnIndex);

	(m_aInsertRow->get())[columnIndex]->setBound(sal_True);
	*(m_aInsertRow->get())[columnIndex] = x;
}
// -----------------------------------------------------------------------------

void SAL_CALL OResultSet::updateNull( sal_Int32 columnIndex ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::updateNull" );
    ORowSetValue aEmpty;
    updateValue(columnIndex,aEmpty);
}
// -------------------------------------------------------------------------

void SAL_CALL OResultSet::updateBoolean( sal_Int32 columnIndex, sal_Bool x ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::updateBoolean" );
	updateValue(columnIndex,x);
}
// -------------------------------------------------------------------------
void SAL_CALL OResultSet::updateByte( sal_Int32 columnIndex, sal_Int8 x ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::updateByte" );
	updateValue(columnIndex,x);
}
// -------------------------------------------------------------------------

void SAL_CALL OResultSet::updateShort( sal_Int32 columnIndex, sal_Int16 x ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::updateShort" );
	updateValue(columnIndex,x);
}
// -------------------------------------------------------------------------
void SAL_CALL OResultSet::updateInt( sal_Int32 columnIndex, sal_Int32 x ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::updateInt" );
	updateValue(columnIndex,x);
}
// -------------------------------------------------------------------------
void SAL_CALL OResultSet::updateLong( sal_Int32 /*columnIndex*/, sal_Int64 /*x*/ ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::updateLong" );
    ::dbtools::throwFeatureNotImplementedException( "XRowUpdate::updateLong", *this );
}
// -----------------------------------------------------------------------
void SAL_CALL OResultSet::updateFloat( sal_Int32 columnIndex, float x ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::updateFloat" );
	updateValue(columnIndex,x);
}
// -------------------------------------------------------------------------

void SAL_CALL OResultSet::updateDouble( sal_Int32 columnIndex, double x ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::updateDouble" );
	updateValue(columnIndex,x);
}
// -------------------------------------------------------------------------
void SAL_CALL OResultSet::updateString( sal_Int32 columnIndex, const ::rtl::OUString& x ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::updateString" );
	updateValue(columnIndex,x);
}
// -------------------------------------------------------------------------
void SAL_CALL OResultSet::updateBytes( sal_Int32 columnIndex, const Sequence< sal_Int8 >& x ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::updateBytes" );
	updateValue(columnIndex,x);
}
// -------------------------------------------------------------------------
void SAL_CALL OResultSet::updateDate( sal_Int32 columnIndex, const ::com::sun::star::util::Date& x ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::updateDate" );
	updateValue(columnIndex,x);
}
// -------------------------------------------------------------------------

void SAL_CALL OResultSet::updateTime( sal_Int32 columnIndex, const ::com::sun::star::util::Time& x ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::updateTime" );
	updateValue(columnIndex,x);
}
// -------------------------------------------------------------------------

void SAL_CALL OResultSet::updateTimestamp( sal_Int32 columnIndex, const ::com::sun::star::util::DateTime& x ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::updateTimestamp" );
	updateValue(columnIndex,x);
}
// -------------------------------------------------------------------------

void SAL_CALL OResultSet::updateBinaryStream( sal_Int32 columnIndex, const Reference< ::com::sun::star::io::XInputStream >& x, sal_Int32 length ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::updateBinaryStream" );
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);

	if(!x.is())
		::dbtools::throwFunctionSequenceException(*this);

	Sequence<sal_Int8> aSeq;
	x->readBytes(aSeq,length);
	updateValue(columnIndex,aSeq);
}
// -------------------------------------------------------------------------
void SAL_CALL OResultSet::updateCharacterStream( sal_Int32 columnIndex, const Reference< ::com::sun::star::io::XInputStream >& x, sal_Int32 length ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::updateCharacterStream" );
	updateBinaryStream(columnIndex,x,length);
}
// -------------------------------------------------------------------------
void SAL_CALL OResultSet::refreshRow(  ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::refreshRow" );
	::osl::MutexGuard aGuard( m_aMutex );
	checkDisposed(OResultSet_BASE::rBHelper.bDisposed);
}
// -------------------------------------------------------------------------
void SAL_CALL OResultSet::updateObject( sal_Int32 columnIndex, const Any& x ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::updateObject" );
	if (!::dbtools::implUpdateObject(this, columnIndex, x))
		throw SQLException();
}
// -------------------------------------------------------------------------

void SAL_CALL OResultSet::updateNumericObject( sal_Int32 columnIndex, const Any& x, sal_Int32 /*scale*/ ) throw(SQLException, RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::updateNumericObject" );
	if (!::dbtools::implUpdateObject(this, columnIndex, x))
		throw SQLException();
}
// -------------------------------------------------------------------------
IPropertyArrayHelper* OResultSet::createArrayHelper( ) const
{
    //RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::createArrayHelper" );
	Sequence< Property > aProps;
	describeProperties(aProps);
	return new ::cppu::OPropertyArrayHelper(aProps);
}
// -------------------------------------------------------------------------
IPropertyArrayHelper & OResultSet::getInfoHelper()
{
    //RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getInfoHelper" );
	return *const_cast<OResultSet*>(this)->getArrayHelper();
}

//------------------------------------------------------------------
sal_Bool OResultSet::ExecuteRow(IResultSetHelper::Movement eFirstCursorPosition,
							   sal_Int32 nFirstOffset,
							   sal_Bool bEvaluate,
							   sal_Bool bRetrieveData)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::ExecuteRow" );
	OSL_ENSURE(m_pSQLAnalyzer,"OResultSet::ExecuteRow: Analyzer isn't set!");

	// Fuer weitere Fetch-Operationen werden diese Angaben ggf. veraendert ...
	IResultSetHelper::Movement eCursorPosition = eFirstCursorPosition;
	sal_Int32  nOffset = nFirstOffset;

    const OSQLColumns & rTableCols = m_pTable->getTableColumns().getBody();
    sal_Bool bHasRestriction = m_pSQLAnalyzer->hasRestriction();
again:

	// protect from reading over the end when someboby is inserting while we are reading
	// this method works only for dBase at the moment !!!!
	if (eCursorPosition == IResultSetHelper::NEXT && m_nFilePos == m_nLastVisitedPos)
	{
		return sal_False;
	}

	if (!m_pTable || !m_pTable->seekRow(eCursorPosition, nOffset, m_nFilePos))
	{
		return sal_False;
	}

	if (!bEvaluate)	// Laeuft keine Auswertung, dann nur Ergebniszeile fuellen
	{
		m_pTable->fetchRow(m_aRow,rTableCols, sal_True,bRetrieveData);
	}
	else
	{
		m_pTable->fetchRow(m_aEvaluateRow, rTableCols, sal_True,bRetrieveData || bHasRestriction);

		if  (   (   !m_bShowDeleted
                &&  m_aEvaluateRow->isDeleted()
                )
            ||  (   bHasRestriction
                &&  !m_pSQLAnalyzer->evaluateRestriction()
                )
            )
		{												 // naechsten Satz auswerten
			// aktuelle Zeile loeschen im Keyset
			if (m_pEvaluationKeySet)
			{
				++m_aEvaluateIter;
				if (m_pEvaluationKeySet->end() != m_aEvaluateIter)
					nOffset = (*m_aEvaluateIter);
				else
				{
					return sal_False;
				}
			}
			else if (m_pFileSet.isValid())
			{
				OSL_ENSURE(//!m_pFileSet->IsFrozen() &&
							eCursorPosition == IResultSetHelper::NEXT, "Falsche CursorPosition!");
				eCursorPosition = IResultSetHelper::NEXT;
				nOffset = 1;
			}
			else if (eCursorPosition == IResultSetHelper::FIRST ||
					 eCursorPosition == IResultSetHelper::NEXT ||
					 eCursorPosition == IResultSetHelper::ABSOLUTE)
			{
				eCursorPosition = IResultSetHelper::NEXT;
				nOffset = 1;
			}
			else if (eCursorPosition == IResultSetHelper::LAST ||
					 eCursorPosition == IResultSetHelper::PRIOR)
			{
				eCursorPosition = IResultSetHelper::PRIOR;
				nOffset = 1;
			}
			else if (eCursorPosition == IResultSetHelper::RELATIVE)
			{
				eCursorPosition = (nOffset >= 0) ? IResultSetHelper::NEXT : IResultSetHelper::PRIOR;
			}
			else
			{
				//	aStatus.Set(SQL_STAT_NO_DATA_FOUND);
				return sal_False;
			}
			// Nochmal probieren ...
			goto again;
		}
	}

	// Evaluate darf nur gesetzt sein,
	// wenn der Keyset weiter aufgebaut	werden soll
	if  (   ( m_aSQLIterator.getStatementType() == SQL_STATEMENT_SELECT )
        &&  !isCount()
        &&  bEvaluate
        )
	{
		if (m_pSortIndex)
		{
			OKeyValue* pKeyValue = GetOrderbyKeyValue( m_aSelectRow );
			m_pSortIndex->AddKeyValue(pKeyValue);
		}
		else if (m_pFileSet.isValid())
		{
			//	OSL_ENSURE(!m_pFileSet->IsFrozen() , "Falsche CursorPosition!");
			sal_uInt32 nBookmarkValue = Abs((sal_Int32)(m_aEvaluateRow->get())[0]->getValue());
			m_pFileSet->get().push_back(nBookmarkValue);
		}
	}
	else if (m_aSQLIterator.getStatementType() == SQL_STATEMENT_UPDATE)
	{
		sal_Bool bOK = sal_True;
		if (bEvaluate)
		{
			// jetzt die eigentliche Ergebniszeile Lesen
			bOK = m_pTable->fetchRow(m_aEvaluateRow, m_pTable->getTableColumns().getBody(), sal_True,sal_True);
		}

		if (bOK)
		{
			// Nur die zu aendernden Werte uebergeben:
			if(!m_pTable->UpdateRow(m_aAssignValues.getBody(),m_aEvaluateRow,m_xColsIdx))
				return sal_False;
		}
	}
	else if (m_aSQLIterator.getStatementType() == SQL_STATEMENT_DELETE)
	{
		sal_Bool bOK = sal_True;
		if (bEvaluate)
		{
			bOK = m_pTable->fetchRow(m_aEvaluateRow, m_pTable->getTableColumns().getBody(), sal_True,sal_True);
		}
		if (bOK)
		{
			if(!m_pTable->DeleteRow(m_xColumns.getBody()))
				return sal_False;
		}
	}
	return sal_True;
}

//-------------------------------------------------------------------
sal_Bool OResultSet::Move(IResultSetHelper::Movement eCursorPosition, sal_Int32 nOffset, sal_Bool bRetrieveData)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::Move" );

//IgnoreDeletedRows:
//
	sal_Int32 nTempPos = m_nRowPos;
	// exclusiver zugriff auf die Tabelle
	//	vos::OGuard* pGuard = m_pTable->Lock();

	if (m_aSQLIterator.getStatementType() == SQL_STATEMENT_SELECT &&
		!isCount())
	{
		if (!m_pFileSet.isValid()) // kein Index verfuegbar
		{
			// Normales FETCH
			ExecuteRow(eCursorPosition,nOffset,sal_False,bRetrieveData);

			// now set the bookmark for outside this is the logical pos  and not the file pos
			*(*m_aRow->get().begin()) = sal_Int32(m_nRowPos + 1);
		}
		else
		{
			switch(eCursorPosition)
			{
				case IResultSetHelper::NEXT:
					++m_nRowPos;
					break;
				case IResultSetHelper::PRIOR:
					if (m_nRowPos >= 0)
						--m_nRowPos;
					break;
				case IResultSetHelper::FIRST:
					m_nRowPos = 0;
					break;
				case IResultSetHelper::LAST:
                    //  OSL_ENSURE(IsRowCountFinal(), "Fehler im Keyset!"); // muss eingefroren sein, sonst Fehler beim SQLCursor
					m_nRowPos = m_pFileSet->get().size() - 1;
					break;
				case IResultSetHelper::RELATIVE:
					m_nRowPos += nOffset;
					break;
				case IResultSetHelper::ABSOLUTE:
				case IResultSetHelper::BOOKMARK:
                    if ( m_nRowPos == (nOffset -1) )
                        return sal_True;
					m_nRowPos = nOffset -1;
					break;
			}

			// OffRange?
            // Der FileCursor ist ausserhalb des gueltigen Bereichs, wenn
			// a.) m_nRowPos < 1
			// b.) Ein KeySet besteht und m_nRowPos > m_pFileSet->size()
			if (m_nRowPos < 0 || (m_pFileSet->isFrozen() && eCursorPosition != IResultSetHelper::BOOKMARK && m_nRowPos >= (sal_Int32)m_pFileSet->get().size() )) // && m_pFileSet->IsFrozen()
			{
				//	aStatus.Set(SQL_STAT_NO_DATA_FOUND);
				goto Error;
			}
			else
			{
				if (m_nRowPos < (sal_Int32)m_pFileSet->get().size())
				{
					// Fetch ueber Index
					ExecuteRow(IResultSetHelper::BOOKMARK,(m_pFileSet->get())[m_nRowPos],sal_False,bRetrieveData);

					// now set the bookmark for outside
					*(*m_aRow->get().begin()) = sal_Int32(m_nRowPos + 1);
                    if ( (bRetrieveData || m_pSQLAnalyzer->hasRestriction()) && m_pSQLAnalyzer->hasFunctions() )
	                {
		                m_pSQLAnalyzer->setSelectionEvaluationResult(m_aSelectRow,m_aColMapping);
	                }
				}
                else // Index muss weiter aufgebaut werden
				{
					// Zunaechst auf die letzte bekannte Zeile setzen
					if (!m_pFileSet->get().empty())
					{
						m_aFileSetIter = m_pFileSet->get().end()-1;
						//	m_pFileSet->SeekPos(m_pFileSet->size()-1);
						m_pTable->seekRow(IResultSetHelper::BOOKMARK, *m_aFileSetIter, m_nFilePos);
					}
					sal_Bool bOK = sal_True;
					// Ermitteln der Anzahl weiterer Fetches
					while (bOK && m_nRowPos >= (sal_Int32)m_pFileSet->get().size())
					{
						if (m_pEvaluationKeySet)
						{
							if (m_nRowPos >= (sal_Int32)m_pEvaluationKeySet->size())
								return sal_False;
								//	aStatus.Set(SQL_STAT_NO_DATA_FOUND);
							else if (m_nRowPos == 0)
							{
								m_aEvaluateIter = m_pEvaluationKeySet->begin();
								bOK = ExecuteRow(IResultSetHelper::BOOKMARK,*m_aEvaluateIter,sal_True, bRetrieveData);
							}
							else
							{
								++m_aEvaluateIter;
								bOK = ExecuteRow(IResultSetHelper::BOOKMARK,*m_aEvaluateIter,sal_True, bRetrieveData);
							}
						}
						else
							bOK = ExecuteRow(IResultSetHelper::NEXT,1,sal_True, sal_False);//bRetrieveData);
					}

					if (bOK)
					{
						// jetzt nochmal die Ergebnisse lesen
						m_pTable->fetchRow(m_aRow, m_pTable->getTableColumns().getBody(), sal_True,bRetrieveData);

						// now set the bookmark for outside
						*(*m_aRow->get().begin()) = sal_Int32(m_nRowPos + 1);

                        if ( (bRetrieveData || m_pSQLAnalyzer->hasRestriction()) && m_pSQLAnalyzer->hasFunctions() )
	                    {
		                    m_pSQLAnalyzer->setSelectionEvaluationResult(m_aSelectRow,m_aColMapping);
	                    }
					}
					else if (!m_pFileSet->isFrozen())					// keinen gueltigen Satz gefunden
					{
						//m_pFileSet->Freeze();
						m_pFileSet->setFrozen();

						//	DELETEZ(m_pEvaluationKeySet);
						m_pEvaluationKeySet = NULL;
						//	aStatus.Set(SQL_STAT_NO_DATA_FOUND);
						goto Error;
					}
				}
			}
		}
	}
	else if (m_aSQLIterator.getStatementType() == SQL_STATEMENT_SELECT && isCount())
	{
		// Fetch des COUNT(*)
		switch (eCursorPosition)
		{
			case IResultSetHelper::NEXT:
				++m_nRowPos;
				break;
			case IResultSetHelper::PRIOR:
				--m_nRowPos;
				break;
			case IResultSetHelper::FIRST:
				m_nRowPos = 0;
				break;
			case IResultSetHelper::LAST:
				m_nRowPos = 0;
				break;
			case IResultSetHelper::RELATIVE:
				m_nRowPos += nOffset;
				break;
			case IResultSetHelper::ABSOLUTE:
			case IResultSetHelper::BOOKMARK:
				m_nRowPos = nOffset - 1;
				break;
		}

        if ( m_nRowPos < 0 )
            goto Error;
		else if (m_nRowPos == 0)
		{
			// COUNT(*) in Ergebnisrow packen
			// (muss die erste und einzige Variable in der Row sein)
			if (m_aRow->get().size() >= 2)
			{
				*(m_aRow->get())[1] = m_nRowCountResult;
				*(m_aRow->get())[0] = sal_Int32(1);
				(m_aRow->get())[1]->setBound(sal_True);
				(m_aSelectRow->get())[1] = (m_aRow->get())[1];
			}
		}
		else
		{
			m_bEOF = sal_True;
			m_nRowPos = 1;
			return sal_False;
		}
	}
	else
		// Fetch nur bei SELECT moeglich!
		return sal_False;

	return sal_True;

Error:
	// steht der Cursor vor dem ersten Satz
	// dann wird die position beibehalten
	if (nTempPos == -1)
		m_nRowPos = nTempPos;
	else
	{
		switch(eCursorPosition)
		{
			case IResultSetHelper::PRIOR:
			case IResultSetHelper::FIRST:
				m_nRowPos = -1;
				break;
			case IResultSetHelper::LAST:
			case IResultSetHelper::NEXT:
			case IResultSetHelper::ABSOLUTE:
			case IResultSetHelper::RELATIVE:
				if (nOffset > 0)
					m_nRowPos = m_pFileSet.isValid() ? (sal_Int32)m_pFileSet->get().size() : -1;
				else if (nOffset < 0)
					m_nRowPos = -1;
				break;
			case IResultSetHelper::BOOKMARK:
				m_nRowPos = nTempPos;	 // vorherige Position
		}
	}
	//	delete pGuard;
    //  rMode = (!bShowDeleted && aStatus.IsSuccessful() && m_aRow->isDeleted()) ?  // keine Anzeige von geloeschten Saetzen
				//	OCursor::SQL_MOD_INVALID : OCursor::SQL_MOD_NONE;
	return sal_False;
}
// -------------------------------------------------------------------------
void OResultSet::sortRows()
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::sortRows" );
	if (!m_pSQLAnalyzer->hasRestriction() && m_aOrderbyColumnNumber.size() == 1)
	{
		// Ist nur ein Feld fuer die Sortierung angegeben
		// Und diese Feld ist indiziert, dann den Index ausnutzen
		Reference<XIndexesSupplier> xIndexSup;
		m_pTable->queryInterface(::getCppuType((const Reference<XIndexesSupplier>*)0)) >>= xIndexSup;
		//	Reference<XIndexesSupplier> xIndexSup(m_pTable,UNO_QUERY);
		Reference<XIndexAccess> xIndexes;
		if(xIndexSup.is())
		{
			xIndexes.set(xIndexSup->getIndexes(),UNO_QUERY);
			Reference<XPropertySet> xColProp;
			if(m_aOrderbyColumnNumber[0] < xIndexes->getCount())
			{
				xColProp.set(xIndexes->getByIndex(m_aOrderbyColumnNumber[0]),UNO_QUERY);
				// iterate through the indexes to find the matching column
				const sal_Int32 nCount = xIndexes->getCount();
				for(sal_Int32 i=0; i < nCount;++i)
				{
					Reference<XColumnsSupplier> xIndex(xIndexes->getByIndex(i),UNO_QUERY);
					Reference<XNameAccess> xIndexCols = xIndex->getColumns();
					if(xIndexCols->hasByName(comphelper::getString(xColProp->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_NAME)))))
					{
						m_pFileSet = new OKeySet();

						if(fillIndexValues(xIndex))
							return;
					}
				}
			}
		}
	}

	OSortIndex::TKeyTypeVector eKeyType(m_aOrderbyColumnNumber.size());
	::std::vector<sal_Int32>::iterator aOrderByIter = m_aOrderbyColumnNumber.begin();
	for (::std::vector<sal_Int16>::size_type i=0;aOrderByIter != m_aOrderbyColumnNumber.end(); ++aOrderByIter,++i)
	{
		OSL_ENSURE((sal_Int32)m_aSelectRow->get().size() > *aOrderByIter,"Invalid Index");
		switch ((*(m_aSelectRow->get().begin()+*aOrderByIter))->getValue().getTypeKind())
		{
		    case DataType::CHAR:
			case DataType::VARCHAR:
            case DataType::LONGVARCHAR:
				eKeyType[i] = SQL_ORDERBYKEY_STRING;
				break;

			case DataType::OTHER:
			case DataType::TINYINT:
			case DataType::SMALLINT:
			case DataType::INTEGER:
			case DataType::DECIMAL:
			case DataType::NUMERIC:
			case DataType::REAL:
			case DataType::DOUBLE:
			case DataType::DATE:
			case DataType::TIME:
			case DataType::TIMESTAMP:
			case DataType::BIT:
				eKeyType[i] = SQL_ORDERBYKEY_DOUBLE;
				break;

		// Andere Typen sind nicht implementiert (und damit immer sal_False)
			default:
				eKeyType[i] = SQL_ORDERBYKEY_NONE;
				OSL_ASSERT("OFILECursor::Execute: Datentyp nicht implementiert");
				break;
		}
		(m_aSelectRow->get())[*aOrderByIter]->setBound(sal_True);
	}

	m_pSortIndex = new OSortIndex(eKeyType,m_aOrderbyAscending);

	if (m_pEvaluationKeySet)
	{
		m_aEvaluateIter = m_pEvaluationKeySet->begin();

		while (m_aEvaluateIter != m_pEvaluationKeySet->end())
		{
			ExecuteRow(IResultSetHelper::BOOKMARK,(*m_aEvaluateIter),sal_True);
			++m_aEvaluateIter;
		}
	}
	else
	{
        while ( ExecuteRow( IResultSetHelper::NEXT, 1, sal_False, sal_True ) )
	    {
            m_aSelectRow->get()[0]->setValue( m_aRow->get()[0]->getValue() );
            if ( m_pSQLAnalyzer->hasFunctions() )
                m_pSQLAnalyzer->setSelectionEvaluationResult( m_aSelectRow, m_aColMapping );
            const sal_Int32 nBookmark = (*m_aRow->get().begin())->getValue();
            ExecuteRow( IResultSetHelper::BOOKMARK, nBookmark, sal_True, sal_False );
	    }
	}

	// Sortiertes Keyset erzeugen
	//	DELETEZ(m_pEvaluationKeySet);
	m_pEvaluationKeySet = NULL;
	m_pFileSet = NULL;
	m_pFileSet = m_pSortIndex->CreateKeySet();
	//	if(!bDistinct)
		//	SetRowCount(pFileSet->count());
	DELETEZ(m_pSortIndex);
	// Nun kann ueber den Index sortiert zugegriffen werden.
}


// -------------------------------------------------------------------------
sal_Bool OResultSet::OpenImpl()
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::OpenImpl" );
	OSL_ENSURE(m_pSQLAnalyzer,"No analyzer set with setSqlAnalyzer!");
	if(!m_pTable)
	{
		const OSQLTables& xTabs = m_aSQLIterator.getTables();
		if ((xTabs.begin() == xTabs.end()) || !xTabs.begin()->second.is())
            lcl_throwError(STR_QUERY_TOO_COMPLEX,*this);

		if ( xTabs.size() > 1 || m_aSQLIterator.hasErrors() )
            lcl_throwError(STR_QUERY_MORE_TABLES,*this);

		OSQLTable xTable = xTabs.begin()->second;
		m_xColumns = m_aSQLIterator.getSelectColumns();

		m_xColNames = xTable->getColumns();
		m_xColsIdx.set(m_xColNames,UNO_QUERY);
		doTableSpecials(xTable);
		Reference<XComponent> xComp(xTable,UNO_QUERY);
		if(xComp.is())
			xComp->addEventListener(this);
	}

	m_pTable->refreshHeader();

	sal_Int32 nColumnCount = m_xColsIdx->getCount();

	initializeRow(m_aRow,nColumnCount);
	initializeRow(m_aEvaluateRow,nColumnCount);
	initializeRow(m_aInsertRow,nColumnCount);


	m_nResultSetConcurrency = (m_pTable->isReadOnly() || isCount()) ? ResultSetConcurrency::READ_ONLY : ResultSetConcurrency::UPDATABLE;

	// Neuen Index aufbauen:
	m_pFileSet = NULL;
	//	DELETEZ(m_pEvaluationKeySet);

	// An den Anfang positionieren
	m_nRowPos = -1;
	m_nFilePos  = 0;
	m_nRowCountResult = -1;

	// exclusiver zugriff auf die Tabelle
	//	vos::OGuard* pGuard = pTable->Lock();
	m_nLastVisitedPos = m_pTable->getCurrentLastPos();

	switch(m_aSQLIterator.getStatementType())
	{
		case SQL_STATEMENT_SELECT:
		{
			if(isCount())
			{
				if(m_xColumns->get().size() > 1)
                    lcl_throwError(STR_QUERY_COMPLEX_COUNT,*this);

				m_nRowCountResult = 0;
				// Vorlaeufig einfach ueber alle Datensaetze iterieren und
				// dabei die Aktionen bearbeiten (bzw. einfach nur zaehlen):
				{
					sal_Bool bOK = sal_True;
					if (m_pEvaluationKeySet)
					{
						m_aEvaluateIter = m_pEvaluationKeySet->begin();
						bOK = m_aEvaluateIter == m_pEvaluationKeySet->end();

					}
					while (bOK)
					{
						if (m_pEvaluationKeySet)
							ExecuteRow(IResultSetHelper::BOOKMARK,(*m_aEvaluateIter),sal_True);
						else
							bOK = ExecuteRow(IResultSetHelper::NEXT,1,sal_True);

						if (bOK)
						{
							m_nRowCountResult++;
							if(m_pEvaluationKeySet)
							{
								++m_aEvaluateIter;
								bOK = m_aEvaluateIter == m_pEvaluationKeySet->end();
							}
						}
					}

					// Ergebnis von COUNT(*) in m_nRowCountResult merken.
					// nRowCount, also die Anzahl der Rows in der Ergebnismenge, ist bei dieser
					// Anfrage = 1!
					m_pEvaluationKeySet = NULL;
					//	DELETEZ(m_pEvaluationKeySet);
				}
			}
			else
			{
				sal_Bool bDistinct = sal_False;
				sal_Bool bWasSorted = sal_False;
				OSQLParseNode *pDistinct = m_pParseTree->getChild(1);
				::std::vector<sal_Int32>				aOrderbyColumnNumberSave;
				::std::vector<TAscendingOrder>          aOrderbyAscendingSave;

				if (pDistinct && pDistinct->getTokenID() == SQL_TOKEN_DISTINCT )
				{
					// Sort on all columns, saving original order for later
					if(IsSorted())
					{
						aOrderbyColumnNumberSave = m_aOrderbyColumnNumber;// .assign(m_aOrderbyColumnNumber.begin(), m_aOrderbyColumnNumber.end());
                        m_aOrderbyColumnNumber.clear();
						aOrderbyAscendingSave.assign(m_aOrderbyAscending.begin(), m_aOrderbyAscending.end());
						bWasSorted = sal_True;
					}

					// the first column is the bookmark column
					::std::vector<sal_Int32>::iterator aColStart = (m_aColMapping.begin()+1);
					::std::copy(aColStart, m_aColMapping.end(),::std::back_inserter(m_aOrderbyColumnNumber));
//					m_aOrderbyColumnNumber.assign(aColStart, m_aColMapping.end());
					m_aOrderbyAscending.assign(m_aColMapping.size()-1, SQL_ASC);
					bDistinct = sal_True;
				}

				if (IsSorted())
					sortRows();

				if (!m_pFileSet.isValid())
				{
					m_pFileSet = new OKeySet();

					if (!m_pSQLAnalyzer->hasRestriction())
					// jetzt kann das Keyset schon gefuellt werden!
					// Aber Achtung: es wird davon ausgegangen, das die FilePositionen als Folge 1..n
					// abgelegt werden!
					{
						if ( m_nLastVisitedPos > 0)
							m_pFileSet->get().reserve( m_nLastVisitedPos );
						for (sal_Int32 i = 0; i < m_nLastVisitedPos; i++)
                            m_pFileSet->get().push_back(i + 1);
					}
				}
				OSL_ENSURE(m_pFileSet.isValid(),"Kein KeySet vorhanden! :-(");

				if(bDistinct && m_pFileSet.isValid())   // sicher ist sicher
				{
					OValueRow aSearchRow = new OValueVector(m_aRow->get().size());
					OValueRefVector::Vector::iterator aRowIter = m_aRow->get().begin();
					OValueVector::Vector::iterator aSearchIter = aSearchRow->get().begin();
					for	(	++aRowIter,++aSearchIter;	// the first column is the bookmark column
							aRowIter != m_aRow->get().end();
							++aRowIter,++aSearchIter)
                        aSearchIter->setBound((*aRowIter)->isBound());

					size_t nMaxRow = m_pFileSet->get().size();

					if (nMaxRow)
					{
    #if OSL_DEBUG_LEVEL > 1
						sal_Int32 nFound=0;
	#endif
						sal_Int32 nPos;
						sal_Int32 nKey;

						for( size_t j = nMaxRow-1; j > 0; --j)
						{
                            nPos = (m_pFileSet->get())[j];
							ExecuteRow(IResultSetHelper::BOOKMARK,nPos,sal_False);
							m_pSQLAnalyzer->setSelectionEvaluationResult(m_aSelectRow,m_aColMapping);
							{ // copy row values
								OValueRefVector::Vector::iterator copyFrom = m_aSelectRow->get().begin();
								OValueVector::Vector::iterator copyTo = aSearchRow->get().begin();
								for	(	++copyFrom,++copyTo;	// the first column is the bookmark column
										copyFrom != m_aSelectRow->get().end();
										++copyFrom,++copyTo)
											*copyTo = *(*copyFrom);
								// *aSearchRow = *m_aRow;
							}

							// compare with next row
							nKey = (m_pFileSet->get())[j-1];
							ExecuteRow(IResultSetHelper::BOOKMARK,nKey,sal_False);
							m_pSQLAnalyzer->setSelectionEvaluationResult(m_aSelectRow,m_aColMapping);
							OValueRefVector::Vector::iterator loopInRow = m_aSelectRow->get().begin();
							OValueVector::Vector::iterator existentInSearchRow = aSearchRow->get().begin();
							for	(	++loopInRow,++existentInSearchRow;	// the first column is the bookmark column
									loopInRow != m_aSelectRow->get().end();
									++loopInRow,++existentInSearchRow)
							{
								if ( (*loopInRow)->isBound() && !( *(*loopInRow) == *existentInSearchRow) )
									break;
							}

							if(loopInRow == m_aSelectRow->get().end())
								(m_pFileSet->get())[j] = 0; // Rows match -- Mark for deletion by setting key to 0
    #if OSL_DEBUG_LEVEL > 1
							else
								nFound++;
	#endif
						}

						m_pFileSet->get().erase(::std::remove_if(m_pFileSet->get().begin(),m_pFileSet->get().end(),
															::std::bind2nd(::std::equal_to<sal_Int32>(),0))
										  ,m_pFileSet->get().end());

						if (bWasSorted)
						{
							// Re-sort on original requested order
							m_aOrderbyColumnNumber = aOrderbyColumnNumberSave;
							m_aOrderbyAscending.assign(aOrderbyAscendingSave.begin(), aOrderbyAscendingSave.end());

							TIntVector aEvaluationKeySet(m_pFileSet->get());
							m_pEvaluationKeySet = &aEvaluationKeySet;
							sortRows();
						}
						else
						{
							m_aOrderbyColumnNumber.clear();
							m_aOrderbyAscending.clear();
							::std::sort(m_pFileSet->get().begin(),m_pFileSet->get().end());
						}
					}
					//	SetRowCount(m_pFileSet->count());
				}
			}
		}	break;

		case SQL_STATEMENT_UPDATE:
		case SQL_STATEMENT_DELETE:
			// waehrend der Bearbeitung die Anzahl der bearbeiteten Rows zaehlen:
			m_nRowCountResult = 0;
			// Vorlaeufig einfach ueber alle Datensaetze iterieren und
			// dabei die Aktionen bearbeiten (bzw. einfach nur zaehlen):
			{

				sal_Bool bOK = sal_True;
				if (m_pEvaluationKeySet)
				{
					m_aEvaluateIter = m_pEvaluationKeySet->begin();
					bOK = m_aEvaluateIter == m_pEvaluationKeySet->end();

				}
				while (bOK)
				{
					if (m_pEvaluationKeySet)
						ExecuteRow(IResultSetHelper::BOOKMARK,(*m_aEvaluateIter),sal_True);
					else
						bOK = ExecuteRow(IResultSetHelper::NEXT,1,sal_True);

					if (bOK)
					{
						m_nRowCountResult++;
						if(m_pEvaluationKeySet)
						{
							++m_aEvaluateIter;
							bOK = m_aEvaluateIter == m_pEvaluationKeySet->end();
						}
					}
				}

				// Ergebnis von COUNT(*) in nRowCountResult merken.
				// nRowCount, also die Anzahl der Rows in der Ergebnismenge, ist bei dieser
				// Anfrage = 1!
				//	DELETEZ(m_pEvaluationKeySet);
				m_pEvaluationKeySet = NULL;
			}
			//	SetRowCount(1);
			break;
		case SQL_STATEMENT_INSERT:
			m_nRowCountResult = 0;

			OSL_ENSURE(m_aAssignValues.isValid(),"No assign values set!");
			if(!m_pTable->InsertRow(m_aAssignValues.getBody(), sal_True,m_xColsIdx))
			{
				m_nFilePos  = 0;
				return sal_False;
			}

			m_nRowCountResult = 1;
			break;
        default:
            OSL_ENSURE( false, "OResultSet::OpenImpl: unsupported statement type!" );
            break;
	}

	// FilePos zuruecksetzen
	m_nFilePos  = 0;

	return sal_True;
}
//--------------------------------------------------------------------------
Sequence< sal_Int8 > OResultSet::getUnoTunnelImplementationId()
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getUnoTunnelImplementationId" );
	static ::cppu::OImplementationId * pId = 0;
	if (! pId)
	{
		::osl::MutexGuard aGuard( ::osl::Mutex::getGlobalMutex() );
		if (! pId)
		{
			static ::cppu::OImplementationId aId;
			pId = &aId;
		}
	}
	return pId->getImplementationId();
}

// com::sun::star::lang::XUnoTunnel
//------------------------------------------------------------------
sal_Int64 OResultSet::getSomething( const Sequence< sal_Int8 > & rId ) throw (RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getSomething" );
	return (rId.getLength() == 16 && 0 == rtl_compareMemory(getUnoTunnelImplementationId().getConstArray(),  rId.getConstArray(), 16 ) )
				? reinterpret_cast< sal_Int64 >( this )
				: 0;
}
// -----------------------------------------------------------------------------
void OResultSet::setBoundedColumns(const OValueRefRow& _rRow,
								   const OValueRefRow& _rSelectRow,
								   const ::vos::ORef<connectivity::OSQLColumns>& _rxColumns,
								   const Reference<XIndexAccess>& _xNames,
								   sal_Bool _bSetColumnMapping,
								   const Reference<XDatabaseMetaData>& _xMetaData,
								   ::std::vector<sal_Int32>& _rColMapping)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::setBoundedColumns" );
	::comphelper::UStringMixEqual aCase(_xMetaData->supportsMixedCaseQuotedIdentifiers());

	Reference<XPropertySet> xTableColumn;
	::rtl::OUString sTableColumnName, sSelectColumnRealName;

	const ::rtl::OUString sName		= OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_NAME);
	const ::rtl::OUString sRealName	= OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_REALNAME);
	const ::rtl::OUString sType		= OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPE);

	typedef ::std::map<OSQLColumns::Vector::iterator,sal_Bool> IterMap;
	IterMap aSelectIters;
	OValueRefVector::Vector::iterator aRowIter = _rRow->get().begin()+1;
	for	(sal_Int32 i=0;	// the first column is the bookmark column
         aRowIter != _rRow->get().end();
			++i, ++aRowIter
		)
	{
		(*aRowIter)->setBound(sal_False);
		try
		{
			// get the table column and it's name
			_xNames->getByIndex(i) >>= xTableColumn;
			OSL_ENSURE(xTableColumn.is(), "OResultSet::setBoundedColumns: invalid table column!");
			if (xTableColumn.is())
				xTableColumn->getPropertyValue(sName) >>= sTableColumnName;
			else
				sTableColumnName = ::rtl::OUString();

			// look if we have such a select column
			// TODO: would like to have a O(log n) search here ...
			for (	OSQLColumns::Vector::iterator aIter = _rxColumns->get().begin();
					aIter != _rxColumns->get().end();
					++aIter
				)
			{
				if((*aIter)->getPropertySetInfo()->hasPropertyByName(sRealName))
					(*aIter)->getPropertyValue(sRealName) >>= sSelectColumnRealName;
				else
					(*aIter)->getPropertyValue(sName) >>= sSelectColumnRealName;

				if ( aCase(sTableColumnName, sSelectColumnRealName) && !(*aRowIter)->isBound() && aSelectIters.end() == aSelectIters.find(aIter) )
				{
					aSelectIters.insert(IterMap::value_type(aIter,sal_True));
					if(_bSetColumnMapping)
					{
						sal_Int32 nSelectColumnPos = aIter - _rxColumns->get().begin() + 1;
							// the getXXX methods are 1-based ...
						sal_Int32 nTableColumnPos = i + 1;
							// get first table column is the bookmark column ...
						_rColMapping[nSelectColumnPos] = nTableColumnPos;
						(_rSelectRow->get())[nSelectColumnPos] = *aRowIter;
					}

					(*aRowIter)->setBound(sal_True);
					sal_Int32 nType = DataType::OTHER;
					if (xTableColumn.is())
						xTableColumn->getPropertyValue(sType) >>= nType;
					(*aRowIter)->setTypeKind(nType);

					break;
				}
			}
		}
		catch (Exception&)
		{
			OSL_ENSURE(sal_False, "OResultSet::setBoundedColumns: caught an Exception!");
		}
	}
	// in this case we got more select columns as columns exist in the table
	if ( _bSetColumnMapping && aSelectIters.size() != _rColMapping.size() )
	{
		Reference<XNameAccess> xNameAccess(_xNames,UNO_QUERY);
		Sequence< ::rtl::OUString > aSelectColumns = xNameAccess->getElementNames();

		for (	OSQLColumns::Vector::iterator aIter = _rxColumns->get().begin();
                aIter != _rxColumns->get().end();
					++aIter
				)
		{
			if ( aSelectIters.end() == aSelectIters.find(aIter) )
			{
				if ( (*aIter)->getPropertySetInfo()->hasPropertyByName(sRealName) )
					(*aIter)->getPropertyValue(sRealName) >>= sSelectColumnRealName;
				else
					(*aIter)->getPropertyValue(sName) >>= sSelectColumnRealName;

				if ( xNameAccess->hasByName( sSelectColumnRealName ) )
				{
					aSelectIters.insert(IterMap::value_type(aIter,sal_True));
					sal_Int32 nSelectColumnPos = aIter - _rxColumns->get().begin() + 1;
					const ::rtl::OUString* pBegin = aSelectColumns.getConstArray();
					const ::rtl::OUString* pEnd	  = pBegin + aSelectColumns.getLength();
					for(sal_Int32 i=0;pBegin != pEnd;++pBegin,++i)
					{
						if ( aCase(*pBegin, sSelectColumnRealName) )
						{
							// the getXXX methods are 1-based ...
							sal_Int32 nTableColumnPos = i + 1;
								// get first table column is the bookmark column ...
							_rColMapping[nSelectColumnPos] = nTableColumnPos;
							(_rSelectRow->get())[nSelectColumnPos] = (_rRow->get())[nTableColumnPos];
							break;
						}
					}
				}
			}
		}
	}
}
// -----------------------------------------------------------------------------
void SAL_CALL OResultSet::acquire() throw()
{
	OResultSet_BASE::acquire();
}
// -----------------------------------------------------------------------------
void SAL_CALL OResultSet::release() throw()
{
	OResultSet_BASE::release();
}
// -----------------------------------------------------------------------------
Reference< ::com::sun::star::beans::XPropertySetInfo > SAL_CALL OResultSet::getPropertySetInfo(  ) throw(RuntimeException)
{
    //RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getPropertySetInfo" );
	return ::cppu::OPropertySetHelper::createPropertySetInfo(getInfoHelper());
}
// -----------------------------------------------------------------------------
void OResultSet::doTableSpecials(const OSQLTable& _xTable)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::doTableSpecials" );
	Reference< ::com::sun::star::lang::XUnoTunnel> xTunnel(_xTable,UNO_QUERY);
	if(xTunnel.is())
	{
		m_pTable = reinterpret_cast< OFileTable* >( xTunnel->getSomething(OFileTable::getUnoTunnelImplementationId()) );
		if(m_pTable)
			m_pTable->acquire();
	}
}
// -----------------------------------------------------------------------------
void OResultSet::clearInsertRow()
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::clearInsertRow" );
	m_aRow->setDeleted(sal_False); // set to false here because this is the new row
	OValueRefVector::Vector::iterator aIter = m_aInsertRow->get().begin();
    const OValueRefVector::Vector::iterator aEnd = m_aInsertRow->get().end();
	for(sal_Int32 nPos = 0;aIter != aEnd;++aIter,++nPos)
	{
        ORowSetValueDecoratorRef& rValue = (*aIter);
		if ( rValue->isBound() )
		{
			(m_aRow->get())[nPos]->setValue( (*aIter)->getValue() );
		}
		rValue->setBound(nPos == 0);
		rValue->setModified(sal_False);
		rValue->setNull();
	}
}
// -----------------------------------------------------------------------------
void OResultSet::initializeRow(OValueRefRow& _rRow,sal_Int32 _nColumnCount)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::initializeRow" );
	if(!_rRow.isValid())
	{
		_rRow	= new OValueRefVector(_nColumnCount);
		(_rRow->get())[0]->setBound(sal_True);
		::std::for_each(_rRow->get().begin()+1,_rRow->get().end(),TSetRefBound(sal_False));
	}
}
// -----------------------------------------------------------------------------
sal_Bool OResultSet::fillIndexValues(const Reference< XColumnsSupplier> &/*_xIndex*/)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::fillIndexValues" );
	return sal_False;
}
// -----------------------------------------------------------------------------
sal_Bool OResultSet::move(IResultSetHelper::Movement _eCursorPosition, sal_Int32 _nOffset, sal_Bool _bRetrieveData)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::move" );
	return Move(_eCursorPosition,_nOffset,_bRetrieveData);
}
// -----------------------------------------------------------------------------
sal_Int32 OResultSet::getDriverPos() const
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::getDriverPos" );
	return (m_aRow->get())[0]->getValue();
}
// -----------------------------------------------------------------------------
sal_Bool OResultSet::deletedVisible() const
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::deletedVisible" );
	return m_bShowDeleted;
}
// -----------------------------------------------------------------------------
sal_Bool OResultSet::isRowDeleted() const
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::isRowDeleted" );
	return m_aRow->isDeleted();
}
// -----------------------------------------------------------------------------
void SAL_CALL OResultSet::disposing( const EventObject& Source ) throw (RuntimeException)
{
    RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OResultSet::disposing" );
	//	Reference<XInterface> xInt = m_pTable;
	Reference<XPropertySet> xProp = m_pTable;
	if(m_pTable && Source.Source == xProp)
	{
		m_pTable->release();
		m_pTable = NULL;
	}
}
// -----------------------------------------------------------------------------