Re: Join on Interbase

Article View: borland.public.interbase.sql

Article #11032

Back to borland.public.interbase.sql Previous Next

#11032

From: The DeerBear
Date: Fri, 27 Dec 2002 05:04

16 lines
1289 bytes

Hi again,

I started reading a SQL book where the authors say that a view is basically
a query.
My question is: can I parameterize a view to obtain an again filtered result
set?

Say, I write this code:

Select FIRST_NAME,LAST_NAME,ROLE from ACCOUNTVIEW WHERE USER_ID = :ID .

Would such a statement be correct?

TIA

Andrew

Technical Details

Message-ID: <3e0bdf39@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!diablo.theplanet.net!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!gatel-ffm!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <3e0b8c13@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,fa51700038f7b6f2
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-26 21:08:52 PST
From: "The DeerBear" <rainaple@tin.it>
Newsgroups: borland.public.interbase.sql
References: <3e0b8c13@newsgroups.borland.com>
Subject: Re: Join on Interbase
Date: Fri, 27 Dec 2002 06:04:02 +0100
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 62.211.49.173
Message-ID: <3e0bdf39@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1040965433 62.211.49.173 (26 Dec 2002 21:03:53 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!diablo.theplanet.net!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!gatel-ffm!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message