KSK
Well Known Member
Hi All,
Question) I have initialized cache with four indexes(as shown below), based on which key (key1, key2, Key3 ...) data in the caches are sequenced?
Thanks in advance.
Syntax:
jdecmIndexF42UI11[0].nKeyID=1;
jdecmIndexF42UI11[0].nNumSegments = 3;
jdecmIndexF42UI11[0].CacheKey[0].nOffset = offsetof(F42UI11, zdctid);
jdecmIndexF42UI11[0].CacheKey[0].nSize = DIM(dsF42UI11.zdctid);
jdecmIndexF42UI11[0].CacheKey[0].idDataType = EVDT_STRING;
jdecmIndexF42UI11[0].CacheKey[1].nOffset = offsetof(F42UI11, zdjobs);
jdecmIndexF42UI11[0].CacheKey[1].nSize = sizeof(dsF42UI11.zdjobs);
jdecmIndexF42UI11[0].CacheKey[1].idDataType = EVDT_MATH_NUMERIC;
jdecmIndexF42UI11[0].CacheKey[2].nOffset = offsetof(F42UI11, zdlnix);
jdecmIndexF42UI11[0].CacheKey[2].nSize = sizeof(dsF42UI11.zdlnix);
jdecmIndexF42UI11[0].CacheKey[2].idDataType = EVDT_MATH_NUMERIC;
jdecmIndexF42UI11[1].nKeyID=2;
jdecmIndexF42UI11[1].nNumSegments = 3;
jdecmIndexF42UI11[1].CacheKey[0].nOffset = offsetof(F42UI11, zdctid);
jdecmIndexF42UI11[1].CacheKey[0].nSize = DIM(dsF42UI11.zdctid);
jdecmIndexF42UI11[1].CacheKey[0].idDataType = EVDT_STRING;
jdecmIndexF42UI11[1].CacheKey[1].nOffset = offsetof(F42UI11, zdjobs);
jdecmIndexF42UI11[1].CacheKey[1].nSize = sizeof(dsF42UI11.zdjobs);
jdecmIndexF42UI11[1].CacheKey[1].idDataType = EVDT_MATH_NUMERIC;
jdecmIndexF42UI11[1].CacheKey[2].nOffset = offsetof(F42UI11, zditm);
jdecmIndexF42UI11[1].CacheKey[2].nSize = sizeof(dsF42UI11.zditm);
jdecmIndexF42UI11[1].CacheKey[2].idDataType = EVDT_MATH_NUMERIC;
jdecmIndexF42UI11[2].nKeyID=3;
jdecmIndexF42UI11[2].nNumSegments = 3;
jdecmIndexF42UI11[2].CacheKey[0].nOffset = offsetof(F42UI11, zdctid);
jdecmIndexF42UI11[2].CacheKey[0].nSize = DIM(dsF42UI11.zdctid);
jdecmIndexF42UI11[2].CacheKey[0].idDataType = EVDT_STRING;
jdecmIndexF42UI11[2].CacheKey[1].nOffset = offsetof(F42UI11, zdjobs);
jdecmIndexF42UI11[2].CacheKey[1].nSize = sizeof(dsF42UI11.zdjobs);
jdecmIndexF42UI11[2].CacheKey[1].idDataType = EVDT_MATH_NUMERIC;
jdecmIndexF42UI11[2].CacheKey[2].nOffset = offsetof(F42UI11, zdslne);
jdecmIndexF42UI11[2].CacheKey[2].nSize = sizeof(dsF42UI11.zdslne);
jdecmIndexF42UI11[2].CacheKey[2].idDataType = EVDT_MATH_NUMERIC;
jdecmIndexF42UI11[3].nKeyID=4;
jdecmIndexF42UI11[3].nNumSegments = 4;
jdecmIndexF42UI11[3].CacheKey[0].nOffset = offsetof(F42UI11, zdctid);
jdecmIndexF42UI11[3].CacheKey[0].nSize = DIM(dsF42UI11.zdctid);
jdecmIndexF42UI11[3].CacheKey[0].idDataType = EVDT_STRING;
jdecmIndexF42UI11[3].CacheKey[1].nOffset = offsetof(F42UI11, zdjobs);
jdecmIndexF42UI11[3].CacheKey[1].nSize = sizeof(dsF42UI11.zdjobs);
jdecmIndexF42UI11[3].CacheKey[1].idDataType = EVDT_MATH_NUMERIC;
jdecmIndexF42UI11[3].CacheKey[2].nOffset = offsetof(F42UI11, zdmcln);
jdecmIndexF42UI11[3].CacheKey[2].nSize = sizeof(dsF42UI11.zdmcln);
jdecmIndexF42UI11[3].CacheKey[2].idDataType = EVDT_MATH_NUMERIC;
jdecmIndexF42UI11[3].CacheKey[3].nOffset = offsetof(F42UI11, zdlnid);
jdecmIndexF42UI11[3].CacheKey[3].nSize = sizeof(dsF42UI11.zdlnid);
jdecmIndexF42UI11[3].CacheKey[3].idDataType = EVDT_MATH_NUMERIC;
idJDECMReturn = jdeCacheInitMultipleIndex((*lpdsF42UI11DAO)->hUser,&((*lpdsF42UI11DAO)->hCache),
_J("F42UI11"),(JDECMINDEXSTRUCT *)(jdecmIndexF42UI11),4);
Question) I have initialized cache with four indexes(as shown below), based on which key (key1, key2, Key3 ...) data in the caches are sequenced?
Thanks in advance.
Syntax:
jdecmIndexF42UI11[0].nKeyID=1;
jdecmIndexF42UI11[0].nNumSegments = 3;
jdecmIndexF42UI11[0].CacheKey[0].nOffset = offsetof(F42UI11, zdctid);
jdecmIndexF42UI11[0].CacheKey[0].nSize = DIM(dsF42UI11.zdctid);
jdecmIndexF42UI11[0].CacheKey[0].idDataType = EVDT_STRING;
jdecmIndexF42UI11[0].CacheKey[1].nOffset = offsetof(F42UI11, zdjobs);
jdecmIndexF42UI11[0].CacheKey[1].nSize = sizeof(dsF42UI11.zdjobs);
jdecmIndexF42UI11[0].CacheKey[1].idDataType = EVDT_MATH_NUMERIC;
jdecmIndexF42UI11[0].CacheKey[2].nOffset = offsetof(F42UI11, zdlnix);
jdecmIndexF42UI11[0].CacheKey[2].nSize = sizeof(dsF42UI11.zdlnix);
jdecmIndexF42UI11[0].CacheKey[2].idDataType = EVDT_MATH_NUMERIC;
jdecmIndexF42UI11[1].nKeyID=2;
jdecmIndexF42UI11[1].nNumSegments = 3;
jdecmIndexF42UI11[1].CacheKey[0].nOffset = offsetof(F42UI11, zdctid);
jdecmIndexF42UI11[1].CacheKey[0].nSize = DIM(dsF42UI11.zdctid);
jdecmIndexF42UI11[1].CacheKey[0].idDataType = EVDT_STRING;
jdecmIndexF42UI11[1].CacheKey[1].nOffset = offsetof(F42UI11, zdjobs);
jdecmIndexF42UI11[1].CacheKey[1].nSize = sizeof(dsF42UI11.zdjobs);
jdecmIndexF42UI11[1].CacheKey[1].idDataType = EVDT_MATH_NUMERIC;
jdecmIndexF42UI11[1].CacheKey[2].nOffset = offsetof(F42UI11, zditm);
jdecmIndexF42UI11[1].CacheKey[2].nSize = sizeof(dsF42UI11.zditm);
jdecmIndexF42UI11[1].CacheKey[2].idDataType = EVDT_MATH_NUMERIC;
jdecmIndexF42UI11[2].nKeyID=3;
jdecmIndexF42UI11[2].nNumSegments = 3;
jdecmIndexF42UI11[2].CacheKey[0].nOffset = offsetof(F42UI11, zdctid);
jdecmIndexF42UI11[2].CacheKey[0].nSize = DIM(dsF42UI11.zdctid);
jdecmIndexF42UI11[2].CacheKey[0].idDataType = EVDT_STRING;
jdecmIndexF42UI11[2].CacheKey[1].nOffset = offsetof(F42UI11, zdjobs);
jdecmIndexF42UI11[2].CacheKey[1].nSize = sizeof(dsF42UI11.zdjobs);
jdecmIndexF42UI11[2].CacheKey[1].idDataType = EVDT_MATH_NUMERIC;
jdecmIndexF42UI11[2].CacheKey[2].nOffset = offsetof(F42UI11, zdslne);
jdecmIndexF42UI11[2].CacheKey[2].nSize = sizeof(dsF42UI11.zdslne);
jdecmIndexF42UI11[2].CacheKey[2].idDataType = EVDT_MATH_NUMERIC;
jdecmIndexF42UI11[3].nKeyID=4;
jdecmIndexF42UI11[3].nNumSegments = 4;
jdecmIndexF42UI11[3].CacheKey[0].nOffset = offsetof(F42UI11, zdctid);
jdecmIndexF42UI11[3].CacheKey[0].nSize = DIM(dsF42UI11.zdctid);
jdecmIndexF42UI11[3].CacheKey[0].idDataType = EVDT_STRING;
jdecmIndexF42UI11[3].CacheKey[1].nOffset = offsetof(F42UI11, zdjobs);
jdecmIndexF42UI11[3].CacheKey[1].nSize = sizeof(dsF42UI11.zdjobs);
jdecmIndexF42UI11[3].CacheKey[1].idDataType = EVDT_MATH_NUMERIC;
jdecmIndexF42UI11[3].CacheKey[2].nOffset = offsetof(F42UI11, zdmcln);
jdecmIndexF42UI11[3].CacheKey[2].nSize = sizeof(dsF42UI11.zdmcln);
jdecmIndexF42UI11[3].CacheKey[2].idDataType = EVDT_MATH_NUMERIC;
jdecmIndexF42UI11[3].CacheKey[3].nOffset = offsetof(F42UI11, zdlnid);
jdecmIndexF42UI11[3].CacheKey[3].nSize = sizeof(dsF42UI11.zdlnid);
jdecmIndexF42UI11[3].CacheKey[3].idDataType = EVDT_MATH_NUMERIC;
idJDECMReturn = jdeCacheInitMultipleIndex((*lpdsF42UI11DAO)->hUser,&((*lpdsF42UI11DAO)->hCache),
_J("F42UI11"),(JDECMINDEXSTRUCT *)(jdecmIndexF42UI11),4);