Your SET clause is wrong. In SQL UPDATE, there is a single SET keyword followed by
assignments separated by commas:

   String updateString =("UPDATE StockTable "
        + "SET Description = Description,"
        + "Price = Price,"
        + "InStock = InStock "
        + "WHERE ID = ID");

Note that I also corrected your WHERE. WHERE must be followed by a predicate expression
not an arithmetic expression.

--
Lee Fe{*filter*}an, FFE Software, Inc. ( http://www.***.com/ )

Hi all,
           I am having a bit of a problem with an UPDATE statement to an MS
Access database. All of my other statements work well, such as DELETE,
SELECT, etc. Could someone have a look at my code below, and show me where I
have made a mistake? As it stands, I get a syntax error with the UPDATE
statement. I am sure it is something simple, so any pointers will be
appreciated.  I have included an example below:

   Statement stmt = conn.createStatement();

   String updateString =("UPDATE StockTable "
        + "SET Description = Description "
        + "SET Price = Price "
        + "SET InStock = InStock "
        + "WHERE ID + ID");

   stmt.executeUpdate(updateString);
   conn.commit();
   stmt.close();

Hi Lee,
            thanks for that. I managed to figure it out myself anyway, after
much trial and error. The WHERE clause was just a typo, it was the SET
clause that I had the error with.

predicate expression