|
|
|
Progress.Json.ObjectModel.JsonObject CreateSmartRelation (character, character, character, character, character, character, character, character, character, character, logical, logical)
|
Creates a SmartRelation record including the referential integrity rule
Notes : The parent and child table are resolved from their qualified Database.Table
names; the validation of the RelationBusinessEntity applies
@param pcParentTable The qualified name (Database.Table) of the parent table
@param pcChildTable The qualified name (Database.Table) of the child table
@param pcRelationName The name of the relation
@param pcRelationDescription The description of the relation
@param pcRelationFieldPair The comma-delimited field pairs (parent field, child field, ...)
@param pcParentRoleDescription The description of the role of the parent table
@param pcChildRoleDescription The description of the role of the child table
@param pcParentCardinality The cardinality of the parent table (1, 01, 01n, 1n), defaults to 1
@param pcChildCardinality The cardinality of the child table (1, 01, 01n, 1n), defaults to 01n
@param pcOnParentDelete The referential integrity rule (DoNothing, Cascade, Nullify, SetDefault, Restrict)
@param plDefaultParentRelation Logical value indicating if this is the default parent relation of the child table
@param plInactive Logical value indicating if the relation is inactive
@return JsonObject with the created SmartRelation record
*/
|
|
|
|
Progress.Json.ObjectModel.JsonObject DeleteSmartRelation (character, character, character)
|
Deletes a SmartRelation record
Notes : The relation is identified by parent table, child table and relation name
@param pcParentTable The qualified name (Database.Table) of the parent table
@param pcChildTable The qualified name (Database.Table) of the child table
@param pcRelationName The name of the relation
@return JsonObject describing the deleted relation
*/
|
|
|
|
Progress.Json.ObjectModel.JsonObject ImportDatabaseTables (character, character)
|
Registers database tables of a connected database in the SmartFramework
table maintenance (SmartTable)
Notes : Tables that are already registered are reported and left untouched
@param pcDatabaseName The logical database name
@param pcTableNames The comma-delimited list of the tables to register
@return JsonObject with the created SmartTable records and the names of the tables that were already registered
*/
|
|
|
|
Progress.Json.ObjectModel.JsonObject UpdateSmartRelation (character, character, character, character, character, character, character, character, character, character, character, logical, logical)
|
Updates a SmartRelation record including the referential integrity rule
Notes : The relation is identified by parent table, child table and relation name.
Only the arguments that are passed (character arguments that are not empty,
logical arguments that are not unknown) are written
@param pcParentTable The qualified name (Database.Table) of the parent table
@param pcChildTable The qualified name (Database.Table) of the child table
@param pcRelationName The name of the relation
@param pcNewRelationName The new name of the relation, empty to leave the name unchanged
@param pcRelationDescription The new description, empty to leave the field unchanged
@param pcRelationFieldPair The new comma-delimited field pairs, empty to leave the field unchanged
@param pcParentRoleDescription The new parent role description, empty to leave the field unchanged
@param pcChildRoleDescription The new child role description, empty to leave the field unchanged
@param pcParentCardinality The new parent cardinality (1, 01, 01n, 1n), empty to leave the field unchanged
@param pcChildCardinality The new child cardinality (1, 01, 01n, 1n), empty to leave the field unchanged
@param pcOnParentDelete The new referential integrity rule (DoNothing, Cascade, Nullify, SetDefault, Restrict), empty to leave the field unchanged
@param plDefaultParentRelation The new DefaultParentRelation flag, unknown to leave the field unchanged
@param plInactive The new Inactive flag, unknown to leave the field unchanged
@return JsonObject with the updated SmartRelation record and the list of the updated fields
*/
|
|
|
|
Progress.Json.ObjectModel.JsonObject UpdateSmartTable (character, character, character, character, character, character, character, character, character)
|
Updates the description and the record key definition of a SmartTable record
Notes : Only the arguments that are passed (not empty) are written, all other fields
of the record are left untouched
@param pcDatabaseName The logical database name
@param pcTableName The database table name
@param pcTableDescription The new TableDescription, empty to leave the field unchanged
@param pcDescriptionFields The new DescriptionFields, empty to leave the field unchanged
@param pcDescriptionFormats The new DescriptionFormats, empty to leave the field unchanged
@param pcDescriptionSubstitute The new DescriptionSubstitute, empty to leave the field unchanged
@param pcUniqueKeyFields The new UniqueKeyFields, empty to leave the field unchanged
@param pcUniqueKeyFormats The new UniqueKeyFormats, empty to leave the field unchanged
@param pcUniqueKeySubstitute The new UniqueKeySubstitute, empty to leave the field unchanged
@return JsonObject with the updated SmartTable record and the list of the updated fields
*/
|
