1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

HELP!!! rs.fields(i).value is destructive

Discussion in 'SQL Server' started by QBDev, Jul 30, 2008.

  1. QBDev

    QBDev New Member

    Joined:
    Jul 30, 2008
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    VB6. ODBC, ADO, SQL Server

    I think that I am going crazy.

    1 program seems to get this problem intermittantly.

    I can only read the data once. They it goes to null

    ODBCRS.Close:Set ODBCRS = ODBCCon.Execute(SQLString, iRecordsAffected)
    ? ODBCRS.Fields(93).Value,ODBCRS.Fields(93).Value
    Sergio Null

    Even ? ODBCRS.Fields(94) will charge field 93 to nulls

    It does NOT happen on all fields. Field 94 in this case works fine.

    What am I missing?

    Help!!!!!!!!!!!!!
    Jack
     
  2. Cseek

    Cseek New Member

    Joined:
    Dec 1, 2009
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    0
    Occupation:
    train driver
    Location:
    hubli / karnataka
    Home Page:
    what is sqlstring;
    what is field94
    what is the cursor type of your connection object
     

Share This Page