473,327 Members | 1,979 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Bug in framework : variable stay unchanged ???

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 ;)
Nov 20 '05 #1
3 1260
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.

"Ludovic Lemarinel" <lu**********************@hotmail.com> wrote in message
news:bl**********@news2.isdnet.net... 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 ;)

Nov 20 '05 #2
"openrecordset" ???
Is this VB6?
We use datasets here.

"Ludovic Lemarinel" <lu**********************@hotmail.com> wrote in message
news:bl**********@news2.isdnet.net...
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 ;)

Nov 20 '05 #3
"Jerry" <Je*********@yahoo.com> schrieb
"openrecordset" ???
Is this VB6?
No
We use datasets here.


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

Nov 20 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: fripper | last post by:
I have installed Visual Studio .Net 2003 on top of an earlier version. Now, when I open a new project I get a message that says Visual Studio .NET has detected that the web server is running...
7
by: YGeek | last post by:
Is there any difference between declaring a variable at the top of a method versus in the code of the method? Is there a performance impact for either choice? What about if the method will return...
8
by: Arnaud Debaene | last post by:
Hello all, One area where the .Net framework 1.1 is really poor is Collections : We've got very few choice concerning the containers and their characteristics (for example, ArrayList, Queue and...
166
by: Graham | last post by:
This has to do with class variables and instances variables. Given the following: <code> class _class: var = 0 #rest of the class
4
by: emma middlebrook | last post by:
Hi Straight to the point - I don't understand why System.Array derives from IList (given the methods/properties actually on IList). When designing an interface you specify a contract. Deriving...
1
by: Bob | last post by:
I'm all of a sudden getting an access denied error on my web server when I access it from a browser: CS0016: Could not write to output file 'c:\WINNT\Microsoft.NET\Framework\v1.1.4322\Temporary...
8
by: Iouri | last post by:
Is it possible to run VS2005 under .Net Framework 3.0? If yes how to assign the .Net Fremowork 2 or 3 to the VS 2005.
8
by: Blasting Cap | last post by:
I'm using VS 2005, and have a dll in some code (system.core.dll) that was included in something someone sent me to run on my system. I have production on a server using Framework 2.0 that I want...
7
by: Tim | last post by:
Hi Gurus, I am kind of new with Microsoft Frameworks. We are writing an application for windows right now. I am wondering if we can run the same application with no change in code in Unix...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.