table name as parameter

[FerCastro]

Hello

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

Something like.

update
:p_TableName
set
...
...

?

Thanks

[AlexP]

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;

[FerCastro]

I will try, thanks a lot