Information générale
Catégorie:
Codage, syntaxe et commandes
I was not getting a table to follow in a relation when I tried to relate them visually in the DE, so I tried to do it manually in the LOAD event. Here is the code:
oDataHandler.UseAgain("Schedule", "tSchedule")
SET ORDER TO audit_num
oDataHandler.UseAgain("pending", "tPending")
SET ORDER TO actnum
oDataHandler.UseAgain("assigned", "tAssigned")
SET ORDER TO toll
oDataHandler.UseAgain("account", "tAccount")
SET ORDER TO actnum
oDataHandler.UseAgain("Tracking", "tTracking")
SET ORDER TO audit_num
oDataHandler.UseAgain("Password", "tPassword")
SET ORDER TO emp_id
set step on
** pending relations
SET RELATION TO audit_num INTO tSchedule IN tPending ADDITIVE
SET RELATION TO audit_num INTO tTracking IN tPending ADDITIVE
SELECT tpending
SET ORDER TO actnum
SET RELATION TO TOLL INTO tAssigned IN tPending ADDITIVE
**assign relations
SET RELATION TO actnum INTO tAccount IN tAssigned ADDITIVE
The indexes are as follows:
Table Index
PENDING
**tracking relation
SET RELATION TO emp_id INTO tPassword IN tTracking ADDITIVE
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement