Hi,
As far as I know, metadata can't be passed as parameters to stored
procedures or triggers
If it's possible, you can define some triggers updating the corresponding
columns as the original one updates.

----- Original Message -----
From: "sd_webpage" <sd_webpage@...>
To: <ib-support@yahoogroups.com>
Sent: Sunday, January 27, 2002 12:12 PM
Subject: [ib-support] Is this possible in Interbase


> Hi again,
>
> Is this possible :
>
> I have a list of tables with corresponding fields in them to update.
> I would like to be able to dynamically update them using the
> tablename and fieldname as parameters.
>
> I have tried to create a stored procedure:
>
> CREATE PROCEDURE UPDATE_KEY_FIELD (
> ATABLENAME VARCHAR(50),
> AFIELDNAME VARCHAR(50))
> AS
> begin
> update
> :atablename
> set
> :afieldname = "XXX"
> where
> :afieldname = "TST"
> suspend;
> end
>
> but I can't get it to compile.
>
> Is it possible, or am I better served doing this up in delphi code
> and just using query components.
>
>
> I know that this can probably be implemented by Key Contraints within
> interbase, but the database I am working with is old and does not
> have any constraints inplace.
>
> Thanks in advance for any information ...
>
> Sandy
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>