Hi,

>What I would like to see (and I believe the capability exists at the BLR
>level due to conversations I have had with Charlie Caro) is for there to be
>SYNTAX similar to a stored procedure which can return a single row, have an

Something like a Stored Function (like in Oracle) would be great, I think.

You even would be able to use it like:

select col1, col2, function(col3)
from table


Yes, I know - it can be done by UDFs, but these are external while Stored
Functions would be inside the database and, I think, more easily managable.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."