CDaoRecordSet and CByteArray HELP!

Posted on 1998-05-11
Last Modified: 2013-11-20
VCPP 5.0 Win95
I am trying to store and retrieve a CByteArray to my DaoRecordset and not succeeding. To write the data I am doing the following:
BYTE abyteTemp[MAX];
CByteArray array ;
CDaoRecordset rs (&m_db);
char szQuery[256];
sprintf(szQuery,"SELECT * FROM MyTable");

array.SetSize( m_nSizeOfData ) ;
for (INT n=0;n<m_nSizeOfData;++n)
array.Add(abyteTemp[n]) ;

COleVariant v(array) ;
rs.SetFieldValue("Data0", v);

After I execute this code, I can open my database table with Access and see that there is data written to the proper dbLongBinary field.  The field reads. “Long binary data”.  I am not sure if the proper data has been written to the field because if I try and View the data, Access will not let me.  

For reading the databastable, I execute:

char szQuery[256];
CByteArray array ;
BYTE abyteTemp[MAX] ;

CDaoRecordset rs ( &m_db ) ;
sprintf( szQuery, "SELECT * FROM MyTable" ) ;
rs.Open( dbOpenDynaset,szQuery ) ;
if ( !rs.IsEOF( ) )
rs.MoveFirst( );

while( !rs.IsEOF( ) ) {
array.SetSize(m_nSizeOfData) ;

COleVariant v( array ) ;
rs.GetFieldValue( "Data0",v) ;

for (INT n=0;n<m_nSizeOfData;++n)
abyteTemp[n]=array.GetAt(n) ;

rs.MoveNext( ) ;

After writing and reading to the database I get garbage values in my CByteArray.  All suggestions welcome and code fragments greatly appreciated!
Question by:Surfer
  • 3

Author Comment

ID: 1309708
Edited text of question

Author Comment

ID: 1309709
Adjusted points to 200

Accepted Solution

piano_boxer earned 300 total points
ID: 1309710
I can not make the method you are using work, but here's a way that will work:

Instead of just use a generic CDaoRecordset, derive a new class from
CDaoRecordset (CMySet) using ClassWizard, and bind to the fields in your database table (MyTable).
Bind the field Data0 as a CByteArray called m_rgData0 (it defaults to CLongBinary so remember to change it).

    // Open recordset
    CMySet rs(&m_db);
    // Add new record
    rs.m_rgData0.SetSize( m_nSizeOfData );
    memcpy( &rs.m_rgData0[0], &abyteTemp[0], m_nSizeOfData );

    // Mark field as having a value and dirty.
    rs.SetFieldNull( &rs.m_rgData0, FALSE );
    rs.SetFieldDirty( &rs.m_rgData0, TRUE );

    // Store record and close recordset


    // Open recordset
    CMySet rs(&m_db);

    // Now recordset is opened and placed on first record.
    // Loop through all records
    while( !rs.IsEOF() )
        ASSERT(rs.m_rgData0.GetSize() != 0);

        memcpy( &abyteTemp[0], &rs.m_rgData0[0], rs.m_rgData0.GetSize() );

        // NOTE: call rs.m_rgData0.GetSize() to get size of data
        //       stored in database

        // Now data from 1 record has been copied to abyteTemp
        // Do something with it!

        // Move on to next record

    // Close recordset

Please note that you should surround these calls with try/catch to catch

Author Comment

ID: 1309711
Your answer was right on the mark!  Thank you very much.

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
unable to delete all specified values regedit 38 404
conditional code and condition difference 9 82
noX challenge 17 116
Unix Command -- Challenging  question 7 90
This is to be the first in a series of articles demonstrating the development of a complete windows based application using the MFC classes.  I’ll try to keep each article focused on one (or a couple) of the tasks that one may meet.   Introductio…
Have you tried to learn about Unicode, UTF-8, and multibyte text encoding and all the articles are just too "academic" or too technical? This article aims to make the whole topic easy for just about anyone to understand.
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question