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