// Copyright (c) 1999-2009 Nokia Corporation and/or its subsidiary(-ies).// All rights reserved.// This component and the accompanying materials are made available// under the terms of "Eclipse Public License v1.0"// which accompanies this distribution, and is available// at the URL "http://www.eclipse.org/legal/epl-v10.html".//// Initial Contributors:// Nokia Corporation - initial contribution.//// Contributors://// Description://#ifndef __HLPSQLCONSTS_H__#define __HLPSQLCONSTS_H__#include <e32std.h>_LIT(KSQLTopicIdColumn, "TopicId");_LIT(KSQLIndexIdColumn, "IndexId");_LIT(KSQLTopicTitleColumn, "TopicTitle");_LIT(KSQLTopicTextColumn, "TopicText");_LIT(KSQLTopicMarkupColumn, "TopicMarkup");_LIT(KSQLCategoryColumn, "Category");_LIT(KSQLSynonymColumn, "Synonym");_LIT(KSQLIndexColumn, "Index");_LIT(KSQLContextColumn, "Context");_LIT(KSQLCategoryUidColumn, "CategoryUID");_LIT(KSQLImageCountColumn, "ImageCount");_LIT(KSQLImage0Column, "Image0");_LIT(KSQLImage1Column, "Image1");_LIT(KSQLImage2Column, "Image2");/*** This next literal, corresponds to the name of the * image column in an old-format help file (2 columns). */_LIT(KSQLImageColumn, "Image");_LIT(KSQLTopicByCategoryUIDProlog, "SELECT TOPICTITLE, TOPICID, CATEGORYUID FROM TOPIC WHERE CATEGORYUID=");_LIT(KSQLTopicByCategoryProlog, "SELECT TOPICTITLE, TOPICID, CATEGORYUID FROM TOPIC WHERE CATEGORY=");_LIT(KSQLCategoryList, "SELECT TOPICTITLE, TOPICID, CATEGORYUID FROM TOPIC");_LIT(KSQLTopicSearchProlog, "SELECT TOPICTITLE, TOPICID, CATEGORY, TOPICTEXT, TOPICMARKUP FROM TOPIC WHERE ");_LIT(KSQLTopicIdSearchProlog, "SELECT TOPICTITLE, TOPICID, CATEGORYUID FROM TOPIC WHERE ");_LIT(KSQLIndexSearch, "SELECT INDEXID FROM INDEX WHERE INDEX ='");_LIT(KSQLIndexIdSearch, "SELECT TOPICID, CATEGORYUID, TOPICTITLE FROM TOPICINDEX WHERE INDEXID=");_LIT(KSQLContextSearch, "SELECT CONTEXT, TOPICID, CATEGORYUID FROM CONTEXT WHERE CONTEXT='");_LIT(KSQLIndexList, "SELECT INDEX, INDEXID FROM INDEX");_LIT(KSQLTopicOrderBy, " ORDER BY TOPICTITLE ASC");_LIT(KSQLTxtSrchCat, "*' OR Category LIKE '*");_LIT(KSQLTxtSrchTopicText, "*' OR TopicText LIKE '*");_LIT(KSQLTxtSrchTopicTitle, "TopicTitle LIKE '*");_LIT(KSQLTxtSrchSynonym, "*' OR Synonym LIKE '*");_LIT(KSQLSingleInvComma, "'");_LIT(KSQLLikeOpeningInvComma, "'*");_LIT(KSQLLikeClosingInvComma, "*'");_LIT(KSQLOrOperator, " OR ");_LIT(KSQLEqualOperator, " = ");_LIT(KSQLLikeOperator, " LIKE ");_LIT(KSQLAndOperator, " AND ");#endif