Devart Forums

Posted: **Wed 14 Nov 2012 21:28**

Hello

Is it possible use a parameter name as table name un a update query object?

Something like.

update
:p_TableName
set
...
...

?

Thanks

Posted: **Thu 15 Nov 2012 08:53**

Hello,

You cannot pass table names in parameters, macros can be used for this, for example:

Code: Select all

  UniQuery1.SQL.Text := 'UPDATE &TABLE SET &FIELD = :VALUE';
  UniQuery1.MacroByName('TABLE').AsString := 'MyTable';
  UniQuery1.MacroByName('FIELD').AsString := 'MyField';
  UniQuery1.ParamByName('VALUE').AsString := 'MyValue';
  UniQuery1.Execute;

Posted: **Sun 18 Nov 2012 03:57**

I will try, thanks a lot

Devart Forums

table name as parameter

table name as parameter

Re: table name as parameter

Re: table name as parameter