My challenge is I have to have differents amount of fields in my
update according the difference allowence for updating fields for
users.

--- In IBObjects@yahoogroups.com, "Alan McDonald" <alan@...> wrote:
>
> > I'm only going to put
> > UPDATE TABLENAME SET FIELD=VALUE
> > in the queryname.editsql.
> >
> > But I want to do it dynamic with variables for the datamodule
and for
> > the query.
> >
> > My challenge is the way to address the datamodulename.queryname
by
> > variables.
> >
> > I have tables for controlling the user access ex. which column
the
> > diff usergroup can update.
> >
> > Do you have any ideas how to address the
datamodulename.queryname by
> > variables?
> > Pia
>
> change it to
> UPDATE TABLENAME SET FIELD=:VALUE
> use
> ParamByName('VALUE').Aswhateverdatatype := myvalue;
>
> Alan
>