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

    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

    what is sqlstring;
    what is field94
    what is the cursor type of your connection object
     

Share This Page