Solved

CDaoRecordSet and CByteArray HELP!

Posted on 1998-05-11
4
368 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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Question regarding Copy/Paste 16 87
Include multiple hostnames in this command? 3 52
dog bark java program 15 82
mapBully challenge 6 89
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…
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…
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.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

757 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

22 Experts available now in Live!

Get 1:1 Help Now