EPUB | CHM | PDF

TPSQLTable.Properties.ReadOnly

Top Previous Next

Specifies whether a table is read-only for this application.

Syntax:

property ReadOnly: Boolean;

Description:

Use the ReadOnly property to prevent users from updating, inserting, or deleting data in the table. By default, ReadOnly is False, meaning users can potentially alter a table's data.

Even if ReadOnly is False, users may not be able to modify or add data to a table. Other factors, such as insufficient SQL privileges for the application or its current user may prevent successful alterations.

To guarantee that users cannot modify or add data to a table:

      • Set the Active property to False.
      • Set ReadOnly to True.

When ReadOnly is True, the table's CanModify property is False.