Re: [SQLObject] NextID?

[Ian B. <ia...@co...>]

On Oct 31, 2003, at 11:38 AM, Bruno Trevisan wrote:
> If you don't want to go like this, you can create that field as an
> integer and manually create a sequence. Then, you can "SELECT
> nextval('sequence')" to get the next id and use it to create a new
> record.

Yes, you'll have to write this SQL manually, and then use the output 
when you call .new() (passing id in).  I don't know of a way to do this 
with MySQL or SQLite, which don't have explicit sequences.

--
Ian Bicking | ia...@co... | http://blog.ianbicking.org