Firebird 3 ?? is ready ?



Where is firebird 3 ?



Thanks



From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas Steinmaurer
Sent: 22 Juli 2011 12:00
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] call function

> Dear All
>
> How to call function from Select
>
> Example (In Oracle)
>
> SELECT a.cus_cd, F_CusNm(a.cus_cd) cus_nm FROM table_a a

> This Function is
>
> CREATE OR REPLACE Function F_CusNm(sCusCd VARCHAR2)
> RETURN VARCHAR2
> IS rCusName Varchar2(30);
> BEGIN
> SELECT CUS_NM
> INTO rCusName
> FROM CUSTOMER
> WHERE Cus_CD = sCusCd;
> RETURN TRIM(rCusName);
> Exception
> When No_Data_Found then
> rCusName := '';
> Return rCUsName;
> END;

Stored functions will be available in Firebird 3. But you could write a
selectable stored procedure returning a scalar value and then use it
like that in the select statement:

select
...
, (select rCusName from myproc(sCusCd)) as myname
from
mytable

...

--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!






===============================================================================================
This e-mail transmission is intended solely for the ordinary user of the e-mail address
to which it was addressed. It may contain legally privileged and/or confidential information.
If you have received this e-mail in error or are not an intended recipient please inform
the sender with-out delay and delete this e-mail, attachments and possible copies immediately.
The unauthorized use, disclosure, distribution and/or copying of this e-mail or any information
it contains is prohibited

[Non-text portions of this message have been removed]