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

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

author	Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
	Tue, 31 Aug 2010 15:30:51 +0300
branch	RCL_3
changeset 113	0efa10d348c0
permissions	-rw-r--r--