Hvad er galt her?!
Kan nogen finde en fejl her :(st.executeQuery("UPDATE person SET(FirstName, LastName, Sex, DateOfBirth, Street, Number, ZipCode, City, Country, Homephone, Workphone, Fax, Email, Occupation, AdditionalInformation, DateOfRegistration) VALUES('" + Update.GetFirstName() + "','" + Update.GetLastName() + "','" + Update.GetSex() +"','" + Update.GetDateOfBirth() +"','" + Update.GetStreet() +"','" + Update.GetNr() +"','" + Update.GetZipCode() +"','" + Update.GetCity() +"','" + Update.GetCountry() +"','" + Update.GetHomephone() +"','" + Update.GetWorkphone() +"','" + Update.GetFax() +"','" + Update.GetEmail() +"','" + Update.GetOccupation() +"','" + Update.GetAdditionalInformation() +"','" + DateTime.GetCurrentDate() +"') WHERE Person_ID = '" + Update.GetID() + "')");
st.executeQuery("UPDATE athlete SET(Log_ID, Tournement_ID, Record, HandicapClass) VALUES('"+"','" + Update.GetTournementID() + "','" + Update.GetRecord() + "','" + Update.GetHandicapClass() +"') WHERE Person_ID = '" + Update.GetID() + "')");
Jeg får denne fejl meddelse:
java.sql.SQLException: Syntax error or access violation: You have an error in your SQL syntax near '(FirstName, LastName, Sex, DateOfBirth, Street, Number, ZipCode, City, Country, ' at line 1
