Bug in framework : variable stay unchanged ???

  • Thread starter Thread starter Ludovic Lemarinel
  • Start date Start date
L

Ludovic Lemarinel

Hi

I've been working on the dotnet framework in vb for a while (about One
year), and I've got a problem :

I've written a piece of code which makes a first recordset :

dim query, updtquery as string

query="SELECT fooo FROM fooo_table "
rs = cn.openrecordset(query)
while (not query.eof)
updtquery="UPDATE foo2_table SET foofield='some value' WHERE
foofield2='some value' "
'execute the updtquery
some code to run the updtquery
end while

And I've got a bunch of 10 to 20 loops like this one.

Since the 8-9th loop, the updtquery string does'nt vary anymore : I explain:
when I go throught updtquery="UPDATE foo2..., while debugging and executing
the updtquery, the variable value don't change ??? It stays at his old
value, and stays again while I try to change it for about 60 times !!!! (and
never changes !!!!!)

Is this a bug in the Dotnet Framework????

(Running under WinXP, SQL Server 7 on remote server)

Please heeelp me !?

thanks ;)
 
Put the real code, and we can see what it is doing / not doing. Is ther
something to increment the variable?
while (not query.eof)
Click to expand...
would need to be
rs.eof
because
query
is a string.
 
Back
Top