Subject RE: [IB-Architect] A few more suggestions
Author Leyne, Sean

This should be posted to this is the location
for all "wish" lists.


-----Original Message-----
From: Louis van Alphen [mailto:lja@...]
Sent: Monday, June 05, 2000 7:24 AM
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
performing these operations from a client. MS SQL Server provides these

Something else that we have needed was the ability to have dynamic SQL
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... ;-)


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
South Africa

Take your development to new heights. Work with clients like Dell and
pcOrder. Submit your resume to jobs@.... Visit us at

To unsubscribe from this group, send an email to: