I was not aware of this feature in FB2.

Why does Firebird 2.0 use the FOR token here?

IBO removes the FOR UPDATE clause on buffered queries because it is
obviously a bad idea to send records to a buffered dataset with one record
per network packet.

Regards,
Jason Wharton

> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Martijn Tonies
> Sent: Wednesday, November 08, 2006 7:55 AM
> To: ibobjects@yahoogroups.com
> Subject: [IBO] Another Firebird 2.0 thingy
>
>
> Hi,
>
> When executing this statement:
> select next value for category_id
> from rdb$database
>
> IBO mogrifies it into:
>
> select next value
> , RDB$DATABASE.RDB$DB_KEY
>
>
> I'm unsure if this has been fixed yet.
>
>
> 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
>