autoLockChildRows

Topic group  Example

Controls whether or not child rows are automaticallly locked (or unlocked) when a parent row is locked (or unlocked).

Property of

Rowset

Description

When true (the default), child rows are automatically locked when a parent row is locked.

When false, child rows are not locked when a parent row is locked.

The autoLockChildRows property can be used to turn off automatic locking of child rows in a data entry form when locking of the child rows is not needed.

A common use for this would be in a data entry form that uses a datamodule where an indexed parent child link is setup between a parent table and a lookup table.

Other rows in the parent table can be linked to the same lookup table rows.

If two users attempt to edit two different parent rows that are linked to the same lookup table row, the second user to attempt an edit will receive an error that the row is locked.

However, if the parent rowset's autoLockChildRows property is set to false, then the locking conflict would not occur as only the parent rows will be locked.