Difference between revisions of "Object Changes"
From SDU
m |
m |
||
| Line 20: | Line 20: | ||
|- | |- | ||
|} | |} | ||
| − | |||
== Example OBJECT Statements == | == Example OBJECT Statements == | ||
| Line 52: | Line 51: | ||
}; | }; | ||
};</source> | };</source> | ||
| − | |||
'''Generated by Schema Designer when adding a custom COLUMN or TRIGGER to an existing table:''' | '''Generated by Schema Designer when adding a custom COLUMN or TRIGGER to an existing table:''' | ||
| Line 67: | Line 65: | ||
}; | }; | ||
};</source> | };</source> | ||
| − | |||
'''Generated manually when creating a new FACTORY:''' | '''Generated manually when creating a new FACTORY:''' | ||
| Line 82: | Line 79: | ||
}; | }; | ||
};</source> | };</source> | ||
| − | |||
== Example MODIFY Statements == | == Example MODIFY Statements == | ||
Revision as of 05:31, 26 July 2008
To make corrections or additions to this article, select the edit tab above.
To discuss or ask questions about this article, select the discussion tab above.
To discuss or ask questions about this article, select the discussion tab above.
Overview
| Statement | Description |
|---|---|
| OBJECT | Defines a new business object or changes to an existing object, such as the addition of ATTRIBUTES or TRIGGERS. These statements are generated by the Schema Designer and can be seen in the wsp.mods file. A new FACTORY must be created manually in a custom .mod file. |
| MODIFY | Defines a modification to existing ATTRIBUTES. These statements are generated by the Schema Designer and can be seen in the wsp.mods file. The Schema Designer is limited in its capabilities to modify default ATTRIBUTES which may will require manually creation in a custom .mod file. |
| MODIFY FACTORY | Defines a modification to a default FACTORY. These statements are created manually in a custom .mod file. |
Example OBJECT Statements
Generated by Schema Designer when creating a new table: <source lang="javascript">OBJECT zchg_type {
DISPLAY_NAME "Change Type";
ATTRIBUTES zchg_type {
delete_flag del SREL actbool
REQUIRED
{
ON_NEW DEFAULT 0;
};
description STRING 480;
sym STRING 100
REQUIRED
DISPLAY_NAME "symbol";
last_mod_dt DATE { ON_CI SET NOW; };
last_mod_by SREL cnt { ON_CI SET USER;
ON_NEW DEFAULT USER; };
};
FACTORY zchg_type {
STANDARD_LISTS {
MLIST OFF;
RLIST OFF;
};
FUNCTION_GROUP "change_mgr";
REL_ATTR id;
COMMON_NAME sym;
};
};</source>
Generated by Schema Designer when adding a custom COLUMN or TRIGGER to an existing table: <source lang="javascript">OBJECT cr {
ATTRIBUTES Call_Req {
zxfer_reason SREL zxfer_reason
DISPLAY_NAME "Transfer reason";
};
TRIGGERS {
POST_CI val_fieldupdate_site(persistent_id, audit_userid, CHANGED_ONLY, type) 57 FILTER(EVENT("UPDATE"));
};
};</source>
Generated manually when creating a new FACTORY: <source lang="javascript">OBJECT cr {
FACTORY zallcrs {
STANDARD_LISTS {
SORT_BY "open_date DESC, id DESC, status, priority DESC, ref_num";
MLIST OFF;
RLIST OFF;
};
FUNCTION_GROUP "call_mgr";
REL_ATTR persistent_id;
COMMON_NAME ref_num;
};
};</source>
Example MODIFY Statements
Generated by Schema Designer when changing a default ATTRIBUTE: <source lang="javascript">MODIFY cr status {
REQUIRED;
};</source>
Generated manually when making a change to a default ATTRIBUTE not possible in the Schema Designer: <source lang="javascript">MODIFY cr impact {
ON_NEW DEFAULT 2;
};</source>
