DaniWeb Forum Index > Software Development > Visual Basic 4 / 5 / 6

Visual Basic 4 / 5 / 6 RSS

edit the current data save in table

•

Join Date: Jul 2008

Posts: 161

Reputation: ryan311 has a little shameless behaviour in the past

Solved Threads: 1

ryan311

Offline

Junior Poster

edit the current data save in table

Mar 9th, 2009

all i want is change all the record in my table if the pcarrier="Credit" but my problem is only one data have been changes. .

 Help with Code Tags 
 Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
Set rs = New ADODB.Recordset
rs.Open "Select * from Soldto where cno='" & Combo1.Text & "'", cn, adOpenKeyset, adLockPessimistic
If rs!pcarrier = "Credit" Then
Do Until rs.EOF
rs!pcarrier = "Paid"
rs.MoveNext
rs.Update
Loop
End If
Set rs = New ADODB.Recordset
rs.Open "Select * from Soldto where cno='" & Combo1.Text & "'", cn, adOpenKeyset, adLockPessimistic
If rs!pcarrier = "Credit" Then
Do Until rs.EOF
rs!pcarrier = "Paid"
rs.MoveNext
rs.Update
Loop
End If

help thanks. .

•

Join Date: Mar 2009

Posts: 807

Reputation: vb5prgrmr will become famous soon enough

Solved Threads: 147

vb5prgrmr

Offline

Practically a Posting Shark

Re: edit the current data save in table

Mar 9th, 2009

Try something like...

 Help with Code Tags 
 Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
If rs.BOF = False AND rs.EOF = False AND rs.RecordCount <> 0 Then
  rs.MoveFirst
  Do While Not Rs.EOF
    rs.Edit
    rs!pcarrier = "Paid"
    rs.Update
    rs.MoveNext
  Loop
End If
If rs.BOF = False AND rs.EOF = False AND rs.RecordCount <> 0 Then
  rs.MoveFirst
  Do While Not Rs.EOF
    rs.Edit
    rs!pcarrier = "Paid"
    rs.Update
    rs.MoveNext
  Loop
End If

•

Join Date: Feb 2007

Posts: 2,092

Reputation: debasisdas will become famous soon enough

Solved Threads: 125

debasisdas debasisdas is online now

Online

Postaholic

Re: edit the current data save in table

Mar 9th, 2009

a single update statement will do , why you need a loop for that.

Share your Knowledge.

•

Join Date: Mar 2009

Posts: 807

Reputation: vb5prgrmr will become famous soon enough

Solved Threads: 147

vb5prgrmr

Offline

Practically a Posting Shark

Re: edit the current data save in table

Mar 10th, 2009

•

Originally Posted by debasisdas

a single update statement will do , why you need a loop for that.

I agree, but original poster is using loop and I am trying to help them with the logic of the loop and as to why only one of multiple records are being updated.

•

Join Date: Feb 2007

Posts: 2,092

Reputation: debasisdas will become famous soon enough

Solved Threads: 125

debasisdas debasisdas is online now

Online

Postaholic

Re: edit the current data save in table

Mar 10th, 2009

that ok, but updating records in a loop is not recommended as it takes a lot of system resources. and you have to commit very frequently , which again has a lot of side effects.

Share your Knowledge.