Louis,

This should be posted to IB-Priorities@egroups.com this is the location
for all "wish" lists.


Sean

-----Original Message-----
From: Louis van Alphen [mailto:lja@...]
Sent: Monday, June 05, 2000 7:24 AM
To: IB-Architect@egroups.com
Subject: [IB-Architect] A few more suggestions

I apologise for using this list to voice my wish list...but

I find that there is a lack in IB to execute DDL statements from within
SPs. This is something that we have needed many times, but had to resort
to
performing these operations from a client. MS SQL Server provides these
functions.

Something else that we have needed was the ability to have dynamic SQL
from
within a SP. I know that this may be asking a bit much. Think of the
ability to have a table of selection criteria (WHERE clauses) and being
able to, in a SP 'FOR SELECT' statement perform a query for each of the
stored selection criteria. I hope this abbreviated example is clear.

Hope this sets some minds churning even faster... ;-)

Thanks




L.J. van Alphen
Managing Director
Basix Automation

E-mail: lja@...
Tel: (+27) (0)21-683 5490
Fax: (+27) (0)21-683 5435

P.O. Box 171
Rondebosch
7701
South Africa

------------------------------------------------------------------------
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/_/960204546/
------------------------------------------------------------------------

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