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

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

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

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