Subject Re: [IB-Architect] Re: TOP and BLR (was: Creating invalid procedures and views... Just an idea)
Author Nando Dessena

> > >FireBird 1.0 will be incompatible with Borland's IB anyway -
> > >if FB will support SELECT TOP, any application that uses such
> syntax will
> > >not work with IB. Also FB's backup with SELECT TOP in procedure or
> trigger
> > >will not be restorable with Borland's IB.
> >
> > Actually that's not the case. You couldn't extract the metadata and
> > recreate the database with ISQL, but backup doesn't use the
> procedure
> > source. It uses BLR and there won't be any BLR changes.
> How is this TOP function implemented then?

I believe it's always been there; only the SQL interface for it was