VB Recordset returning indifferent numeric value | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

VB Recordset returning indifferent numeric value

Hi,
We have a VB6.0 Application where the actual database numerical ( amount) value is returned indifferently by the ADODB recordset. For Ex:
Database value (SQL Anywhere) : " 254578.00 "
ADODB Recordset value , rs("Amt") : " 2545780000"
any reason why this strange behaviour.
Does the regional setting in the machine effect this.
Check the value of rs("Amt").Type property ! "Nothing is Impossible"
Hi harsh thnks.
rs("Amt").Type property returned value "6"
what am i supposed to with that value, any idea ? regds,
Vishnu
]]>