I have JTable, where the user sets the data and clicks update. What i want to do is update multiple columns in my database using prepare statement, i can update 1 column no problem but how do i update more then 1?
This is what i tried to do but it says Optional feature not included..any ideas?
You are missing a comma between your columns. Also, 'Part Number' looks odd - do you have columns with spaces in the name? I would expect a database to interpret a value in single quotes as a literal string value, not a column identifier.
You're using Access? Then it comes with documentation on the version of SQL it supports. In the long run you might find it easier to track down that documentation and find out the correct syntax for yourself, rather than waiting for answers on a forum.