adodb and decimal fields


anyone know why i don’t get a value returned from numeric fields?
I’m getting values back from all the other fields just fine.

There are no Numeric fields in Xojo. Use:

dim num as double = Val(Trim(.Text))

the numeric fields are in the ADODB recordset.

but i can’t read the data from them