Create Object Ptr Link Dialog Help

Valentina Studio allows to create ObjectPtr links using a special dialog. You can invoke the dialog from the Schema Editor, by two ways:

• Through contextual menu of the database by Create → Link item.
• Through contextual menu of the table by Create → Link item.

The dialog provides a possibilities to setup properties of the link:

• Link Name – The name of the schema object.
• Link Kind – The kind of link. The current dialog allows to create three kinds of links:
  • Binary Link – Only for Valentina.
  • ObjectPtr Link – Only for Valentina.
  • Foreign Key Link – For any supported datasource.

• On Delete – The action, that specifies what should happens with Child-records when you delete a parent record in the linked table.

• Table – The name of the referencing table.
  • Power – The power of the link by the referencing table. For a binary link can be 1 or M.

• Referenced Table – The name of the referenced table.
  • Power – The power of the link by the referencing table. For a ObjectPtr link can be only 1.

• Fields of the Referencing Table – The list of the referencing fields of the link. For ObjectPtr Link as a referencing field may be only one field of ObjectPtr type. It will be created automatically for this kind of link.

• Fields of the Referenced Table – The list of the referenced fields of the link. For ObjectPtr Link as a referenced field may be only one field - the RecID field.

• Show SQL – Opens dialog, that shows a SQL query, that will be applied to the datasource, to create the link.