I am saving a record to a database on SQL server 2k that has a field 'id' -- it is an autonumbered/identity field and thus auto-increments as necessary when saving records.At any rate, this is the ...

I would have thought that one can change it to a number field, change the value then re-autonumber it again like in SQL server, but I guess not... does anyone know of a way to accomplish what I ...