Error Cancel

1. Roger Blanchard

   

   381 posts
   Registered:
   29 Jun 2018
   24 Aug 2021

   Link to this post

   
   
   I am getting the following error when trying to create a new record using a DatasetModel class.
   
   The LikeCodeRep is a calculated field in the ePrice temp table and added to the skip list.
   
   Unable to find sequence field  LikeCodeRep in table Price during SAVE-ROW-CHANGES. (11909)
   
   
   oPrice = NEW Osprey.Host.Price.PriceDatasetModel (). 
   
   oPrice:NewFilter("        6666", // itemnum
                    1, // packnum
                    9 // zonenum
                    ). 
   
          
   
   IF NOT oPrice:Price:Available THEN 
   DO: 
   oPrice:TrackingChanges = TRUE.
   oPrice:Price:Create(). 
   oPrice:Price:ItemNum = "        6666". 
   oPrice:Price:PackNum = 1.  
   oPrice:Price:ZoneNum = 1. 
   oPrice:SaveChanges().
   
   
   
   END.       
   

   Last modified on 24 Aug 2021 19:08 by Roger Blanchard
2. Roger Blanchard

   

   381 posts
   Registered:
   29 Jun 2018
   24 Aug 2021 in reply to Roger Blanchard

   Link to this post

   Backend-Stacktrace:
   SaveRowChanges Consultingwerk.OERA.DataAccess at line -1  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\OERA\DataAccess.r)
   CommitChanges Consultingwerk.OERA.DataAccess at line 1395  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\OERA\DataAccess.r)
   CommitChanges Consultingwerk.SmartFramework.SmartDataAccess at line 973  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\SmartFramework\SmartDataAccess.r)
   SaveBuffer Consultingwerk.OERA.DataAccess at line 4141  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\OERA\DataAccess.r)
   SaveChanges Consultingwerk.OERA.DataAccess at line 4185  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\OERA\DataAccess.r)
   SaveChanges Osprey.CustomClasses.OERA.OspreyDataAccess at line 195  (C:\ProgressWrk\OspreyVer117102\OspreyFramework\Osprey\CustomClasses\OERA\OspreyDataAccess.r)
   SaveChanges Consultingwerk.OERA.BusinessEntity at line 2071  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\OERA\BusinessEntity.r)
   SaveChanges Consultingwerk.OERA.BusinessEntity at line 2102  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\OERA\BusinessEntity.r)
   SaveChanges Consultingwerk.OERA.ServiceInterface at line 4727  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\OERA\ServiceInterface.r)
   SaveChanges Consultingwerk.OERA.ServiceInterface at line 4601  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\OERA\ServiceInterface.r)
   SaveChanges Consultingwerk.OERA.DatasetModelPerformer at line 1471  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\OERA\DatasetModelPerformer.r)
   SaveChanges Consultingwerk.OERA.DatasetModel at line 760  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\OERA\DatasetModel.r)
   C:\ProgressWrk\OspreyVer117102\OspreyHostBackend\Osprey\Host\Price\TestDatasetModelClass.p at line 129  (C:\ProgressWrk\OspreyVer117102\OspreyHostBackend\Osprey\Host\Price\TestDatasetModelClass.r)
   adecomm/_runcode.p at line 678  (adecomm/_runcode.r)
   C:\Progress\OpenEdge\oeide\eclipse\plugins\com.openedge.pdt.debug.core_11.7.8.00\abl\_debuglauncher.p at line 100  (C:\Progress\OpenEdge\oeide\eclipse\plugins\com.openedge.pdt.debug.core_11.7.8.00\abl\_debuglauncher.p)
   
   
     Table: ePrice
   
   
   
   ThrowDatasetErrors Consultingwerk.Util.DatasetHelper at line 4202  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\Util\DatasetHelper.r)
   
   SaveChanges Consultingwerk.OERA.DatasetModelPerformer at line 1477  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\OERA\DatasetModelPerformer.r)
   
   SaveChanges Consultingwerk.OERA.DatasetModel at line 760  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\OERA\DatasetModel.r)
   
   C:\ProgressWrk\OspreyVer117102\OspreyHostBackend\Osprey\Host\Price\TestDatasetModelClass.p at line 129  (C:\ProgressWrk\OspreyVer117102\OspreyHostBackend\Osprey\Host\Price\TestDatasetModelClass.r)
   
   adecomm/_runcode.p at line 678  (adecomm/_runcode.r)
   
   C:\Progress\OpenEdge\oeide\eclipse\plugins\com.openedge.pdt.debug.core_11.7.8.00\abl\_debuglauncher.p at line 100  (C:\Progress\OpenEdge\oeide\eclipse\plugins\com.openedge.pdt.debug.core_11.7.8.00\abl\_debuglauncher.p)
   
   
   
   Shown by:
   
   ShowErrorMessage Consultingwerk.Util.ErrorHelper at line 2725  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\Util\ErrorHelper.r)
   
   C:\ProgressWrk\OspreyVer117102\OspreyHostBackend\Osprey\Host\Price\TestDatasetModelClass.p at line 137  (C:\ProgressWrk\OspreyVer117102\OspreyHostBackend\Osprey\Host\Price\TestDatasetModelClass.r)
   
   adecomm/_runcode.p at line 678  (adecomm/_runcode.r)
   
   C:\Progress\OpenEdge\oeide\eclipse\plugins\com.openedge.pdt.debug.core_11.7.8.00\abl\_debuglauncher.p at line 100  (C:\Progress\OpenEdge\oeide\eclipse\plugins\com.openedge.pdt.debug.core_11.7.8.00\abl\_debuglauncher.p)
3. Mike Fechner

   

   319 posts
   Registered:
   14 Sep 2016
   Answered

   24 Aug 2021 in reply to Roger Blanchard

   Link to this post

   Looks like a few extra spaces around the field name LikeCodeRep in the error message. 
   
   Does your skip field list contain that field name with some extra spaces or tabs? I know that the attach-data-source method for instance does not like extra white spaces around field names. 
   
   Calculated fields don't need to be in the assign skip list at all - as they don't have a counter-part in the DB table.
4. Roger Blanchard

   

   381 posts
   Registered:
   29 Jun 2018
   24 Aug 2021 in reply to Mike Fechner

   Link to this post

   Hmm, I removed it from the skip list and no more error.
   
   Thanks...