FCL/sf/mw/homescreensrv: contentstorage/castorage/src/casqlquery.cpp@c63ee96dbe5f (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	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	317	User::LeaveIfError( iStatement.BindText( aParameterIndex,
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	318	aParameterValue ) );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	319	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	320
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	321	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	322	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	323	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	324	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	325	void CCaSqlQuery::BindIntL( TInt aParameterIndex,
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	326	TInt aParameterValue )
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	User::LeaveIfError( aParameterIndex );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	329	User::LeaveIfError( iStatement.BindInt( aParameterIndex,
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	330	aParameterValue ) );
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
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	333	// ---------------------------------------------------------------------------
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	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	336	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	337	void CCaSqlQuery::BindInt64L( TInt aParameterIndex,
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	338	TInt64 aParameterValue )
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	User::LeaveIfError( aParameterIndex );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	341	User::LeaveIfError( iStatement.BindInt64( aParameterIndex,
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	342	aParameterValue ) );
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
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	345	// ---------------------------------------------------------------------------
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	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	348	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	349	void CCaSqlQuery::SetQueryL( const TDesC& aQuery )
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	iQuery.Close();
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	352	iQuery.CreateL( aQuery );
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	// ---------------------------------------------------------------------------
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	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	359	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	360	void CCaSqlQuery::BindValuesForLocalizeL( CCaLocalizationEntry& aLocalization )
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	if( iQuery.Find( KSQLLocRowId ) != KErrNotFound )
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	BindIntL( iStatement.ParameterIndex(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	365	KSQLLocRowId ), aLocalization.GetRowId() );
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	if( iQuery.Find( KSQLLocTable ) != KErrNotFound )
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	BindTextL(iStatement.ParameterIndex( KSQLLocTable ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	370	aLocalization.GetTableName() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	371	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	372	if( iQuery.Find( KSQLLocAttribute ) != KErrNotFound )
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	BindTextL(iStatement.ParameterIndex( KSQLLocAttribute ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	375	aLocalization.GetAttributeName() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	376	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	377	if( iQuery.Find( KSQLLocString ) != KErrNotFound )
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	BindTextL(iStatement.ParameterIndex( KSQLLocString ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	380	aLocalization.GetLocalizedString() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	381	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	382	}
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	// ---------------------------------------------------------------------------
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	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	387	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	388	void CCaSqlQuery::BindValuesForPropertyL( const TDesC& aProperty )
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	if( iQuery.Find( KSQLDbProperty ) != KErrNotFound )
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	BindTextL( iStatement.ParameterIndex(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	393	KSQLDbProperty ), aProperty );
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	}
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	// ---------------------------------------------------------------------------
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	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	400	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	401	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	402	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	403	BindValuesForPropertyL( aProperty );
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	if( iQuery.Find( KSQLDbValue ) != KErrNotFound )
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	BindTextL( iStatement.ParameterIndex(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	408	KSQLDbValue ), 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	}
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	// ---------------------------------------------------------------------------
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	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	415	//
80 397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	416	void CCaSqlQuery::BindValuesForGetLocalizationEntryL(
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	417	const CCaLocalizationEntry& aLocalization)
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	418	{
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	419	BindIntL( iStatement.ParameterIndex( KSQLLocRowId ),
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	420	aLocalization.GetRowId() );
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	421	BindTextL( iStatement.ParameterIndex( KSQLLocTable ),
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	422	aLocalization.GetTableName() );
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	423	BindTextL( iStatement.ParameterIndex( KSQLLocAttribute ),
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	424	aLocalization.GetAttributeName() );
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
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	427	// ---------------------------------------------------------------------------
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	428	//
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	429	// ---------------------------------------------------------------------------
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	430	//
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	431	void CCaSqlQuery::BindValuesForLocalizationEntryL(
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	432	const CCaLocalizationEntry& aLocalization)
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	BindIntL( iStatement.ParameterIndex( KSQLLocRowId ),
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	435	aLocalization.GetRowId() );
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	436	BindTextL( iStatement.ParameterIndex( KSQLLocTable ),
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	437	aLocalization.GetTableName() );
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	438	BindTextL( iStatement.ParameterIndex( KSQLLocAttribute ),
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	439	aLocalization.GetAttributeName() );
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	440	BindTextL( iStatement.ParameterIndex( KSQLLocQmFilename ),
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	441	aLocalization.GetQmFilename() );
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	442	BindTextL( iStatement.ParameterIndex( KSQLLocString ),
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	443	aLocalization.GetStringId() );
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	444	}
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	445
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	446
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	447	// ---------------------------------------------------------------------------
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	448	//
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	449	// ---------------------------------------------------------------------------
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	450	//
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	451	void CCaSqlQuery::BindValuesForGetEntriesL( const CCaInnerQuery* aQuery )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	452	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	453	if( aQuery->GetIds().Count() > 0 )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	454	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	455	BindIdsL( aQuery->GetIds(), KSQLEntryId );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	456	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	457	else
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	458	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	459	if( aQuery->GetFlagsOn() != 0 && iQuery.Find( KSQLFlagsOn )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	460	!= KErrNotFound )
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	BindIntL( iStatement.ParameterIndex( KSQLFlagsOn ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	463	aQuery->GetFlagsOn() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	464	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	465	if( aQuery->GetFlagsOff() != 0 && iQuery.Find( KSQLFlagsOff )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	466	!= KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	467	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	468	BindIntL( iStatement.ParameterIndex( KSQLFlagsOff ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	469	aQuery->GetFlagsOff() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	470	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	471	if( aQuery->GetRole() != -1 && iQuery.Find( KSQLEnRole )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	472	!= KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	473	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	474	BindIntL( iStatement.ParameterIndex( KSQLEnRole ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	475	aQuery->GetRole() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	476	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	477	if( aQuery->GetParentId() != -1 && iQuery.Find( KSQLGEIdGroup )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	478	!= KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	479	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	480	BindIntL( iStatement.ParameterIndex( KSQLGEIdGroup ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	481	aQuery->GetParentId() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	482	}
104 9b022b1f357c Revision: 201025 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 80 diff changeset	483	if( aQuery->GetChildId() != -1 && iQuery.Find( KSQLGEEntryId )
9b022b1f357c Revision: 201025 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 80 diff changeset	484	!= KErrNotFound )
9b022b1f357c Revision: 201025 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 80 diff changeset	485	{
9b022b1f357c Revision: 201025 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 80 diff changeset	486	BindIntL( iStatement.ParameterIndex( KSQLGEEntryId ),
9b022b1f357c Revision: 201025 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 80 diff changeset	487	aQuery->GetChildId() );
9b022b1f357c Revision: 201025 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 80 diff changeset	488	}
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	489	if( aQuery->GetUid() != 0 && iQuery.Find( KSQLEnUid )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	490	!= KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	491	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	492	BindIntL( iStatement.ParameterIndex( KSQLEnUid ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	493	aQuery->GetUid() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	494	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	495	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	496	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	497
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	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	500	// ---------------------------------------------------------------------------
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	void CCaSqlQuery::BindValuesForGetEntriesL( const CCaInnerEntry* aEntry )
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	if( iQuery.Find( KSQLEntryId ) != KErrNotFound )
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	BindIntL(iStatement.ParameterIndex( KSQLEntryId ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	507	aEntry->GetId() );
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	if( iQuery.Find( KSQLEnText) != KErrNotFound )
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	BindTextL(iStatement.ParameterIndex( KSQLEnText ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	512	aEntry->GetText() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	513	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	514	if( iQuery.Find( KSQLEnDescription ) != KErrNotFound )
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	BindTextL(iStatement.ParameterIndex( KSQLEnDescription ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	517	aEntry->GetDescription() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	518	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	519	if( iQuery.Find( KSQLEnRole ) != KErrNotFound )
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	BindIntL( iStatement.ParameterIndex( KSQLEnRole ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	522	aEntry->GetRole() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	523	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	524	if( iQuery.Find( KSQLEnTypeName ) != KErrNotFound )
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	BindTextL( iStatement.ParameterIndex( KSQLEnTypeName ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	527	aEntry->GetEntryTypeName() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	528	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	529	if( iQuery.Find( KSQLEnIdIcon ) != KErrNotFound )
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	BindIntL( iStatement.ParameterIndex( KSQLEnIdIcon ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	532	aEntry->GetIconId() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	533	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	534	if( iQuery.Find( KSQLEnUid ) != KErrNotFound )
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	BindIntL( iStatement.ParameterIndex(KSQLEnUid), aEntry->GetUid() );
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	if( iQuery.Find( KSQLEnFlags ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	539	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	540	BindIntL( iStatement.ParameterIndex( KSQLEnFlags ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	541	aEntry->GetFlags() );
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	}
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	//
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	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	548	void CCaSqlQuery::BindValuesForGetIconL( const CCaInnerEntry* aEntry )
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	if( iQuery.Find( KSQLIconId ) != KErrNotFound )
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	BindIntL(iStatement.ParameterIndex( KSQLIconId ),
66 32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	553	aEntry->Icon()->Id() );
60 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	if( iQuery.Find( KSQLIcFileName ) != KErrNotFound )
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	BindTextL( iStatement.ParameterIndex( KSQLIcFileName ),
66 32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	558	aEntry->Icon()->FileName() );
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	559	}
61 8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	560	if( iQuery.Find( KSQLIcSkinId ) != KErrNotFound )
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	561	{
61 8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	562	BindTextL( iStatement.ParameterIndex( KSQLIcSkinId ),
66 32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	563	aEntry->Icon()->SkinId() );
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	564	}
61 8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	565	if( iQuery.Find( KSQLIcAppId ) != KErrNotFound )
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	BindTextL( iStatement.ParameterIndex( KSQLIcAppId ),
66 32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	568	aEntry->Icon()->ApplicationId() );
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	569	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	570	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	571
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	572	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	573	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	574	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	575	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	576	void CCaSqlQuery::BindEntryIdsL(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	577	const RPointerArray<CCaInnerEntry>& aEntryArray )
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	RArray<TInt> entryIdArray;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	580	CleanupClosePushL( entryIdArray );
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	for( TInt i = 0; i < aEntryArray.Count(); i++ )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	583	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	584	entryIdArray.AppendL( aEntryArray[i]->GetId() );
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	BindIdsL( entryIdArray, KSQLEntryId );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	587	CleanupStack::PopAndDestroy( &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
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	//
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	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	594	void CCaSqlQuery::BindIdsL( const RArray<TInt>& aEntryIdArray,
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	595	const TDesC& aColName )
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	RBuf bindKey;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	598	bindKey.CleanupClosePushL();
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	599	bindKey.CreateL( aColName.Length() + KMaxIntNumLength );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	600	for( TInt i = 0; i < aEntryIdArray.Count() ; i++ )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	601	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	602	bindKey.Copy( KNullDesC );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	603	bindKey.Append( aColName );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	604	bindKey.AppendNum( i );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	605	if( iQuery.Find( bindKey ) != KErrNotFound )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	606	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	607	BindIntL( iStatement.ParameterIndex( bindKey ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	608	aEntryIdArray[i] );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	609	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	610	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	611	CleanupStack::PopAndDestroy( &bindKey );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	612	}
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	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	615	//
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	void CCaSqlQuery::BindEntryIdL( const TInt& aEntryId )
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	if( iQuery.Find( KSQLEntryId ) != KErrNotFound )
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	BindIntL( iStatement.ParameterIndex( KSQLEntryId ), aEntryId );
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
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	// CCaSqlQuery::BindValuesForRemoveFromLocalizationL( const TInt aEntryId )
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	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	630	void CCaSqlQuery::BindValuesForRemoveFromLocalizationL( const TInt aEntryId )
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	if( iQuery.Find( KSQLLocRowId ) != KErrNotFound )
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	BindIntL( iStatement.ParameterIndex( KSQLLocRowId ), 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
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	//
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	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	642	TInt CCaSqlQuery::ExecuteL()
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	User::LeaveIfError( iStatement.Exec() );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	645	TSqlScalarFullSelectQuery id_query( iSqlDb );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	646	return id_query.SelectIntL( KSQLGetLastInsertId );
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	// ---------------------------------------------------------------------------
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	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	652	//
80 397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	653	TBool CCaSqlQuery::ExecuteEntryPresentL( )
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	654	{
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	655	if( iStatement.Next() == KSqlAtRow )
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	656	{
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	657	return ETrue;
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	658	}
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	659	return EFalse;
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	660	}
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	// ---------------------------------------------------------------------------
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	// ---------------------------------------------------------------------------
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	665	//
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	666	TInt CCaSqlQuery::ExecuteL( TInt& aId )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	667	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	668	if( iStatement.Next() == KSqlAtRow )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	669	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	670	aId = iStatement.ColumnInt( ColumnIndexL( iStatement,
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	671	KColumnSingleData ) );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	672	return 1;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	673	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	674	return 0;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	675	}
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	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	678	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	679	// ---------------------------------------------------------------------------
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	TInt CCaSqlQuery::ExecuteL( TInt64& aId )
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	if( iStatement.Next() == KSqlAtRow )
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	aId = iStatement.ColumnInt64(ColumnIndexL( iStatement,
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	686	KColumnSingleData ) );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	687	return 1;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	688	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	689	return 0;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	690	}
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	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	693	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	694	// ---------------------------------------------------------------------------
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	TInt CCaSqlQuery::ExecuteL( RPointerArray<CCaInnerEntry>& result,
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	697	TQueryResultType aResultType )
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	TInt rowCount( 0 );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	700	if( aResultType==CCaSqlQuery::EEntry )
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	rowCount = ExecuteEntryL( result );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	703	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	704	else // aResultType==CCaSqlQuery::EAttribute
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	rowCount = ExecuteAttributeL( result );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	707	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	708	return rowCount;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	709	}
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	// ---------------------------------------------------------------------------
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	// ---------------------------------------------------------------------------
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	TInt CCaSqlQuery::ExecuteEntryL(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	716	RPointerArray<CCaInnerEntry>& aResultInput )
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	TInt rowCount(0);
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	719	while( iStatement.Next() == KSqlAtRow )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	720	{
61 8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	721	TInt entryId = iStatement.ColumnInt(
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	722	ColumnIndexL( iStatement, KColumnEntryId ) );
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	723	TInt role = iStatement.ColumnInt(
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	724	ColumnIndexL( iStatement, KColumnEnRole ) );
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	725	TInt32 uid = iStatement.ColumnInt(
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	726	ColumnIndexL( iStatement, KColumnEnUid ) );
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	727	TUint flags = iStatement.ColumnInt(
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	728	ColumnIndexL( iStatement, KColumnEnFlags ) );
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	729	TInt idIcon = iStatement.ColumnInt(
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	730	ColumnIndexL( iStatement, KColumnEnIdIcon ) );
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	731
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	732	TPtrC text;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	733	User::LeaveIfError( iStatement. ColumnText( ColumnIndexL(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	734	iStatement, KColumnEnText ), text ) );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	735	TPtrC description;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	736	User::LeaveIfError( iStatement.
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	737	ColumnText( ColumnIndexL( iStatement, KColumnEnDescription ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	738	description) );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	739	TPtrC typeName;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	740	User::LeaveIfError( iStatement.ColumnText(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	741	ColumnIndexL(iStatement, KColumnEnTypeName ), typeName) );
61 8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	742
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	743	TPtrC iconFilename;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	744	User::LeaveIfError( iStatement.ColumnText( ColumnIndexL(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	745	iStatement, KColumnIcFileName ), iconFilename ) );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	746
61 8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	747	TPtrC iconSkinId;
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	748	User::LeaveIfError( iStatement.ColumnText( ColumnIndexL(
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	749	iStatement, KColumnIcSkinId ), iconSkinId ) );
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	750
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	751	TPtrC iconApplicationId;
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	752	User::LeaveIfError( iStatement.ColumnText( ColumnIndexL(
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	753	iStatement, KColumnIcAppId ), iconApplicationId ) );
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	754
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	755	CCaInnerEntry* result = CCaInnerEntry::NewLC();
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	756	result->SetId( entryId );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	757	result->SetRole( role );
61 8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	758	result->SetIconDataL(
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	759	iconFilename, iconSkinId, iconApplicationId );
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	760	result->SetIconId( idIcon );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	761	result->SetFlags( flags );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	762	result->SetUid( uid );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	763	result->SetTextL( text );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	764	result->SetDescriptionL( description );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	765	result->SetEntryTypeNameL( typeName );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	766
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	767	aResultInput.AppendL( result );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	768	CleanupStack::Pop( result );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	769	rowCount++;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	770	}//while
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	771
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	772	return rowCount;
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
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	775	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	776	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	777	// ---------------------------------------------------------------------------
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	TInt CCaSqlQuery::ExecuteLocalizationsL(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	780	RPointerArray<CCaLocalizationEntry>& aResultInput )
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	TInt rowCount(0);
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	783	while( iStatement.Next() == KSqlAtRow )
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	TInt locTextId = iStatement.ColumnInt(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	786	ColumnIndexL( iStatement, KColumnLocTextId )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	787	);
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 rowId = iStatement.ColumnInt(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	790	ColumnIndexL( iStatement, KColumnLocRowId )
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
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	793	TPtrC tableName;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	794	User::LeaveIfError(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	795	iStatement.ColumnText(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	796	ColumnIndexL( iStatement, KColumnLocTableName ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	797	tableName )
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
80 397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	800	TPtrC qmFilename;
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	801	User::LeaveIfError(
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	802	iStatement.ColumnText(
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	803	ColumnIndexL( iStatement, KColumnQmFile ),
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	804	qmFilename )
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	805	);
397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	806
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	807	TPtrC attribute;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	808	User::LeaveIfError(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	809	iStatement.ColumnText(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	810	ColumnIndexL( iStatement, KColumnLocAttrName ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	811	attribute )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	812	);
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	813
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	814	TPtrC stringId;
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, KColumnLocStringId ),
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	818	stringId )
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	CCaLocalizationEntry* result = CCaLocalizationEntry::NewLC( );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	822	result->SetTextId( locTextId );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	823	result->SetAttributeNameL( attribute );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	824	result->SetStringIdL( stringId );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	825	result->SetRowId( rowId );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	826	result->SetTableNameL( tableName );
80 397d00875918 Revision: 201019 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 66 diff changeset	827	result->SetQmFilenameL( qmFilename );
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	828
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	829	aResultInput.AppendL( result );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	830	CleanupStack::Pop( result );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	831	rowCount++;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	832	}//while
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	833
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	834	return rowCount;
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
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	837	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	838	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	839	// ---------------------------------------------------------------------------
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	TInt CCaSqlQuery::ExecutePropertyL( TDes& aPropertyValue )
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	TInt rowCount(0);
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	844	while( iStatement.Next() == KSqlAtRow )
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	TPtrC propertyValue;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	847	User::LeaveIfError( iStatement. ColumnText(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	848	ColumnIndexL( iStatement, KColumnDbValue ), propertyValue ) );
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	aPropertyValue.Copy( propertyValue );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	851
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	852	rowCount++;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	853	}//while
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	854
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	855	return rowCount;
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
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	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	860	// ---------------------------------------------------------------------------
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	TInt CCaSqlQuery::ExecuteAttributeL(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	863	RPointerArray<CCaInnerEntry>& aEntryArray )
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	TInt rowCount( 0 );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	866	while( iStatement.Next() == KSqlAtRow )
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	TInt idEntry = iStatement.ColumnInt(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	869	ColumnIndexL( iStatement, KColumnAttrEntryID ) );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	870	TPtrC name;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	871	User::LeaveIfError(iStatement.ColumnText(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	872	ColumnIndexL( iStatement, KColumnAttrName), name ) );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	873	TPtrC value;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	874	User::LeaveIfError(iStatement.ColumnText(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	875	ColumnIndexL( iStatement, KColumnAttrValue), value ) );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	876	for( TInt i = 0; i < aEntryArray.Count(); i++ )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	877	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	878	if( idEntry == aEntryArray[i]->GetId() )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	879	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	880	aEntryArray[i]->AddAttributeL( name, value );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	881	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	882	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	883	rowCount++;
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	return rowCount;
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
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	// ---------------------------------------------------------------------------
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	TInt CCaSqlQuery::ExecuteL( RArray<TInt>& aResultIdArray,
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	893	TTableType aType )
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	TInt rowCount( 0 );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	896	TPtrC columnId;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	897	if( aType == CCaSqlQuery::EEntryTable )
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	columnId.Set( KColumnEntryId );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	900	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	901	else // aType==CCaSqlQuery::EGroupTable
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	902	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	903	columnId.Set( KColumnGEIdGroup );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	904	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	905	while( iStatement.Next() == KSqlAtRow )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	906	{
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	907	aResultIdArray.AppendL( iStatement.ColumnInt( ColumnIndexL(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	908	iStatement, columnId ) ) );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	909	rowCount++;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	910	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	911	return rowCount;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	912	}
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	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	915	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	916	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	917	//
66 32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	918	TInt CCaSqlQuery::ExecuteL( CCaInnerIconDescription* aInnerIconDescription )
60 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	TInt columnCount( 0 );
66 32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	921
32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	922	RBuf description;
32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	923	description.CleanupClosePushL();
32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	924	description.CreateL(KMaxFileName);
32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	925
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	926	while( iStatement.Next() == KSqlAtRow )
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	927	{
66 32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	928	aInnerIconDescription->SetId( iStatement.ColumnInt(
32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	929	ColumnIndexL( iStatement, KColumnIconId ) ) );
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	930	User::LeaveIfError(iStatement.ColumnText(
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	931	ColumnIndexL( iStatement, KColumnIcFileName),
66 32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	932	description));
32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	933	aInnerIconDescription->SetFileNameL(description);
32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	934
61 8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	935	User::LeaveIfError(iStatement.ColumnText(
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	936	ColumnIndexL( iStatement, KColumnIcSkinId),
66 32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	937	description));
32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	938	aInnerIconDescription->SetSkinIdL(description);
32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	939
61 8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	940	User::LeaveIfError(iStatement.ColumnText(
8e5041d13c84 Revision: 201011 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 60 diff changeset	941	ColumnIndexL( iStatement, KColumnIcAppId),
66 32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	942	description));
32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	943	aInnerIconDescription->SetApplicationIdL(description);
32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	944
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	945	columnCount++;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	946	}
66 32469d7d46ff Revision: 201015 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 61 diff changeset	947	CleanupStack::PopAndDestroy(&description);
60 f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	948	return columnCount;
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	949	}
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	950
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	951	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	952	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	953	// ---------------------------------------------------------------------------
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	954	//
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	955	TInt CCaSqlQuery::ColumnIndexL( RSqlStatement& aStmt,
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	956	const TDesC& aColumnName ) const
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	TInt ret( aStmt.ColumnIndex( aColumnName ) );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	959	User::LeaveIfError( ret );
f62f87b200ec Revision: 201007 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	960	return ret;
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

author	Jaakko Haukipuro (Nokia-MS/Oulu) <Jaakko.Haukipuro@nokia.com>
	Thu, 16 Sep 2010 12:11:40 +0100
changeset 117	c63ee96dbe5f
parent 104	9b022b1f357c
child 124	e36b2f4799c0
permissions	-rw-r--r--