SQL Yoga version 1.1.0 build 4 :: Visit website

Printer friendly version

command tblrelation_set

Sets a property of a Relationship Object.

command tblrelation_set pRelationA, pProp, pValue
Parameters
TypeNameDescription
Simple parameter. pRelationA Relationship Reference array or relationship name.
Simple parameter. pProp Property to retrieve.
Simple parameter. pValue Value to set property to.
OptionalSimple parameter. [pDBKey] Database Object relationship is associated with. Default is name returned by sqlyoga_getDefaultDatabase(). Only applicable if pRelationA is not a reference array.
Description

Properties:

cross-reference table: The name of the table that connects the left and right tables in a many-to-many relationship.

cross-reference table key for left table: A comma delimited list of field(s) used as the key that connects the cross-reference table to the left table. You can pass in a hard coded value using the format COL=VALUE, escaping and quoting VALUES as needed.

cross-reference table key for right table: A comma delimited list of field(s) used as the key that connects the cross-reference table to the right table. You can pass in a hard coded value using the format COL=VALUE, escaping and quoting VALUES as needed.

left table: The name of the left table in the relationship. This can also be thought of as the parent table.

left table key: A comma delimited list of field(s) used as the key in the left table.

name: The name of the Relationship object.

order by: The column to sort the records in the relationship by when they are retrieved from the database.

owner:

right table: The name of the right table in the relationship. This can also be thought of as the child table.

right table key: A comma delimited list of field(s) used as the key in the right table.

type: Type of relationship. one-to-many, one-to-one or many-to-many.

Return

empty