FCL/sf/mw/homescreensrv: contentstorage/castorage/src/casqlquery.cpp@e36b2f4799c0 (annotated)

60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	1	/*
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	2	* Copyright (c) 2008 Nokia Corporation and/or its subsidiary(-ies).
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	3	* All rights reserved.
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	4	* This component and the accompanying materials are made available
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	5	* under the terms of "Eclipse Public License v1.0"
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	6	* which accompanies this distribution, and is available
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	7	* at the URL "http://www.eclipse.org/legal/epl-v10.html".
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	8	*
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	9	* Initial Contributors:
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	10	* Nokia Corporation - initial contribution.
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	11	*
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	12	* Contributors:
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	13	*
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	14	* Description: CCASqlQuery implementation
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	15	*
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	16	*/
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	17
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	18	#include <sqldb.h>
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	19	#include "casqlquery.h"
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	20	#include "casqlcommands.h"
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	21	#include "cainnerquery.h"
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	22	#include "caentryattribute.h"
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	23	#include "casqlquerycreator.h"
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	24	#include "caoperationparams.h"
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	25	#include "cadef.h"
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	26	#include "calocalizationentry.h"
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	27
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	28	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	29	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	30	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	31	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	32	CCaSqlQuery::CCaSqlQuery( RSqlDatabase& aSql ) :
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	33	iSqlDb( aSql )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	34	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	35	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	36
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	37	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	38	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	39	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	40	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	41	CCaSqlQuery::~CCaSqlQuery()
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	42	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	43	iStatement.Close();
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	44	iQuery.Close();
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	45	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	46
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	47	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	48	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	49	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	50	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	51	CCaSqlQuery* CCaSqlQuery::NewLC( RSqlDatabase& aSql )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	52	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	53	CCaSqlQuery* self = new ( ELeave ) CCaSqlQuery( aSql );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	54	CleanupStack::PushL( self );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	55	self->ConstructL();
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	56	return self;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	57	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	58
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	59	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	60	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	61	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	62	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	63	CCaSqlQuery* CCaSqlQuery::NewL( RSqlDatabase& aSql )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	64	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	65	CCaSqlQuery* self = CCaSqlQuery::NewLC( aSql );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	66	CleanupStack::Pop( self );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	67	return self;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	68	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	69
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	70	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	71	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	72	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	73	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	74	void CCaSqlQuery::ConstructL()
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	75	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	76	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	77
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	78	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	79	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	80	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	81	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	82	void CCaSqlQuery::PrepareL()
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	83	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	84	User::LeaveIfError( iStatement.Prepare( iSqlDb, iQuery ) );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	85	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	86	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	87	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	88	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	89	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	90	void CCaSqlQuery::CloseStatement()
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	91	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	92	iStatement.Close();
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	93	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	94	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	95	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	96	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	97	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	98	void CCaSqlQuery::ResetStatement()
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	99	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	100	iStatement.Reset();
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	101	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	102	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	103	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	104	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	105	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	106	void CCaSqlQuery::BindValuesForAddL( const CCaInnerEntry* aEntry )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	107	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	108	switch ( Type() )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	109	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	110	case EEntryTable: // = 1
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	111	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	112	BindValuesForAddEntryL( aEntry );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	113	break;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	114	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	115	case EIconTable:
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	116	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	117	BindValuesForAddIconL( aEntry );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	118	break;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	119	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	120	case EAttributeTable:
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	121	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	122	break;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	123	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	124	default:
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	125	User::Leave( KErrNotSupported );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	126	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	127	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	128
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	129	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	130	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	131	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	132	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	133	void CCaSqlQuery::BindValuesForAddEntryL( const CCaInnerEntry* aEntry )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	134	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	135	if( iQuery.Find( KSQLEnText ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	136	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	137	BindTextL( iStatement.ParameterIndex( KSQLEnText ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	138	aEntry->GetText() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	139	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	140	if( iQuery.Find( KSQLEnDescription )!= KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	141	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	142	BindTextL( iStatement.ParameterIndex( KSQLEnDescription ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	143	aEntry->GetDescription() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	144	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	145	if( iQuery.Find( KSQLEnRole ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	146	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	147	BindIntL( iStatement.ParameterIndex( KSQLEnRole ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	148	aEntry->GetRole() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	149	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	150	if( iQuery.Find( KSQLEnTypeName ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	151	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	152	BindTextL( iStatement.ParameterIndex( KSQLEnTypeName ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	153	aEntry->GetEntryTypeName() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	154	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	155	if( iQuery.Find( KSQLEnIdIcon ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	156	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	157	BindIntL( iStatement.ParameterIndex( KSQLEnIdIcon ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	158	aEntry->GetIconId() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	159	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	160	if( iQuery.Find( KSQLEnCreationTime ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	161	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	162	TTime currentTime( 0 );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	163	currentTime.UniversalTime();
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	164	BindInt64L( iStatement.ParameterIndex( KSQLEnCreationTime ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	165	currentTime.Int64() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	166	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	167	if( iQuery.Find( KSQLEnUid ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	168	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	169	BindIntL( iStatement.ParameterIndex( KSQLEnUid ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	170	aEntry->GetUid() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	171	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	172	if( iQuery.Find( KSQLEnFlags )!= KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	173	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	174	BindIntL( iStatement.ParameterIndex( KSQLEnFlags ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	175	aEntry->GetFlags() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	176	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	177	if( iQuery.Find( KSQLEntryId ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	178	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	179	BindIntL( iStatement.ParameterIndex( KSQLEntryId ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	180	aEntry->GetId() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	181	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	182	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	183
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	184	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	185	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	186	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	187	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	188	void CCaSqlQuery::BindValuesForAddIconL( const CCaInnerEntry* aEntry )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	189	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	190	BindValuesForGetIconL( aEntry );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	191	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	192
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	193	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	194	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	195	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	196	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	197	void CCaSqlQuery::BindValuesForAddAttributeL( const CCaInnerEntry* aEntry,
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	198	const CCaEntryAttribute* aAttr )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	199	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	200	if( iQuery.Find( KSQLAttrEntryID ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	201	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	202	BindIntL(iStatement.ParameterIndex( KSQLAttrEntryID ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	203	aEntry->GetId() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	204	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	205	if( iQuery.Find( KSQLAttrName ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	206	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	207	BindTextL( iStatement.ParameterIndex( KSQLAttrName ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	208	aAttr->Name() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	209	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	210	if( iQuery.Find( KSQLAttrValue ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	211	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	212	BindTextL( iStatement.ParameterIndex( KSQLAttrValue ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	213	aAttr->Value() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	214	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	215	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	216
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	217	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	218	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	219	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	220	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	221	void CCaSqlQuery::BindValuesForOrganizeL( const RArray<TInt>& aEntryIds,
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	222	TCaOperationParams& aParams, const TInt aEntryId )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	223	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	224	if( aEntryIds.Count() > 0 )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	225	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	226	BindIdsL( aEntryIds, KSQLEntryId );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	227	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	228	if( iQuery.Find( KSQLGEIdGroup ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	229	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	230	BindIntL( iStatement.ParameterIndex( KSQLGEIdGroup ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	231	aParams.iGroupId );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	232	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	233	if( iQuery.Find( KSQLEntryIdBefore ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	234	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	235	BindIntL( iStatement.ParameterIndex( KSQLEntryIdBefore ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	236	aParams.iBeforeEntryId );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	237	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	238	if( iQuery.Find( KSQLGEEntryId ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	239	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	240	BindIntL( iStatement.ParameterIndex( KSQLGEEntryId ), aEntryId );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	241	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	242	if( iQuery.Find( KSQLShiftThreshold ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	243	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	244	BindIntL( iStatement.ParameterIndex( KSQLShiftThreshold ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	245	aEntryIds.Count() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	246	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	247	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	248
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	249	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	250	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	251	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	252	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	253	void CCaSqlQuery::BindValuesForLaunchL( const TInt aEntryId,
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	254	const TInt64 aLaunchTime )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	255	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	256	if( iQuery.Find( KSQLLaLaunchEntryId ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	257	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	258	BindIntL( iStatement.ParameterIndex(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	259	KSQLLaLaunchEntryId ), aEntryId );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	260	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	261	if( iQuery.Find( KSQLLaLaunchTime ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	262	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	263	BindInt64L( iStatement.ParameterIndex(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	264	KSQLLaLaunchTime ), aLaunchTime );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	265	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	266	if( iQuery.Find( KSQLEnFlags ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	267	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	268	BindIntL( iStatement.ParameterIndex( KSQLEnFlags ), EUsed );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	269	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	270	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	271
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	272	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	273	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	274	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	275	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	276	void CCaSqlQuery::BindValuesForRemoveL( const TInt aEntryId,
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	277	const TInt aIconId )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	278	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	279	if( iQuery.Find( KSQLEntryId )!= KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	280	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	281	BindIntL( iStatement.ParameterIndex( KSQLEntryId ), aEntryId );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	282	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	283	if( iQuery.Find( KSQLIconId )!= KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	284	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	285	BindIntL( iStatement.ParameterIndex( KSQLIconId ), aIconId );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	286	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	287	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	288
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	289	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	290	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	291	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	292	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	293	void CCaSqlQuery::BindValuesForCustomSortL( const TInt aGroupId, const TInt aEntryId,
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	294	const TInt aNewPostion )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	295	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	296	if( iQuery.Find( KSQLGEIdGroup )!= KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	297	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	298	BindIntL( iStatement.ParameterIndex( KSQLGEIdGroup ), aGroupId );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	299	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	300	if( iQuery.Find( KSQLGEEntryId )!= KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	301	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	302	BindIntL( iStatement.ParameterIndex( KSQLGEEntryId ), aEntryId );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	303	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	304	if( iQuery.Find( KSQLGEPosition )!= KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	305	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	306	BindIntL( iStatement.ParameterIndex( KSQLGEPosition ), aNewPostion );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	307	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	308	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	309
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	310	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	311	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	312	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	313	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	314	void CCaSqlQuery::BindTextL( TInt aParameterIndex,
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	315	const TDesC& aParameterValue )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	316	{
124 e36b2f4799c0 Revision: 201037 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 104 diff changeset	317	if( aParameterValue.Length() )
e36b2f4799c0 Revision: 201037 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 104 diff changeset	318	{
e36b2f4799c0 Revision: 201037 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 104 diff changeset	319	User::LeaveIfError( iStatement.BindText( aParameterIndex,
e36b2f4799c0 Revision: 201037 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 104 diff changeset	320	aParameterValue ) );
e36b2f4799c0 Revision: 201037 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 104 diff changeset	321	}
e36b2f4799c0 Revision: 201037 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 104 diff changeset	322	else
e36b2f4799c0 Revision: 201037 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 104 diff changeset	323	{
e36b2f4799c0 Revision: 201037 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 104 diff changeset	324	User::LeaveIfError( iStatement.BindNull( aParameterIndex) );
e36b2f4799c0 Revision: 201037 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 104 diff changeset	325	}
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	326	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	327
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	328	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	329	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	330	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	331	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	332	void CCaSqlQuery::BindIntL( TInt aParameterIndex,
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	333	TInt aParameterValue )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	334	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	335	User::LeaveIfError( aParameterIndex );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	336	User::LeaveIfError( iStatement.BindInt( aParameterIndex,
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	337	aParameterValue ) );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	338	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	339
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	340	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	341	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	342	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	343	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	344	void CCaSqlQuery::BindInt64L( TInt aParameterIndex,
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	345	TInt64 aParameterValue )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	346	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	347	User::LeaveIfError( aParameterIndex );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	348	User::LeaveIfError( iStatement.BindInt64( aParameterIndex,
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	349	aParameterValue ) );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	350	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	351
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	352	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	353	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	354	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	355	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	356	void CCaSqlQuery::SetQueryL( const TDesC& aQuery )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	357	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	358	iQuery.Close();
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	359	iQuery.CreateL( aQuery );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	360	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	361
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	362
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	363	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	364	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	365	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	366	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	367	void CCaSqlQuery::BindValuesForLocalizeL( CCaLocalizationEntry& aLocalization )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	368	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	369	if( iQuery.Find( KSQLLocRowId ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	370	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	371	BindIntL( iStatement.ParameterIndex(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	372	KSQLLocRowId ), aLocalization.GetRowId() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	373	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	374	if( iQuery.Find( KSQLLocTable ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	375	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	376	BindTextL(iStatement.ParameterIndex( KSQLLocTable ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	377	aLocalization.GetTableName() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	378	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	379	if( iQuery.Find( KSQLLocAttribute ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	380	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	381	BindTextL(iStatement.ParameterIndex( KSQLLocAttribute ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	382	aLocalization.GetAttributeName() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	383	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	384	if( iQuery.Find( KSQLLocString ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	385	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	386	BindTextL(iStatement.ParameterIndex( KSQLLocString ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	387	aLocalization.GetLocalizedString() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	388	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	389	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	390
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	391	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	392	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	393	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	394	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	395	void CCaSqlQuery::BindValuesForPropertyL( const TDesC& aProperty )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	396	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	397	if( iQuery.Find( KSQLDbProperty ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	398	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	399	BindTextL( iStatement.ParameterIndex(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	400	KSQLDbProperty ), aProperty );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	401	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	402	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	403
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	404	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	405	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	406	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	407	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	408	void CCaSqlQuery::BindValuesForPropertyUpdateL( const TDesC& aProperty, const TDesC& aPropertyValue )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	409	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	410	BindValuesForPropertyL( aProperty );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	411
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	412	if( iQuery.Find( KSQLDbValue ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	413	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	414	BindTextL( iStatement.ParameterIndex(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	415	KSQLDbValue ), aPropertyValue );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	416	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	417	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	418
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	419	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	420	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	421	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	422	//
80 397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	423	void CCaSqlQuery::BindValuesForGetLocalizationEntryL(
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	424	const CCaLocalizationEntry& aLocalization)
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	425	{
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	426	BindIntL( iStatement.ParameterIndex( KSQLLocRowId ),
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	427	aLocalization.GetRowId() );
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	428	BindTextL( iStatement.ParameterIndex( KSQLLocTable ),
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	429	aLocalization.GetTableName() );
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	430	BindTextL( iStatement.ParameterIndex( KSQLLocAttribute ),
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	431	aLocalization.GetAttributeName() );
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	432	}
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	433
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	434	// ---------------------------------------------------------------------------
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	435	//
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	436	// ---------------------------------------------------------------------------
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	437	//
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	438	void CCaSqlQuery::BindValuesForLocalizationEntryL(
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	439	const CCaLocalizationEntry& aLocalization)
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	440	{
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	441	BindIntL( iStatement.ParameterIndex( KSQLLocRowId ),
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	442	aLocalization.GetRowId() );
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	443	BindTextL( iStatement.ParameterIndex( KSQLLocTable ),
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	444	aLocalization.GetTableName() );
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	445	BindTextL( iStatement.ParameterIndex( KSQLLocAttribute ),
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	446	aLocalization.GetAttributeName() );
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	447	BindTextL( iStatement.ParameterIndex( KSQLLocQmFilename ),
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	448	aLocalization.GetQmFilename() );
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	449	BindTextL( iStatement.ParameterIndex( KSQLLocString ),
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	450	aLocalization.GetStringId() );
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	451	}
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	452
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	453
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	454	// ---------------------------------------------------------------------------
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	455	//
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	456	// ---------------------------------------------------------------------------
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	457	//
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	458	void CCaSqlQuery::BindValuesForGetEntriesL( const CCaInnerQuery* aQuery )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	459	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	460	if( aQuery->GetIds().Count() > 0 )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	461	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	462	BindIdsL( aQuery->GetIds(), KSQLEntryId );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	463	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	464	else
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	465	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	466	if( aQuery->GetFlagsOn() != 0 && iQuery.Find( KSQLFlagsOn )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	467	!= KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	468	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	469	BindIntL( iStatement.ParameterIndex( KSQLFlagsOn ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	470	aQuery->GetFlagsOn() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	471	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	472	if( aQuery->GetFlagsOff() != 0 && iQuery.Find( KSQLFlagsOff )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	473	!= KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	474	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	475	BindIntL( iStatement.ParameterIndex( KSQLFlagsOff ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	476	aQuery->GetFlagsOff() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	477	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	478	if( aQuery->GetRole() != -1 && iQuery.Find( KSQLEnRole )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	479	!= KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	480	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	481	BindIntL( iStatement.ParameterIndex( KSQLEnRole ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	482	aQuery->GetRole() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	483	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	484	if( aQuery->GetParentId() != -1 && iQuery.Find( KSQLGEIdGroup )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	485	!= KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	486	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	487	BindIntL( iStatement.ParameterIndex( KSQLGEIdGroup ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	488	aQuery->GetParentId() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	489	}
104 9b022b1f357c Revision: 201025 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 80 diff changeset	490	if( aQuery->GetChildId() != -1 && iQuery.Find( KSQLGEEntryId )
9b022b1f357c Revision: 201025 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 80 diff changeset	491	!= KErrNotFound )
9b022b1f357c Revision: 201025 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 80 diff changeset	492	{
9b022b1f357c Revision: 201025 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 80 diff changeset	493	BindIntL( iStatement.ParameterIndex( KSQLGEEntryId ),
9b022b1f357c Revision: 201025 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 80 diff changeset	494	aQuery->GetChildId() );
9b022b1f357c Revision: 201025 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 80 diff changeset	495	}
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	496	if( aQuery->GetUid() != 0 && iQuery.Find( KSQLEnUid )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	497	!= KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	498	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	499	BindIntL( iStatement.ParameterIndex( KSQLEnUid ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	500	aQuery->GetUid() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	501	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	502	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	503	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	504
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	505	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	506	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	507	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	508	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	509	void CCaSqlQuery::BindValuesForGetEntriesL( const CCaInnerEntry* aEntry )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	510	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	511	if( iQuery.Find( KSQLEntryId ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	512	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	513	BindIntL(iStatement.ParameterIndex( KSQLEntryId ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	514	aEntry->GetId() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	515	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	516	if( iQuery.Find( KSQLEnText) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	517	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	518	BindTextL(iStatement.ParameterIndex( KSQLEnText ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	519	aEntry->GetText() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	520	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	521	if( iQuery.Find( KSQLEnDescription ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	522	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	523	BindTextL(iStatement.ParameterIndex( KSQLEnDescription ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	524	aEntry->GetDescription() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	525	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	526	if( iQuery.Find( KSQLEnRole ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	527	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	528	BindIntL( iStatement.ParameterIndex( KSQLEnRole ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	529	aEntry->GetRole() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	530	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	531	if( iQuery.Find( KSQLEnTypeName ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	532	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	533	BindTextL( iStatement.ParameterIndex( KSQLEnTypeName ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	534	aEntry->GetEntryTypeName() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	535	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	536	if( iQuery.Find( KSQLEnIdIcon ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	537	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	538	BindIntL( iStatement.ParameterIndex( KSQLEnIdIcon ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	539	aEntry->GetIconId() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	540	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	541	if( iQuery.Find( KSQLEnUid ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	542	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	543	BindIntL( iStatement.ParameterIndex(KSQLEnUid), aEntry->GetUid() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	544	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	545	if( iQuery.Find( KSQLEnFlags ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	546	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	547	BindIntL( iStatement.ParameterIndex( KSQLEnFlags ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	548	aEntry->GetFlags() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	549	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	550	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	551	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	552	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	553	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	554	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	555	void CCaSqlQuery::BindValuesForGetIconL( const CCaInnerEntry* aEntry )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	556	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	557	if( iQuery.Find( KSQLIconId ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	558	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	559	BindIntL(iStatement.ParameterIndex( KSQLIconId ),
66 32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	560	aEntry->Icon()->Id() );
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	561	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	562	if( iQuery.Find( KSQLIcFileName ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	563	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	564	BindTextL( iStatement.ParameterIndex( KSQLIcFileName ),
66 32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	565	aEntry->Icon()->FileName() );
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	566	}
61 8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	567	if( iQuery.Find( KSQLIcSkinId ) != KErrNotFound )
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	568	{
61 8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	569	BindTextL( iStatement.ParameterIndex( KSQLIcSkinId ),
66 32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	570	aEntry->Icon()->SkinId() );
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	571	}
61 8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	572	if( iQuery.Find( KSQLIcAppId ) != KErrNotFound )
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	573	{
61 8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	574	BindTextL( iStatement.ParameterIndex( KSQLIcAppId ),
66 32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	575	aEntry->Icon()->ApplicationId() );
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	576	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	577	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	578
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	579	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	580	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	581	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	582	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	583	void CCaSqlQuery::BindEntryIdsL(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	584	const RPointerArray<CCaInnerEntry>& aEntryArray )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	585	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	586	RArray<TInt> entryIdArray;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	587	CleanupClosePushL( entryIdArray );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	588
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	589	for( TInt i = 0; i < aEntryArray.Count(); i++ )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	590	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	591	entryIdArray.AppendL( aEntryArray[i]->GetId() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	592	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	593	BindIdsL( entryIdArray, KSQLEntryId );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	594	CleanupStack::PopAndDestroy( &entryIdArray );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	595	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	596
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	597	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	598	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	599	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	600	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	601	void CCaSqlQuery::BindIdsL( const RArray<TInt>& aEntryIdArray,
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	602	const TDesC& aColName )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	603	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	604	RBuf bindKey;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	605	bindKey.CleanupClosePushL();
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	606	bindKey.CreateL( aColName.Length() + KMaxIntNumLength );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	607	for( TInt i = 0; i < aEntryIdArray.Count() ; i++ )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	608	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	609	bindKey.Copy( KNullDesC );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	610	bindKey.Append( aColName );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	611	bindKey.AppendNum( i );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	612	if( iQuery.Find( bindKey ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	613	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	614	BindIntL( iStatement.ParameterIndex( bindKey ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	615	aEntryIdArray[i] );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	616	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	617	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	618	CleanupStack::PopAndDestroy( &bindKey );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	619	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	620
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	621	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	622	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	623	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	624	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	625	void CCaSqlQuery::BindEntryIdL( const TInt& aEntryId )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	626	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	627	if( iQuery.Find( KSQLEntryId ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	628	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	629	BindIntL( iStatement.ParameterIndex( KSQLEntryId ), aEntryId );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	630	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	631	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	632
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	633	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	634	// CCaSqlQuery::BindValuesForRemoveFromLocalizationL( const TInt aEntryId )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	635	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	636	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	637	void CCaSqlQuery::BindValuesForRemoveFromLocalizationL( const TInt aEntryId )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	638	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	639	if( iQuery.Find( KSQLLocRowId ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	640	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	641	BindIntL( iStatement.ParameterIndex( KSQLLocRowId ), aEntryId );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	642	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	643	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	644
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	645	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	646	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	647	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	648	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	649	TInt CCaSqlQuery::ExecuteL()
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	650	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	651	User::LeaveIfError( iStatement.Exec() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	652	TSqlScalarFullSelectQuery id_query( iSqlDb );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	653	return id_query.SelectIntL( KSQLGetLastInsertId );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	654	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	655
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	656	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	657	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	658	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	659	//
80 397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	660	TBool CCaSqlQuery::ExecuteEntryPresentL( )
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	661	{
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	662	if( iStatement.Next() == KSqlAtRow )
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	663	{
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	664	return ETrue;
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	665	}
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	666	return EFalse;
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	667	}
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	668
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	669	// ---------------------------------------------------------------------------
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	670	//
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	671	// ---------------------------------------------------------------------------
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	672	//
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	673	TInt CCaSqlQuery::ExecuteL( TInt& aId )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	674	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	675	if( iStatement.Next() == KSqlAtRow )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	676	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	677	aId = iStatement.ColumnInt( ColumnIndexL( iStatement,
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	678	KColumnSingleData ) );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	679	return 1;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	680	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	681	return 0;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	682	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	683
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	684	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	685	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	686	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	687	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	688	TInt CCaSqlQuery::ExecuteL( TInt64& aId )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	689	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	690	if( iStatement.Next() == KSqlAtRow )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	691	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	692	aId = iStatement.ColumnInt64(ColumnIndexL( iStatement,
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	693	KColumnSingleData ) );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	694	return 1;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	695	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	696	return 0;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	697	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	698
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	699	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	700	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	701	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	702	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	703	TInt CCaSqlQuery::ExecuteL( RPointerArray<CCaInnerEntry>& result,
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	704	TQueryResultType aResultType )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	705	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	706	TInt rowCount( 0 );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	707	if( aResultType==CCaSqlQuery::EEntry )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	708	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	709	rowCount = ExecuteEntryL( result );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	710	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	711	else // aResultType==CCaSqlQuery::EAttribute
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	712	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	713	rowCount = ExecuteAttributeL( result );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	714	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	715	return rowCount;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	716	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	717
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	718	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	719	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	720	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	721	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	722	TInt CCaSqlQuery::ExecuteEntryL(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	723	RPointerArray<CCaInnerEntry>& aResultInput )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	724	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	725	TInt rowCount(0);
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	726	while( iStatement.Next() == KSqlAtRow )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	727	{
61 8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	728	TInt entryId = iStatement.ColumnInt(
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	729	ColumnIndexL( iStatement, KColumnEntryId ) );
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	730	TInt role = iStatement.ColumnInt(
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	731	ColumnIndexL( iStatement, KColumnEnRole ) );
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	732	TInt32 uid = iStatement.ColumnInt(
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	733	ColumnIndexL( iStatement, KColumnEnUid ) );
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	734	TUint flags = iStatement.ColumnInt(
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	735	ColumnIndexL( iStatement, KColumnEnFlags ) );
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	736	TInt idIcon = iStatement.ColumnInt(
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	737	ColumnIndexL( iStatement, KColumnEnIdIcon ) );
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	738
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	739	TPtrC text;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	740	User::LeaveIfError( iStatement. ColumnText( ColumnIndexL(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	741	iStatement, KColumnEnText ), text ) );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	742	TPtrC description;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	743	User::LeaveIfError( iStatement.
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	744	ColumnText( ColumnIndexL( iStatement, KColumnEnDescription ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	745	description) );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	746	TPtrC typeName;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	747	User::LeaveIfError( iStatement.ColumnText(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	748	ColumnIndexL(iStatement, KColumnEnTypeName ), typeName) );
61 8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	749
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	750	TPtrC iconFilename;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	751	User::LeaveIfError( iStatement.ColumnText( ColumnIndexL(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	752	iStatement, KColumnIcFileName ), iconFilename ) );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	753
61 8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	754	TPtrC iconSkinId;
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	755	User::LeaveIfError( iStatement.ColumnText( ColumnIndexL(
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	756	iStatement, KColumnIcSkinId ), iconSkinId ) );
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	757
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	758	TPtrC iconApplicationId;
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	759	User::LeaveIfError( iStatement.ColumnText( ColumnIndexL(
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	760	iStatement, KColumnIcAppId ), iconApplicationId ) );
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	761
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	762	CCaInnerEntry* result = CCaInnerEntry::NewLC();
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	763	result->SetId( entryId );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	764	result->SetRole( role );
61 8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	765	result->SetIconDataL(
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	766	iconFilename, iconSkinId, iconApplicationId );
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	767	result->SetIconId( idIcon );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	768	result->SetFlags( flags );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	769	result->SetUid( uid );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	770	result->SetTextL( text );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	771	result->SetDescriptionL( description );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	772	result->SetEntryTypeNameL( typeName );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	773
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	774	aResultInput.AppendL( result );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	775	CleanupStack::Pop( result );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	776	rowCount++;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	777	}//while
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	778
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	779	return rowCount;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	780	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	781
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	782	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	783	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	784	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	785	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	786	TInt CCaSqlQuery::ExecuteLocalizationsL(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	787	RPointerArray<CCaLocalizationEntry>& aResultInput )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	788	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	789	TInt rowCount(0);
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	790	while( iStatement.Next() == KSqlAtRow )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	791	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	792	TInt locTextId = iStatement.ColumnInt(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	793	ColumnIndexL( iStatement, KColumnLocTextId )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	794	);
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	795
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	796	TInt rowId = iStatement.ColumnInt(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	797	ColumnIndexL( iStatement, KColumnLocRowId )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	798	);
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	799
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	800	TPtrC tableName;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	801	User::LeaveIfError(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	802	iStatement.ColumnText(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	803	ColumnIndexL( iStatement, KColumnLocTableName ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	804	tableName )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	805	);
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	806
80 397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	807	TPtrC qmFilename;
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	808	User::LeaveIfError(
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	809	iStatement.ColumnText(
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	810	ColumnIndexL( iStatement, KColumnQmFile ),
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	811	qmFilename )
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	812	);
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	813
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	814	TPtrC attribute;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	815	User::LeaveIfError(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	816	iStatement.ColumnText(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	817	ColumnIndexL( iStatement, KColumnLocAttrName ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	818	attribute )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	819	);
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	820
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	821	TPtrC stringId;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	822	User::LeaveIfError(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	823	iStatement.ColumnText(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	824	ColumnIndexL( iStatement, KColumnLocStringId ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	825	stringId )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	826	);
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	827
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	828	CCaLocalizationEntry* result = CCaLocalizationEntry::NewLC( );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	829	result->SetTextId( locTextId );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	830	result->SetAttributeNameL( attribute );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	831	result->SetStringIdL( stringId );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	832	result->SetRowId( rowId );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	833	result->SetTableNameL( tableName );
80 397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	834	result->SetQmFilenameL( qmFilename );
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	835
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	836	aResultInput.AppendL( result );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	837	CleanupStack::Pop( result );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	838	rowCount++;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	839	}//while
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	840
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	841	return rowCount;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	842	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	843
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	844	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	845	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	846	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	847	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	848	TInt CCaSqlQuery::ExecutePropertyL( TDes& aPropertyValue )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	849	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	850	TInt rowCount(0);
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	851	while( iStatement.Next() == KSqlAtRow )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	852	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	853	TPtrC propertyValue;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	854	User::LeaveIfError( iStatement. ColumnText(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	855	ColumnIndexL( iStatement, KColumnDbValue ), propertyValue ) );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	856
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	857	aPropertyValue.Copy( propertyValue );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	858
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	859	rowCount++;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	860	}//while
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	861
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	862	return rowCount;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	863	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	864
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	865	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	866	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	867	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	868	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	869	TInt CCaSqlQuery::ExecuteAttributeL(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	870	RPointerArray<CCaInnerEntry>& aEntryArray )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	871	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	872	TInt rowCount( 0 );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	873	while( iStatement.Next() == KSqlAtRow )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	874	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	875	TInt idEntry = iStatement.ColumnInt(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	876	ColumnIndexL( iStatement, KColumnAttrEntryID ) );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	877	TPtrC name;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	878	User::LeaveIfError(iStatement.ColumnText(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	879	ColumnIndexL( iStatement, KColumnAttrName), name ) );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	880	TPtrC value;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	881	User::LeaveIfError(iStatement.ColumnText(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	882	ColumnIndexL( iStatement, KColumnAttrValue), value ) );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	883	for( TInt i = 0; i < aEntryArray.Count(); i++ )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	884	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	885	if( idEntry == aEntryArray[i]->GetId() )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	886	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	887	aEntryArray[i]->AddAttributeL( name, value );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	888	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	889	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	890	rowCount++;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	891	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	892	return rowCount;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	893	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	894
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	895	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	896	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	897	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	898	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	899	TInt CCaSqlQuery::ExecuteL( RArray<TInt>& aResultIdArray,
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	900	TTableType aType )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	901	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	902	TInt rowCount( 0 );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	903	TPtrC columnId;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	904	if( aType == CCaSqlQuery::EEntryTable )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	905	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	906	columnId.Set( KColumnEntryId );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	907	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	908	else // aType==CCaSqlQuery::EGroupTable
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	909	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	910	columnId.Set( KColumnGEIdGroup );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	911	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	912	while( iStatement.Next() == KSqlAtRow )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	913	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	914	aResultIdArray.AppendL( iStatement.ColumnInt( ColumnIndexL(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	915	iStatement, columnId ) ) );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	916	rowCount++;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	917	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	918	return rowCount;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	919	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	920
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	921	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	922	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	923	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	924	//
66 32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	925	TInt CCaSqlQuery::ExecuteL( CCaInnerIconDescription* aInnerIconDescription )
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	926	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	927	TInt columnCount( 0 );
66 32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	928
32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	929	RBuf description;
32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	930	description.CleanupClosePushL();
32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	931	description.CreateL(KMaxFileName);
32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	932
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	933	while( iStatement.Next() == KSqlAtRow )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	934	{
66 32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	935	aInnerIconDescription->SetId( iStatement.ColumnInt(
32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	936	ColumnIndexL( iStatement, KColumnIconId ) ) );
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	937	User::LeaveIfError(iStatement.ColumnText(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	938	ColumnIndexL( iStatement, KColumnIcFileName),
66 32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	939	description));
32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	940	aInnerIconDescription->SetFileNameL(description);
32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	941
61 8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	942	User::LeaveIfError(iStatement.ColumnText(
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	943	ColumnIndexL( iStatement, KColumnIcSkinId),
66 32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	944	description));
32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	945	aInnerIconDescription->SetSkinIdL(description);
32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	946
61 8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	947	User::LeaveIfError(iStatement.ColumnText(
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	948	ColumnIndexL( iStatement, KColumnIcAppId),
66 32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	949	description));
32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	950	aInnerIconDescription->SetApplicationIdL(description);
32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	951
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	952	columnCount++;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	953	}
66 32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	954	CleanupStack::PopAndDestroy(&description);
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	955	return columnCount;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	956	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	957
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	958	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	959	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	960	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	961	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	962	TInt CCaSqlQuery::ColumnIndexL( RSqlStatement& aStmt,
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	963	const TDesC& aColumnName ) const
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	964	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	965	TInt ret( aStmt.ColumnIndex( aColumnName ) );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	966	User::LeaveIfError( ret );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	967	return ret;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	968	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	969

author	Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
	Mon, 04 Oct 2010 00:38:31 +0300
changeset 124	e36b2f4799c0
parent 104	9b022b1f357c
permissions	-rw-r--r--