At 01:52 PM 21-11-01 +0100, Martijn Tonies wrote:

>Hi,
>
>
> >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
>
>Eh, also, I think that there has to be some way to get the value back to the
>client. :)

And..Ugh, just think what problems there would be in our comfortable little world if that AUTOINC type were under transaction control...

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________