At 03:43 AM 06-05-01 +0200, you wrote:

>I have a SP where I select a tablename and a fieldname from a view into
>char(31)-variables and then I do the statement
>delete from :DETAIL_TABLE where :DETAIL_FK_COLUMN=:PK_VALUE;
>but I can't compile the SP. Any ideas ?

Yes, you can't pass metadata as parameters to a stored procedure. It's not possible to write a "generic" SP that works for any old metadata object. It must refer specifically to an existing object (table, column, SP).

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________