Problem in using Composite index in Seek method on OLEDB/SQL CE
Mobile
1
Posts
1
Posters
0
Views
1
Watching
-
HI, I use the OLEDB method to seek the record: ... TableID.eKind = DBKIND_NAME; TableID.uName.pwszName = (WCHAR*)TABLE_TBL1; IndexID.eKind = DBKIND_NAME; IndexID.uName.pwszName = L"idx_Key"; ... // Set the Fld1 and Fld2 data to the pData // ... // Seek for the first row where the value of the selected column // is dwEmployeeID. hr = pIRowsetIndex->Seek(hAccessor, 1, pData, DBSEEK_FIRSTEQ); if(FAILED(hr)) { goto Exit; } However the Seek function does not working properly. .... From the calling palce the client will pass like index, value1, value 2 and value3...based on it i need to seek and get the data. Anyone know how to seek using composite index? Thanks AKS