Only first digit returned to VC++

[J Jungeblut]

Hi!
I have an Access 97 Database which I have to read from with C++.
All the text-fields are returned to c++ completely, but when a field
contains a number greater than 9 the return value to c++ is just the
first digit of that number.
With an Access 95 Database, it seems to work correctly, but I can't
use one in this case.

This is the Code I use:

CDaoRecordset rs;
//I have left out some irrelevant initializations
rs.Open(AFX_DAO_USE_DEFAULT_TYPE, "select * from TSW", NULL);

COleVariant olevar;
CString strData;

while (!rs.IsEOF()) {
rs.GetFieldValue("Distance",olevar);
olevar.ChangeType(VT_BSTR, NULL);
strData = (LPCSTR)olevar.pbstrVal;
cout << (const TCHAR*)strData << endl;
rs.MoveNext();
}
Please help!!

Thank You very much!

[DC Fan]

I don't know much about VC++, but it sounds like an ODBC driver issue or a
data type issue. In looking at your code, it looks like you are using
variant data types, but I am not sure. What is the data type of the field
in the access database?

"J Jungeblut" <ju******@familie-schindler.com> wrote in message
news:ea**************************@posting.google.c om...

Hi!
I have an Access 97 Database which I have to read from with C++.
All the text-fields are returned to c++ completely, but when a field
contains a number greater than 9 the return value to c++ is just the
first digit of that number.
With an Access 95 Database, it seems to work correctly, but I can't
use one in this case.

This is the Code I use:

CDaoRecordset rs;
//I have left out some irrelevant initializations
rs.Open(AFX_DAO_USE_DEFAULT_TYPE, "select * from TSW", NULL);

COleVariant olevar;
CString strData;

while (!rs.IsEOF()) {
rs.GetFieldValue("Distance",olevar);
olevar.ChangeType(VT_BSTR, NULL);
strData = (LPCSTR)olevar.pbstrVal;
cout << (const TCHAR*)strData << endl;
rs.MoveNext();
}
Please help!!

Thank You very much!