In order to bring you the best possible user experience, this site uses Javascript. If you are seeing this message, it is likely that the Javascript option in your browser is disabled. For optimal viewing of this site, please ensure that Javascript is enabled for your browser.
Login  |   On Demand  |   Home  |   qad.com




Creating a Standard Business Object
Use the following steps to create a new business object that references data from standard QAD Enterprise Applications tables.
1
In the left-hand Business Objects frame, click New. The Business Object definition screen displays.
2
Enter values as described in step 3 under Modifying Business Objects.
3
Use the Tables button to add tables to the object. Click OK to save the table definitions.
4
After the new tables appear as data objects in the navigation tree, click on Validate to test the new business object tree.
If you receive warnings, use the instructions in Validating and Optimizing Business Objects to modify data watch settings.
5
Click Save to save the new object.
6
Ensure that all tables included in the new business object are active event types.
a
If the table is defined as an event type, all you need to do is follow the steps in Editing Source Application Event Types to activate it.
b
If the table is not already defined as an event type, follow the steps in Adding Source Application Event Types to add it. Then complete steps 7 and 8.
7
If your business object includes data from one or more tables that are not already in the subset of tables that includes triggers, you must add replication write and replication delete triggers to the QAD Enterprise Applications schema for each table.
a
Locate the following file and open it in a text editor:
MfgproInstallDir\qxtend\qxo\progress\mfgpro\src\df
\delta.df
b
Remove existing entries.
c
Add an entry for each new table you are activating. The name of the replication write trigger is based on the table name prefix with rw.t appended; the delete trigger appends rd.t. For example, to activate the abs_mstr table, create the absrw.t and absrd.t triggers.
UPDATE TABLE "abs_mstr"
TABLE-TRIGGER "REPLICATION-WRITE" NO-OVERRIDE PROCEDURE “absrw.t" CRC "?"
UPDATE TABLE "abs_mstr"
TABLE-TRIGGER "REPLICATION-DELETE" NO-OVERRIDE PROCEDURE "absrd.t" CRC "?"
d
Launch MFG/UTIL and choose Database|Load Database Schema (.df) File.
e
Connect to your QAD Enterprise Applications qaddb database.
f
Select the delta.df file you modified with the triggers and choose OK.
8
After adding schema triggers, you must compile the associated trigger files.
a
Create a compile list file named NewTriggers.wrk in:
QXOMFGsrvInstallDir\qxo\src
b
List all of the new trigger files that correspond to the triggers you are adding to the schema. In the previous example, the work file would list:
absrw.t
absrd.t
c
Launch MFG/UTIL and choose Programs|Compile Procedures. Compile the work file specifying the new compile list name.