Updatable Property

See Also

Example

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:

1. the SQL statement must refer to a simple column list or to the entire column list (*),
   
   
2. the SQL statement must not set the read-only flag of the options argument, and
   
   
3. 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)