How to get float or int data in the database with ADO?

13992822

Guys, all I see is getting text,
For example: var = m_pRecordset-> GetCollect ("Name");
if (var.vt! = VT_NULL)
strName = (LPCSTR) _bstr_t (var);

How do you get float or int data?
Thank you, I'm not too familiar with ADO

lcdxhj

_variant_t var = m_pRecordset-> GetCollect ("int_field") ;;
if (var.vt == VT_I4) int i = var.intVal;
if (var.vt == VT_R4) float f = var.fltVal;

13992822

Thank you
Could explain: _variant_t var
VT_I4
VT_R4
What does it all mean?
Thank you

mzhanshi

Positive solution upstairs, if you add an else between the two if, it will be judged less once, and the efficiency will be a little bit ^^

rsq666

_variant_t is the data structure:
VT_I4
VT_R4
Is the data type among them.

13992822

flot mvalue;
var = m_pRecordset-> GetCollect ("dometic_soil");
 if (var.vt == VT_R4)
  mvalue = var.fltVal;

dometic_soil is single precision in the database.
But why isn't the value in the above code a value in the database?
What went wrong? Please advise

120881170

You can use atoi ((LPCTSTR) (_ bstr_t) m_pRecordset-> GetCollect ("field"));
atol (), atof () ...
VT_I4 -------- 32bit integer
VT_R4 -------- 32bit floating point number