TMyStoredProc.UpdatingTable Property

Specifies which table in a query is assumed to be the target for subsequent data-modification queries as a result of user incentive to insert, update or delete records.

Class

TMyStoredProc

Syntax

property UpdatingTable: string;

Remarks

the UpdatingTable property is used on Insert, Update, Delete or RefreshRecord (see also TCustomMyDataSet.Options) if appropriate SQL (SQLInsert, SQLUpdate or SQLDelete) is not provided.

If UpdatingTable is not set then the first table used in query is assumed to be the target.

If the query is addressed to the View then entire View is taken as a target for subsequent modifications.

All fields from other than target table have their ReadOnly properties set to True (if TCustomMyDataSet.Options is True).