How should I read froma dbase ?

[Sonu Kapoor]

Originally posted by sslavko

COleVariant v;
recordset.GetFieldValue(10, v);
COleCurrency c(v);
CString strReturnVal = c.Format();

This is correct way to read currency from database and to convert it to string. If you need other locale then user default, take a look on parameters for COleCurrency::Format();

Unfortunaly the CRecordSet::GetFieldValue() does not take a COleVariant object as a param. If I am not wrong this will only work if you use the class CDaoRecordset.