Subject RE: [IBO] Re: User access in delhi
Author Alan McDonald
> 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