When using JDBC to insert into a database, how does one cope with AutoNumber Columns. What sort of SQL statement should I use?
I've tried leaving the autonumber field off - error: 'Number of query values and destination fields aren't the same'
setting the field to null - error: 'You tried to assign the Null value to a variable that isn't a Variant data type.'
I suppose that I could look up the last number each time and set the value accordingly, but this seems a little unsatisfactory.