sql update problem with vb.net ?

[Sheena777]

I am trying to update a field in a sql 2000 database I have put the update statement in a for loop. I have found that is I step through the code myself then I have no problems the data get updated but when I leave the process to run automatically like it is surpossed to it does not wanto to. I know that the code is going through this process because the minute the record has been updated it is written to a log. What i don't understand is why the code is not carrying out the Update Command. Here is the Update Statement that I am using:

Dim ra as Integer
cmd = New SqlCommand("UPDATE DEB_DebtorBank SET DEB_DebtorBank.IsActive = '1' where DebtorID = " & value, cn)
ra = cmd.ExecuteNonQuery()

value is just a variable keeping a id for the field which is coming from a dataset.
Is there anything wrong with my sql statment, should I be doing somthing else?

[dip_developer]

I am trying to update a field in a sql 2000 database I have put the update statement in a for loop. I have found that is I step through the code myself then I have no problems the data get updated but when I leave the process to run automatically like it is surpossed to it does not wanto to. I know that the code is going through this process because the minute the record has been updated it is written to a log. What i don't understand is why the code is not carrying out the Update Command. Here is the Update Statement that I am using:

Dim ra as Integer
cmd = New SqlCommand("UPDATE DEB_DebtorBank SET DEB_DebtorBank.IsActive = '1' where DebtorID = " & value, cn)
ra = cmd.ExecuteNonQuery()

value is just a variable keeping a id for the field which is coming from a dataset.
Is there anything wrong with my sql statment, should I be doing somthing else?

looking nothing wrong in the query.......are u getting any error??
give the code snippet...

[Shashi Sadasivan]

I know that the code is going through this process because the minute the record has been updated it is written to a log. What i don't understand is why the code is not carrying out the Update Command.

Could you please clarify the statement?
seems pretty self revolting to each other.
u say that the code does go through and it is updated to the log, but the update command is not being carried?

[kunal pawar]

Can u tell us which error it throws

[Sheena777]

The problem is that the code goes through the update statement without actually updating the value in the DataBase.I want to know why the code would go through the process and not actually update the records.All I know is that out of the 3000 records that needed to be update only one is being update.So that is my real problem.

[Shashi Sadasivan]

then in that case it seems to be a problem with your sql statement, isint it?

get into the debug mode, copy the value of the sql method being run and paste it in your sql console and verify the sql statement !

[Sheena777]

I have found out what my problem was, there was nothing wrong with my sql statement it was getting all the necessay values for it to run but becuase it was in two loops it was not looping throught the right values and therefore it was stuck with one value the whole time that is was running.