0

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 VbThickhead

2
Contributors
1
Reply
12
Views
2 Years
Discussion Span
Last Post by Shark_1
1

From my opinion your SQL Statement should be

SqlTimes.UpdateCommand = "UPDATE Members  SET [Agegrade]='" & savetim1 & "' where [Fullname]='" & athletename & "'"
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.