Applies To
OraDynaset
Description
Returns whether or not the specified dynaset is updatable. Not available at
design time and read-only at run time.
Usage
if_updatable = oradynaset.Updatable
Remarks
Returns True if the rows in the specified dynaset can be updated and False
otherwise.
The updatability of the resultant dynaset depends on the Oracle SQL rules of
updatability, on the access you have been granted, and on the read-only flag of
the CreateDynaset method.
In order to be updatable, three conditions must be met:
the SQL statement must refer to a simple column list or to the entire column
list (*),
the SQL statement must not set the read-only flag of the options argument, and
Oracle must permit ROWID references to the selected rows of the query.
Any SQL statement that does not meet these criteria is processed, but the
results are not updatable and this property returns False.
Data Type
Integer (Boolean)