Go4Expert

Go4Expert (http://www.go4expert.com/)
-   SQL Server (http://www.go4expert.com/forums/sql-server-forum/)
-   -   HELP!!! rs.fields(i).value is destructive (http://www.go4expert.com/forums/help-rsfields-i-value-destructive-t12583/)

QBDev 31Jul2008 03:30

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

Cseek 14Dec2009 16:15

Re: HELP!!! rs.fields(i).value is destructive
 
what is sqlstring;
what is field94
what is the cursor type of your connection object


All times are GMT +5.5. The time now is 00:57.