TWMurph
May 25th, 1999, 09:47 PM
I am maintaining a piece of code that was written using the DAO SDK. Since I have been told I can't re-write it I have to deal with what is there. I ran into problems using the FindFirst method and am having trouble setting up Seek method of the CdbRecordset. None of the examples I have found use more than one key element or any type other than strings. Here is my set up:
m_pData->m_RS.SetIndex("PrimaryKey");
m_pData->m_RS.Seek("=", 4, strName, dChkAmt, oleDate, strChkNbr);
When I check NoMatch it always comes back true even though I am sure the key is a duplicate.
I have also tried casting the parameters as COleVariants with no success. Any help would be appreciated.
m_pData->m_RS.SetIndex("PrimaryKey");
m_pData->m_RS.Seek("=", 4, strName, dChkAmt, oleDate, strChkNbr);
When I check NoMatch it always comes back true even though I am sure the key is a duplicate.
I have also tried casting the parameters as COleVariants with no success. Any help would be appreciated.