Re: SELECT FROM TABLE AND VALUE FROM STORED PROCEDURE

Article View: borland.public.interbase.sql

Article #910

Back to borland.public.interbase.sql Previous Next

#910

From: Thomas Steinmaurer
Date: Tue, 17 Apr 2007 09:11

38 lines
1701 bytes

> Is some posible way to select Value in this way in Interbase:
> 
> CREATE PROCEDURE EXAMPLE1(PARAM_ID INTEGER)
> RETURNS (OUT_SOMETHING INTEGER)
> AS
> 
> BEGIN
> 
>   OUT_SOMETHING = 1

Add a SUSPEND; here

> 
> END;
> 
> sample:
> SELECT *, EXAMPLE1(ID) FROM TABLE_XX

select
   t.*,
   (seelect out_something from example1(t.id)) as out_something
from
   table_xx t


The above works if the stored procedures returns only zero or one row 
for the given ID.



-- 
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com

Technical Details

Message-ID: <46248f23@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <462487c5@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,ac243d27d9e933e0
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Tue, 17 Apr 2007 11:11:28 +0200
From: Thomas Steinmaurer <t.steinmaurer_dontbugmewithspam@upscene.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: SELECT FROM TABLE AND VALUE FROM STORED PROCEDURE
References: <462487c5@newsgroups.borland.com>
In-Reply-To: <462487c5@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 193.186.164.88
Message-ID: <46248f23@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1176801059 193.186.164.88 (17 Apr 2007 02:10:59 -0800)
Lines: 38
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message