Updating a table with an auto-number field

[rincewind44]

Hi,
I'm trying to make an addition to a table with an autonumber field, the sql code i'm using is

String sql = "update Individual set Points=?, Rebounds=?, Assists=?, Steals=?, Date=? where ID = ?";

This adds values to all the fields apart from the autonumber field which is the primary key.
I am getting a null pointer exception when I try this, is it due to the autonumber field? and if so can anyone advise me how to get around this problem?
Thanks

 

[Cagliostro]

It is a Java exception when you try to use a null variable.

Ion Filipski