> Trond wrote:
> > SQL :
> >
> > SELECT RDB$USER AS AUser, RDB$RELATION_NAME AS Rolle
> > FROM RDB$USER_PRIVILEGES
> >
> > iboquery1.Locate( 'RDB$USER', 'Test', [] );
> >
> > will fail becaus of the the alias use :(
> >
> > There is no keylinks etc in the query
>
> This is fixed in IBO 4.7 Beta 12.

How? Is RDB$USER allowed in .Locate? IMO, it shouldn't, because
of the alias. You're not searching for RDB$USER, but you are transforming
column RDB$USER into derived column AUser.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com