Solved

CDaoRecordSet and CByteArray HELP!

Posted on 1998-05-11
4
377 Views
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");
rs.Open(dbOpenDynaset,szQuery);
rs.SetBookmark(rs.GetLastModifiedBookmark());
rs.AddNew();

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

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

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!
0
Comment
Question by:Surfer
  • 3
4 Comments
 

Author Comment

by:Surfer
ID: 1309708
Edited text of question
0
 

Author Comment

by:Surfer
ID: 1309709
Adjusted points to 200
0
 
LVL 4

Accepted Solution

by:
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).

Writing:
   
    // Open recordset
    CMySet rs(&m_db);
    rs.Open(dbOpenDynaset);
   
    // Add new record
    rs.AddNew();
    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
    rs.Update();
    rs.Close();


Reading:

    // Open recordset
    CMySet rs(&m_db);
    rs.Open(dbOpenDynaset);

    // 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
        rs.MoveNext();
    }

    // Close recordset
    rs.Close();


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

Author Comment

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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Rewrite URL With Encoded Characters 6 75
Looking for a specific application/software 2 104
post4 challenge 28 91
Detect file exist or not 3 128
Introduction: Ownerdraw of the grid button.  A singleton class implentation and usage. Continuing from the fifth article about sudoku.   Open the project in visual studio. Go to the class view – CGridButton should be visible as a class.  R…
Introduction: Dialogs (1) modal - maintaining the database. Continuing from the ninth article about sudoku.   You might have heard of modal and modeless dialogs.  Here with this Sudoku application will we use one of each type: a modal dialog …
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.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

930 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now