EPUB | CHM | PDF

TPSQLTable.Properties.CanModify

Top Previous Next

Indicates whether an application can insert, edit, and delete data in a table.

Syntax:

property CanModify: Boolean;

Description:

Check the status of CanModify to determine if an application can modify a dataset in any way. If CanModify is True, the dataset can be modified. If CanModify is False, the table is read-only.

CanModify is set automatically when an application opens a table. If the ReadOnly property of a table component is True, then CanModify is set to False.

CanModify can also be False because:

      • Another application currently has exclusive write access to the table.
      • The table is read-only by database design.

Even if CanModify is True, it is not a guarantee that a user will be able to insert or update records in a table. Other factors may come in to play, for example, SQL access privileges.