AnyDAC
ContentsIndexHome
PreviousUpNext
TADBottomUpdateOptions.UpdateTableName Property

Specifies table name to use in SQL commands posting updates.

Group
Links

Use UpdateTableName property to specify database table name to use in automatically generated SQL commands. The name may be quoted. UpdateTableName must be specified before preparing / opening a dataset. 

Specifying UpdateTableName is required when AnyDAC cannot correctly determine a table to post updates to or when application needs:

  • to edit a result set obtained from a view or tables join;
  • to edit a result set obtained from a stored procedure or from other non-SELECT SQL construction;
  • to redirect updates posting to another table, than one specified in the SQL query.
property UpdateTableName: String;
What do you think about this topic? Send feedback!