On 20 Nov 2001, at 17:49, Jason Wharton wrote:

> > I would like to see an AUTOINC field type, the engine would
>
> As long as you make the trigger so it only puts in a value if it is
> NULL would this be a useful mechanism.
>

Good point Jason, yeah it should only be if the field is NULL going
in. The idea is that I have definitions for about 50 tables at this
point, and doing a copy and paste of the same trigger code, is
getting a boring, plus it's error prone, so I thought it's the kind of
repetative activity that would be better handled by the database
engine. By replicating what millions of programmers are already
doing, in the engine itself, would make life easier.

This could also be called an IDENTITY field, which might be a more
SQL standards way of doing it.

Paul
Paul Schmidt
Tricat Technologies
paul@...
www.tricattechnologies.com