[sqlite] Triggers Not Implemented With INTEGER PRIMARY KEY. But Assured -1?

I am working with triggers on a field defined in a table as INTEGER PRIMARY KEY. Agreed, triggers are not fully implemented on int primary key; but, I need the autoincrement feature. I always get -1. Can I depend on that -1 until this feature is implemented? Here is an example. There are two

Re: [sqlite] Triggers Not Implemented With INTEGER PRIMARY KEY. But Assured -1?

[EMAIL PROTECTED] wrote: I am working with triggers on a field defined in a table as INTEGER PRIMARY KEY. Agreed, triggers are not fully implemented on int primary key; but, I need the autoincrement feature. I always get -1. Can I depend on that -1 until this feature is implemented? If you spec

Re: [sqlite] Triggers Not Implemented With INTEGER PRIMARY KEY. But Assured -1?

On Sat, Sep 18, 2004 at 04:58:53PM -0400, D. Richard Hipp wrote: > [EMAIL PROTECTED] wrote: > >I am working with triggers on a field defined in a table > >as INTEGER PRIMARY KEY. Agreed, triggers are not fully > >implemented on int primary key; but, I need the autoincrement > >feature. > > > >I