|Subject||RE: [IBO] Parsing error for Fb 2.0 with derived tables?|
> Martijn wrote:I have it working such that it won't mess up your query and also such that
> > Jason wrote:
> > > Wow, that's a really lovely result.
> > >
> > > I'll have a looky look.
> > >
> > > When was this type of query acceptable as I don't recall
> > ever using that
> > > kind of a FROM clause before.
> > Firebird 2.0, Release Notes under "Derived Tables". Welcome :-)
> > You have Arno to blame for it too ;)
> Pretty darn cool!
> Although I'm losing some of my nice dark colored hair over this!
> I'm not quite sure how to handle this unusual table name...
> Looks like it will end up as an escaped entry in the
> RelAliasList property.
it stores the value of this derived table as the table name in the
RelAliasList property if for some reason it is needed.
I am considering that KeyLinksAutoDefine will not be in order, as of yet,
for queries with a derived table in it.
This fix will come out in IBO 4.7 Beta12.