PRB: DAO SetParamValue Limited to 255 Characters

MORE INFORMATION

Sample Code

/* Compile options needed: none
*/ 
    CDaoDatabase db;
    CDaoQueryDef query( &db );
    int idx;
    CByteArray blob;
    const int SIZE = 255;    // Execute will succeed if 255, fail if 256
    try
    {
        db.Open( "C:\\DB1.mdb" );
        query.Open( "Query1" );
        query.SetParamValue( "theID", COleVariant( (long)1, VT_I4 ) );

        blob.SetSize( SIZE );
        for( idx = 0; idx < SIZE; ++idx )
            blob.SetAt( idx, (BYTE)idx );
        query.SetParamValue( "theBlob", COleVariant( blob ) );
        query.Execute();
    }
    catch( CDaoException* e )
    {
        AfxMessageBox( e->m_pErrorInfo->m_strDescription,
            MB_ICONEXCLAMATION );
        e->Delete();
    }
    query.Close();
    db.Close();