Jim,

Select Procedures as Views, an interesting thought!

I thought that with views (as currently implemented), any criteria/order
specified with a view (SELECT ... FROM ViewA WHERE ViewColumn1 =
'Anything" ORDER BY ViewColumnB) was "merged" with the View definition
to, in effect, become a single SELECT statement and hereby taking
advantage of index and other performance optimizations.

How would this the new Programmed View be integrated into this
mechanism?

Or am I waayy off base?


Sean


-----Original Message-----
From: Jim Starkey [mailto:jas@...]
Sent: Thursday, June 08, 2000 10:32 AM
To: IB-Architect@egroups.com; IB-Architect@egroups.com
Subject: Re: [IB-Architect] Select procedures

At 11:44 AM 6/8/00 +0200, Louis van Alphen wrote:

>Someone wrote:
>
>>The question is whether to translate "{ call foo }" into
>>"execute procedure foo" or "select * from foo".
>
>I use Delphi + IB + Crystal. I normally create SPs for ALL my reports,

as I

>can do joins, do calculations, etc...
>Then I purely link the report to the SP and Viola!. The point is that

it

>has the same effect as 'SELECT * FROM SP'. You do get the full

resultset.

>Then call the report from Delphi.....
>

The design (not the concept) of the select form of the InterBase
stored procedures is, in my ever humble opinion, is complete crock.
It is, in fact, a computational form of a view and should have been
implemented under the aegis of the view mechanism. With named arguments
and appearing in rdb$relations, rdb$fields, and rdb$relation_fields
(and the respective ODBC/JDBC meta data calls) it would have been
easier to use, easier to implement, and much easier to wrap with
intelligent code.

It's not high on my list of priorities, but I would like to see a
view based mechanism defined and the current mechanism deprecated.
This will have to wait until after the great Java vs. embedded Pearl
vs. XML shootout.

Jim Starkey

------------------------------------------------------------------------
Take your development to new heights. Work with clients like Dell and
pcOrder. Submit your resume to jobs@.... Visit us at
http://click.egroups.com/1/4358/4/_/830676/_/960474868/
------------------------------------------------------------------------

To unsubscribe from this group, send an email to:
IB-Architect-unsubscribe@onelist.com