dbwriter.h File Reference

KTopicTblTopicTitle

const TIntKTopicTblTopicTitle

KTopicTblCategoryTitle

const TIntKTopicTblCategoryTitle

KTopicTblTopicText

const TIntKTopicTblTopicText

KTopicTblTopicMarkup

const TIntKTopicTblTopicMarkup

KTopicTblSynonym

const TIntKTopicTblSynonym

KTopicTblTopicId

const TIntKTopicTblTopicId

KTopicTblCategoryUID

const TIntKTopicTblCategoryUID

KIndexTblIndex

const TIntKIndexTblIndex

KIndexTblIndexId

const TIntKIndexTblIndexId

KTopicIndexTblTopicId

const TIntKTopicIndexTblTopicId

KTopicIndexTblIndexId

const TIntKTopicIndexTblIndexId

KTopicIndexTblCategoryUID

const TIntKTopicIndexTblCategoryUID

KTopicIndexTblTopicTitle

const TIntKTopicIndexTblTopicTitle

KContextTblContext

const TIntKContextTblContext

KContextTblTopicId

const TIntKContextTblTopicId

KImageTblImageId

const TIntKImageTblImageId

KImageTblImageCount

const TIntKImageTblImageCount

KImageTblImage0

const TIntKImageTblImage0

KImageTblImage1

const TIntKImageTblImage1

KImageTblImage2

const TIntKImageTblImage2

_LIT ( KHlpDMLTopicTable, "CREATE TABLE Topic (TopicTitle CHAR(120), Category CHAR(120), TopicText LONG VARCHAR, TopicMarkup LONG VARBINARY, Synonym CHAR(200), TopicId UNSIGNED INTEGER, CategoryUID UNSIGNED INTEGER)" )

_LIT(KHlpDMLTopicTable,
"CREATE TABLE Topic (TopicTitle CHAR(120), Category CHAR(120), TopicText LONG VARCHAR, TopicMarkup LONG VARBINARY, Synonym CHAR(200), TopicId UNSIGNED INTEGER, CategoryUID UNSIGNED INTEGER)"
)

_LIT ( KHlpDMLIndexTable, "CREATE TABLE Index (Index CHAR(120), IndexId UNSIGNED INTEGER)" )

_LIT(KHlpDMLIndexTable,
"CREATE TABLE Index (Index CHAR(120), IndexId UNSIGNED INTEGER)"
)

_LIT ( KHlpDMLTopicIndexTable, "CREATE TABLE TopicIndex (TopicId UNSIGNED INTEGER, IndexId UNSIGNED INTEGER, CategoryUID UNSIGNED INTEGER, TopicTitle CHAR(120))" )

_LIT(KHlpDMLTopicIndexTable,
"CREATE TABLE TopicIndex (TopicId UNSIGNED INTEGER, IndexId UNSIGNED INTEGER, CategoryUID UNSIGNED INTEGER, TopicTitle CHAR(120))"
)

_LIT ( KHlpDMLContextTable, "CREATE TABLE Context (Context CHAR(30), TopicId UNSIGNED INTEGER)" )

_LIT(KHlpDMLContextTable,
"CREATE TABLE Context (Context CHAR(30), TopicId UNSIGNED INTEGER)"
)

_LIT ( KHlpDMLImageTable, "CREATE TABLE Image (ImageId UNSIGNED INTEGER, ImageCount UNSIGNED INTEGER, Image0 LONG VARBINARY, Image1 LONG VARBINARY, Image2 LONG VARBINARY)" )

_LIT(KHlpDMLImageTable,
"CREATE TABLE Image (ImageId UNSIGNED INTEGER, ImageCount UNSIGNED INTEGER, Image0 LONG VARBINARY, Image1 LONG VARBINARY, Image2 LONG VARBINARY)"
)

_LIT ( KHlpDMLTopicTableIdx, "CREATE UNIQUE INDEX TopicIdx ON Topic (TopicId)" )

_LIT(KHlpDMLTopicTableIdx,
"CREATE UNIQUE INDEX TopicIdx ON Topic (TopicId)"
)

_LIT ( KHlpDMLIndexTableIdx, "CREATE UNIQUE INDEX IndexIdx ON Index (IndexId)" )

_LIT(KHlpDMLIndexTableIdx,
"CREATE UNIQUE INDEX IndexIdx ON Index (IndexId)"
)

_LIT ( KHlpDMLTopicIndexTableIdx, "CREATE UNIQUE INDEX TopicIndexIdx ON TopicIndex (IndexId, TopicId)" )

_LIT(KHlpDMLTopicIndexTableIdx,
"CREATE UNIQUE INDEX TopicIndexIdx ON TopicIndex (IndexId, TopicId)"
)

_LIT ( KHlpDMLContextTableIdx, "CREATE UNIQUE INDEX ContextIdx ON Context (Context)" )

_LIT(KHlpDMLContextTableIdx,
"CREATE UNIQUE INDEX ContextIdx ON Context (Context)"
)

_LIT ( KHlpDMLImageTableIdx, "CREATE UNIQUE INDEX ImageIdx ON Image (ImageId)" )

_LIT(KHlpDMLImageTableIdx,
"CREATE UNIQUE INDEX ImageIdx ON Image (ImageId)"
)

_LIT ( KHlpSQLTopicTable, "SELECT * FROM Topic" )

_LIT(KHlpSQLTopicTable,
"SELECT * FROM Topic"
)

_LIT ( KHlpSQLIndexTable, "SELECT * FROM Index" )

_LIT(KHlpSQLIndexTable,
"SELECT * FROM Index"
)

_LIT ( KHlpSQLTopicIndexTable, "SELECT * FROM TopicIndex" )

_LIT(KHlpSQLTopicIndexTable,
"SELECT * FROM TopicIndex"
)

_LIT ( KHlpSQLContextTable, "SELECT * FROM Context" )

_LIT(KHlpSQLContextTable,
"SELECT * FROM Context"
)

_LIT ( KHlpSQLImageTable, "SELECT * FROM Image" )

_LIT(KHlpSQLImageTable,
"SELECT * FROM Image"
)

Enum anonymous

EnumeratorValueDescription
ETopicTable
EIndexTable
ETopicIndexTable
EContextTable
EImageTable
© Nokia 2005.