Operation must use an updateable query.

Anon · Mar 28, 2002

what wrong?

UPDATE VOTER
SET CONF_ID = (SELECT MAX([conf_id])+1 FROM VOTER)
WHERE SIN = 123457891

Error in update:java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]
Operation must use an updateable query.

Anon · Mar 28, 2002

I am writing this in Java and somebody help please

Anon · Mar 28, 2002

Anon · Mar 28, 2002

maybe you missed the title of this site. It is PHPbuilder not JavaBuilder.

smarlowe · Mar 29, 2002

Sounds like Access doesn't like subqueries.

Try a real database, MSSQL or Postgresql and it might work.