Jason,

Wouldn't this situation also be handled by allowing for dynamic table
and columns name in SP's?

A sample SP would read something like

CREATE PROCEDURE SOME_TABLESP(
TableName CHAR(31),
ColumnName1 CHAR( 31),
ColumnName2 CHAR( 31),
WhereClause Text
)
AS
declare variable var1 whatever;
declare variable var2 whatever;
BEGIN
FOR
SELECT @ColumnName1 , @ColumnName2
FROM @TableName
@WhereClause
INTO Var1, Var2
DO
{Perform some operation}
END
END

I think that this approach would be more "approachable" with respect to
implementation (there already have been requests for dynamic SPs) as
well as having some hope of cross-platform (ie. accross SQL Server)
support.

Just my .02


Sean

> -----Original Message-----
> From: Jason Wharton [mailto:jwharton@...]
> Sent: Thursday, June 15, 2000 8:30 PM
> To: IB-Architect@egroups.com
> Subject: [IB-Architect] Enhanced handling of EXECUTE
> PROCEDURE statement
>
>
> I would like to suggest an enhancement to the SQL
> capabilities of InterBase
> and wonder what the architectural feasibilities of them are.
>
> In the same way you can do this:
>
> INSERT INTO ATABLE ( <list of columns> )
> SELECT <list of columns>
> FROM ANOTHERTABLE
> WHERE <record selection criteria>
>
> I would like to be able to do this:
>
> EXECUTE PROCEDURE APROCEDURE ( <list of columns> )
> SELECT <list of columns>
> FROM ANOTHERTABLE
> WHERE <record selection criteria>
>
> What has to be done right now is to write an additional
> stored procedure
> with a FOR SELECT and then in it's loop call the EXECUTE PROCEDURE
> statement. This is really a pain to have to do and not only
> that you cannot
> dynamically adjust the where clause of the SELECT that determines the
> records filtered into the stored procedure because that part
> is actually in
> a stored procedure too.
>
> This seems like it should be a simple allowance but I wonder
> if there is
> anything more to it than meets the eye. I suspect it might
> have something to
> do with the EXECUTE PROCEDURE construct being able to return
> results whereas
> the INSERT statement does not.
>
> All comments and suggestions appreciated.
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
>
>
> --------------------------------------------------------------
> ----------
> Best friends, most artistic, class clown Find 'em here:
> http://click.egroups.com/1/5533/4/_/830676/_/961115474/
> --------------------------------------------------------------
> ----------
>
> To unsubscribe from this group, send an email to:
> IB-Architect-unsubscribe@onelist.com
>
>
>