Subject | how to set field to be updated via parameter [FB1.5]? |
---|---|
Author | peter_nn0 |
Post date | 2008-03-01T00:16:41Z |
Hi,
I have a table TDATA with fields S1,S2,S2... etc.
and want to create a stored procedure that updates a given field, which
name is provided as an input parameter.
So basically I need a stored procedure that has 2 input params -
FIELDNAME and FIELDVALUE, and makes something like
update TDATA set :FIELDNAME = :FIELDVALUE where ... ;
but it seems impossible to set the field name this way. Is it really
not possible, or I'm missing something?
Thanks,
Peter
I have a table TDATA with fields S1,S2,S2... etc.
and want to create a stored procedure that updates a given field, which
name is provided as an input parameter.
So basically I need a stored procedure that has 2 input params -
FIELDNAME and FIELDVALUE, and makes something like
update TDATA set :FIELDNAME = :FIELDVALUE where ... ;
but it seems impossible to set the field name this way. Is it really
not possible, or I'm missing something?
Thanks,
Peter