Re: SELECT FROM TABLE AND VALUE FROM STORED PROCEDURE

Article View: borland.public.interbase.sql

Article #911

Back to borland.public.interbase.sql Previous Next

#911

From: Karol Bieniaszewski
Date: Tue, 17 Apr 2007 09:42

45 lines
1865 bytes

Uzytkownik "Thomas Steinmaurer" 
<t.steinmaurer_dontbugmewithspam@upscene.com> napisal w wiadomosci 
news:46248f23@newsgroups.borland.com...
>> 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

greate thanks
Karol Bieniaszewski

Technical Details

Message-ID: <462495c0$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <462487c5@newsgroups.borland.com> <46248f23@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
From: "Karol Bieniaszewski" <liviuslivius@poczta.onet.pl>
Newsgroups: borland.public.interbase.sql
References: <462487c5@newsgroups.borland.com> <46248f23@newsgroups.borland.com>
Subject: Re: SELECT FROM TABLE AND VALUE FROM STORED PROCEDURE
Date: Tue, 17 Apr 2007 11:42:44 +0200
Lines: 47
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 195.205.151.58
Message-ID: <462495c0$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1176802752 195.205.151.58 (17 Apr 2007 02:39:12 -0800)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message