OSGeo FDO Provider for ArcSDE > ArcSDE Limitations > 
Locking and Versioning
 
 
 

ArcSDE permits row locks or table versioning provided that the ID column, which uniquely identifies the row, is maintained by ArcSDE. If there is no ID column or the ID column is maintained by the user, ArcSDE does not permit row locking or table versioning to be enabled.

NoteIn ArcSDE you can either lock rows in a table or version a table, but you cannot do both at the same time. To do either, you must alter the table’s registration.

The following sections illustrate these three steps:

  1. The creation of a table.
  2. The alteration of the table registration to identify one of the column definitions as the row ID column and to enable row locking.
  3. The alteration of the table registration to disable row locking and to enable versioning.

Topics in this section

Comments?