You have to first figure out what the next "auto increment" number would be - you can use a "get max" first on the column, deal with the result set & getInt(1), the increment it by one (assuming it's an int), then when you insert the new record, you have the correct next value to insert.
[This message has been edited by Dorothy Finkel-Laverty (edited November 24, 2001).]
Carey, You list columns you are inserting and values. ex. insert into testtab (lastname, firstname) values('ann', 'jones') Dan [This message has been edited by Daniel Dunleavy (edited November 24, 2001).]
Sorry, doesn't work. If you leave out any of the fields JDBC complains at run-time.[/B]
This does work. There may be something else wrong with your insert. What is the error message? This works: Table emp, columns id (autonumber), name (string) sql: insert into emp (name) values ("John Fingers") this will insert the next autonumber field and the name into the emp table. Jamie