Indicates whether the database underlying a dataset permits write access to data.
Syntax:
property CanModify: Boolean;
Description:
Examine CanModify to determine if the database underlying a dataset permits write access to data. When a database connection is established, a dataset typically requests write access. CanModify indicates whether or not write access is granted. If CanModiy is True, data can be modified and written to the database server. If CanModify is False, data can be viewed, but not modified.
You can set RequestLive property of TMySQLQuery component to True to try to get "live" (updatable) resultset from SQL query.
See also: TMySQLQuery.RequestLive property