re: Dynamic SQL from within an SP.

I don't think that is asking for a "bit much" -- Oracle supports this. My
head has been churning the last
few weeks about how this could be added within IB.

Along the lines of "defining the problem" -- Louis, can you define some DDL
operations that
you've wanted to do in a SP, but haven't been able to?

Dave

-----Original Message-----
From: Louis van Alphen [mailto:lja@...]
Sent: Monday, June 05, 2000 4: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

_____

<http://click.egroups.com/1/3373/4/_/830676/_/960204546/>
<http://adimg.egroups.com/img/3373/4/_/830676/_/960204546/>

_____

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






[Non-text portions of this message have been removed]