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)
would need to be
rs.eof
because
query
is a string.



"Ludovic Lemarinel" <(E-Mail Removed)> wrote in message
news:bljf5u$pv0$(E-Mail Removed)...
> 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
>
>

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

"Ludovic Lemarinel" <(E-Mail Removed)> wrote in message
news:bljf5u$pv0$(E-Mail Removed)...
> 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
>
>

"Jerry" <(E-Mail Removed)> schrieb
> "openrecordset" ???
> Is this VB6?

No

> We use datasets here.

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


--
Armin