Index: vhUnitTest/BL/Prod/OptiBox/TestHergroepeerVerzameldozen.cls.xml
===================================================================
diff -u -r29059 -r40123
--- vhUnitTest/BL/Prod/OptiBox/TestHergroepeerVerzameldozen.cls.xml (.../TestHergroepeerVerzameldozen.cls.xml) (revision 29059)
+++ vhUnitTest/BL/Prod/OptiBox/TestHergroepeerVerzameldozen.cls.xml (.../TestHergroepeerVerzameldozen.cls.xml) (revision 40123)
@@ -26,23 +26,22 @@
aTestName:%String
-%Status
aTestName:%String
-%Status
@@ -51,15 +50,15 @@
// SETUP
// Insert Verzameldoos-OptiData record
Do ..SQL("INSERT INTO Prod.OptiBox_OptiData (ObjRef) VALUES (?)",$ListBuild(..#VerzameldoosOptiDataRef))
- Set VerzameldoosOptiDataID = ..SQLScalar("SELECT ID FROM Prod.OptiBox_OptiData WHERE ObjRef=?", $ListBuild(..#VerzameldoosOptiDataRef))
+ #dim VerzameldoosOptiDataID As %String = ..SQLScalar("SELECT ID FROM Prod.OptiBox_OptiData WHERE ObjRef=?", $ListBuild(..#VerzameldoosOptiDataRef))
// Insert deelvolume-OptiData record
Do ..SQL("INSERT INTO Prod.OptiBox_OptiData (ObjRef) VALUES (?)", $ListBuild(..#DeelVolumeOptiDataRef))
- Set DeelVolumeOptiDataID = ..SQLScalar("SELECT ID FROM Prod.OptiBox_OptiData WHERE ObjRef=?", $ListBuild(..#DeelVolumeOptiDataRef))
+ #dim DeelVolumeOptiDataID As %String = ..SQLScalar("SELECT ID FROM Prod.OptiBox_OptiData WHERE ObjRef=?", $ListBuild(..#DeelVolumeOptiDataRef))
// Insert Verzameldoos-SnijData record
Do ..SQL("INSERT INTO Prod.OptiBox_SnijData (OptiData, OptiID) VALUES (?, ?)", $ListBuild(VerzameldoosOptiDataID, ..#OptimalisatieID))
- Set VerzameldoosSnijDataID = ..SQLScalar("SELECT ID1 AS ID FROM Prod.OptiBox_SnijData WHERE OptiData=?", $ListBuild(VerzameldoosOptiDataID))
+ #dim VerzameldoosSnijDataID As %String = ..SQLScalar("SELECT ID1 AS ID FROM Prod.OptiBox_SnijData WHERE OptiData=?", $ListBuild(VerzameldoosOptiDataID))
// Insert Deelvolume-SnijData record
#dim DeelVolumeReference = "L." _ ..#VerzameldoosOptiDataRef _ ".optidatanr." _ VerzameldoosOptiDataID
@@ -71,19 +70,17 @@
// CONTROLE
- Set DeelVolumeSnijDataParent = ..SQLScalar("SELECT Parent AS ID FROM Prod.OptiBox_SnijData WHERE ParentOptiDataViaReference = ?", $ListBuild(VerzameldoosOptiDataID))
+ #dim DeelVolumeSnijDataParent As %String = ..SQLScalar("SELECT Parent AS ID FROM Prod.OptiBox_SnijData WHERE ParentOptiDataViaReference = ?", $ListBuild(VerzameldoosOptiDataID))
Do $$$AssertEquals(DeelVolumeSnijDataParent, VerzameldoosSnijDataID)
- Set DeelVolumeSnijDataBoxParent = ..SQLScalar("SELECT BoxParent AS ID FROM Prod.OptiBox_SnijData WHERE ParentOptiDataViaReference = ?", $ListBuild(VerzameldoosOptiDataID))
+ #dim DeelVolumeSnijDataBoxParent As %String = ..SQLScalar("SELECT BoxParent AS ID FROM Prod.OptiBox_SnijData WHERE ParentOptiDataViaReference = ?", $ListBuild(VerzameldoosOptiDataID))
Do $$$AssertEquals(DeelVolumeSnijDataBoxParent, VerzameldoosSnijDataID)
- Set JuistePPSGroepEnSubgroepGevonden = ..SQLScalar("SELECT '1' AS ID FROM Prod.OptiBox_SnijData WHERE ID1=? AND PPSGroep='OL' AND PPSSubgroep='PRODUCT'", $ListBuild(VerzameldoosSnijDataID))
+ #dim JuistePPSGroepEnSubgroepGevonden As %String = ..SQLScalar("SELECT '1' AS ID FROM Prod.OptiBox_SnijData WHERE ID1=? AND PPSGroep='OL' AND PPSSubgroep='PRODUCT'", $ListBuild(VerzameldoosSnijDataID))
Do $$$AssertEquals(1, JuistePPSGroepEnSubgroepGevonden)
- Set DeelVolumeOptiDataParentID = ..SQLScalar("SELECT Parent AS ID FROM Prod.OptiBox_OptiData WHERE ObjRef=?", $ListBuild(..#DeelVolumeOptiDataRef))
+ #dim DeelVolumeOptiDataParentID As %String = ..SQLScalar("SELECT Parent AS ID FROM Prod.OptiBox_OptiData WHERE ObjRef=?", $ListBuild(..#DeelVolumeOptiDataRef))
Do $$$AssertEquals(VerzameldoosOptiDataID, DeelVolumeOptiDataParentID)
-
- Quit $$$OK
]]>