CREATE TRIGGER MyTrigger FOR TABLEXpto 'ON COMMIT' AS...

hehehehe.

Artur Anjos

----- Original Message -----
From: "Paulo Gaspar" <Paulo.Gaspar@...>
To: <ib-support@yahoogroups.com>
Sent: Thursday, November 22, 2001 3:27 PM
Subject: RE: [ib-support] Idea for a new field type for FB 2,0 or IB 7?


> > How should I know, I do know that some other databases do, but
> > those are closed source proprietory stuff, so who knows what they
> > do internally.....
>
> The only way I can imagine that does not mess/delay concurrent
> transactions is to fill those fields and all other fields and
> variables that reference them with some kind of reference that
> is resolved at commit time.
>
> Big mess!
>
>
> Have fun,
> Paulo Gaspar
>
>
> > -----Original Message-----
> > From: Paul Schmidt [mailto:paul@...]
> > Sent: Thursday, November 22, 2001 3:50 PM
> > To: ib-support@yahoogroups.com
> > Subject: Re: [ib-support] Idea for a new field type for FB 2,0 or IB 7?
> >
> >
> > On 21 Nov 2001, at 23:06, lester@... wrote:
> >
> > > > As for a true series type Auto incrementing field, that would be
> > > > nice, but should probably be implemented as a serial generator, that
> > > > is a generator that guarantees there are no holes in the series, we
> > > > could then use a similar mechanism.
> > >
> > > But that is simply not practical - some transactions in the
> > > real work will be rolled back - how do you fill the hole,
> > > since it will now be out of sequence.
> > >
> >
> > How should I know, I do know that some other databases do, but
> > those are closed source proprietory stuff, so who knows what they
> > do internally.....
> >
> > Paul
> > Paul Schmidt
> > Tricat Technologies
> > paul@...
> > www.tricattechnologies.com
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>