Member Avatar for Vb.Netter

Hi insert command works update does not do anything any help Please
SqlTimes.InsertCommand = "insert into athletedata([Athlete],[Mydate],[session],[mytime]) values ('" & athletename & "','" & storedate & "','" & todaysession1 & "','" & savetim1 & "') "
SqlTimes.Insert()

                        SqlTimes.UpdateCommand = "UPDATE Members  SET [Agegrade]=('" & savetim1 & "'where [Fullname]='" & athletename & "') "
                        SqlTimes.Update()
Edited by Vb.Netter
  • 2 Contributors
  • 1 Reply
  • 315 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by Santanu.Das
Member Avatar for Santanu.Das

From my opinion your SQL Statement should be

SqlTimes.UpdateCommand = "UPDATE Members  SET [Agegrade]='" & savetim1 & "' where [Fullname]='" & athletename & "'"
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.