Learning
Documentation
Community
Open Exchange
Global Masters
Home / Class Reference / %SYS namespace / %Library.ConstraintRelationship
Private  Storage   

%Library.ConstraintRelationship


Member class for relationship referential constraints and referential integrity actions. A relationship triggers a foreign key constraint based on the 1-cardinality relationship with a target key of %1. %1 is the implied unique key generated from the object ID (SQL ROWID).

Inventory


Parameters Properties Methods Queries Indices ForeignKeys Triggers
4


Summary


Methods
Check Delete SQLFKeyExists SQLFKeyRefAction


Methods


• classmethod Check(id As %RawString = "", lockonly As %Boolean = 0) as %Status
Method to Check foreign key for existence. If lock is TRUE then the object referenced by the key value is also locked. If the reference does not exist or, if locking is requested and the lock fails then an error message is returned.
• classmethod Delete(id As %RawString = "", concurrency As %Integer = -1) as %Status
• classmethod SQLFKeyExists(%p... As %String) as %Status
• classmethod SQLFKeyRefAction(pSameTable As %Boolean = 0, k As %Integer, pNoLock As %Boolean = 0, %p... As %String) as %Status