Generating New ID

[JMvVliet]

INSERT INTO StockGroup (id, otherfield, and_so_on) SELECT MAX(id) + 1, "otherfield", "and_so_on" FROM StockGroup

where 'otherfield' and 'and_so_on' are strings.
This is the right syntaxis.