Bug in framework : variable stay unchanged ???

[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

 

[a]

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)

would need to be
rs.eof
because
query
is a string.

 

[Jerry]

"openrecordset" ???
Is this VB6?
We use datasets here.

 

[Armin Zingler]

"openrecordset" ???
Is this VB6?
No

We use datasets here.

We? Who is we? I don't use datasets here. ;-)