SQL Server Performance

VB Recordset returning indifferent numeric value

Discussion in 'Non-Transact SQL Developer Performance Tuning' started by vispras, Jul 7, 2006.

  1. vispras New Member

    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.
    vispras, Jul 7, 2006
    #2

  2. harsh_athalye New Member

    Check the value of rs("Amt").Type property !

    "Nothing is Impossible"
    harsh_athalye, Jul 7, 2006
    #2

  3. vispras New Member

    Hi harsh thnks.
    rs("Amt").Type property returned value "6"
    what am i supposed to with that value, any idea ?

    regds,
    Vishnu
    vispras, Jul 10, 2006
    #2

Share This Page