Trouble setting value of integer parameter for Insert Statement

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Charles Fineblum

    #1

    Trouble setting value of integer parameter for Insert Statement

    Hi:

    I'm trying to add a parmater of OleDbType SmallInt. It supposed to map to
    int16, so I do the following:

    OleDbParameter* pP2 = new OleDbParameter( S"FK_tblRace s",
    OleDbType::Smal lInt, 0);
    pP2->Value = Int16(5); // 5 is value
    this->oleDbInsertCom mand1->Parameters->Add(pP2);

    It bombs because not object*. How do you get object* of Int16?

    Thanx,
    Charlie


  • Andreas Johansson

    #2
    Re: Trouble setting value of integer parameter for Insert Statement

    > It bombs because not object*. How do you get object* of Int16?

    You box it...

    Int16 nValue = 0;
    Object *pObject = __box(nValue);


    /Andreas


    Comment

    Working...