Data extract from database is truncated!!  
Author Message
Agent00





PostPosted: Visual C++ General, Data extract from database is truncated!! Top

Hi,

I ran into a problem using C++ to extract data from Access database. I have in a "description" cell is type "memo" that could store more than 256 chars. But everytime I try to extract the text from my "description" cell, it truncated up to 256 and won't extract my whole text. Please help me!!

Thanks so much in advance

Jason




Visual C++12  
 
 
Nishant Sivakumar





PostPosted: Visual C++ General, Data extract from database is truncated!! Top

How exactly are you accessing the database Are you using ADO or the MFC ODBC classes

 
 
Agent00





PostPosted: Visual C++ General, Data extract from database is truncated!! Top

Hi,

I'm accessing the database through MFC ODBC. Do you have a recommendation on which is best to access Access database

Thanks

Jason



 
 
nobugz





PostPosted: Visual C++ General, Data extract from database is truncated!! Top

I read here that memo fields get truncated when your query contains aggregrate functions or is sorted with ORDER BY.



 
 
Agent00





PostPosted: Visual C++ General, Data extract from database is truncated!! Top

Thanks for the reply and the link, it really helps.

Thank you!!

Jason