1 // Copyright (c) 1999-2009 Nokia Corporation and/or its subsidiary(-ies).

     2 // All rights reserved.

     3 // This component and the accompanying materials are made available

     4 // under the terms of "Eclipse Public License v1.0"

     5 // which accompanies this distribution, and is available

     6 // at the URL "http://www.eclipse.org/legal/epl-v10.html".

     7 //

     8 // Initial Contributors:

     9 // Nokia Corporation - initial contribution.

    10 //

    11 // Contributors:

    12 //

    13 // Description:

    14 //

    15 

    16 #ifndef __HLPSQLCONSTS_H__

    17 #define __HLPSQLCONSTS_H__

    18 

    19 #include <e32std.h>

    20 

    21 

    22 _LIT(KSQLTopicIdColumn,					"TopicId");

    23 _LIT(KSQLIndexIdColumn,					"IndexId");

    24 _LIT(KSQLTopicTitleColumn,				"TopicTitle");

    25 _LIT(KSQLTopicTextColumn,				"TopicText");

    26 _LIT(KSQLTopicMarkupColumn,				"TopicMarkup");

    27 _LIT(KSQLCategoryColumn,				"Category");

    28 _LIT(KSQLSynonymColumn,					"Synonym");

    29 _LIT(KSQLIndexColumn,					"Index");

    30 _LIT(KSQLContextColumn,					"Context");

    31 _LIT(KSQLCategoryUidColumn,				"CategoryUID");

    32 _LIT(KSQLImageCountColumn,				"ImageCount");

    33 _LIT(KSQLImage0Column,					"Image0");

    34 _LIT(KSQLImage1Column,					"Image1");

    35 _LIT(KSQLImage2Column,					"Image2");

    36 /**

    37 * This next literal, corresponds to the name of the 

    38 * image column in an old-format help file (2 columns). 

    39 */

    40 _LIT(KSQLImageColumn,					"Image");

    41 

    42 _LIT(KSQLTopicByCategoryUIDProlog,		"SELECT TOPICTITLE, TOPICID, CATEGORYUID FROM TOPIC WHERE CATEGORYUID=");

    43 _LIT(KSQLTopicByCategoryProlog,			"SELECT TOPICTITLE, TOPICID, CATEGORYUID FROM TOPIC WHERE CATEGORY=");

    44 _LIT(KSQLCategoryList,					"SELECT TOPICTITLE, TOPICID, CATEGORYUID FROM TOPIC");

    45 _LIT(KSQLTopicSearchProlog,				"SELECT TOPICTITLE, TOPICID, CATEGORY, TOPICTEXT, TOPICMARKUP FROM TOPIC WHERE ");

    46 _LIT(KSQLTopicIdSearchProlog,			"SELECT TOPICTITLE, TOPICID, CATEGORYUID FROM TOPIC WHERE ");

    47 _LIT(KSQLIndexSearch,					"SELECT INDEXID FROM INDEX WHERE INDEX ='");

    48 _LIT(KSQLIndexIdSearch,					"SELECT TOPICID, CATEGORYUID, TOPICTITLE FROM TOPICINDEX WHERE INDEXID=");

    49 _LIT(KSQLContextSearch,					"SELECT CONTEXT, TOPICID, CATEGORYUID FROM CONTEXT WHERE CONTEXT='");

    50 _LIT(KSQLIndexList,						"SELECT INDEX, INDEXID FROM INDEX");

    51 

    52 _LIT(KSQLTopicOrderBy,					" ORDER BY TOPICTITLE ASC");

    53 

    54 _LIT(KSQLTxtSrchCat,					"*' OR Category LIKE '*");

    55 _LIT(KSQLTxtSrchTopicText,				"*' OR TopicText LIKE '*");

    56 _LIT(KSQLTxtSrchTopicTitle,				"TopicTitle LIKE '*");

    57 _LIT(KSQLTxtSrchSynonym,				"*' OR Synonym LIKE '*");

    58 

    59 _LIT(KSQLSingleInvComma,				"'");

    60 _LIT(KSQLLikeOpeningInvComma,			"'*");

    61 _LIT(KSQLLikeClosingInvComma,			"*'");

    62 

    63 _LIT(KSQLOrOperator,					" OR ");

    64 _LIT(KSQLEqualOperator,					" = ");

    65 _LIT(KSQLLikeOperator,					" LIKE ");

    66 _LIT(KSQLAndOperator,					" AND ");

    67 

    68 

    69 #endif