I'm using java as my prog. language I have problem delete a row in the database This is my sql statement. Whats wrong with it?It deletes all entry in the field rather than only the row i wanted it to be. String query = "DELETE FROM Students" + "' WHERE id=" + fields.name.getText(); output.append( "\nSending query: " + connection.nativeSQL( query ) + "\n" ); I have tried another method which i can delete only the row i specify inside the bracket .absolute(3) /delete row 3 in database.Following is the code: Statement statement = connection.createStatement( ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); ResultSet uprs = statement.executeQuery( "SELECT ID, emailaddress FROM Employee"); uprs.absolute(3); uprs.deleteRow(); uprs.refreshRow(); What is the correct way to write the codes so that I can delete the row where "login = "'+login'" ". Thank you. -Noel-

I'm not a good SQL programmer but I seem to notice something unusual in your query statement. You typed in : String query = ... "'WHERE id=" + ... maybe you forgot the single closing qoute around the WHERE: String query = ... "'WHERE' id =" + ... Your query statement as it is might evaluate to : String query = "DELETE * FROM Students + ...