| Subject | Re: [firebird-support] "Function Unknown" How to utilize Stored Procedures return value in a SELECT statement? |
|---|---|
| Author | Dimitry Sibiryakov |
| Post date | 2004-12-08T08:04:44Z |
On 8 Dec 2004 at 13:01, Namit Nathwani wrote:
SELECT (SELECT BOSDRAMT FROM OSAcctDrAmt(s.bDrAmt, uf.bDr, uf.bCr))
AS bBalDr
[and so on]
>I have a stored procedure as below. The return value of the stored[skipped]
>procedure I want to use in the SELECT statement of mine.
SELECT (SELECT BOSDRAMT FROM OSAcctDrAmt(s.bDrAmt, uf.bDr, uf.bCr))
AS bBalDr
[and so on]
> FROM tAccountsJV tSY, Dimitry Sibiryakov.
> JOIN sAccountsJV s
> ON s.iPID = t.iID
> AND s.iAcctID = 485
> LEFT JOIN uOSAccounts uf
> ON uf.iPID = t.iID
> OR uf.iSID = t.iID ;