If true, the sql command will be ran through the administrator connection, which is set up using the configuration options db_username_admin and db_username_password; the normal host and database are used.
If the replication is enabled, it will use the remote admin connection.
Where False this gives the user a chance to re-edit the form and try again if the database refuses their commit.
It is possible to have dynamically selected table names in a dbobject, i.e. using a widget/field element to determine the table name during run time. However, this does add a certain amount of overhead to the application, so should only be enabled on dbobjects that require this feature. The default is disabled.
By default, values retrieved from
write the result into the named widget(s) expects a single name or multiple names spearated by spaces (ascii 32)
CDATA
If the containing DTD element should be updated with the result of the SQL when it is executed. This is mainly used for widgets with sql embedded in their values, where the container is not explicitly named. For example
<label><sql>SELECT 'foo';</sql></label>
Controls whether SQL error messages should be reported.
Indicates that the sql may cause writes to the database - useful where database replication is in use replication.