I have a rule in a object that says the following:
If COUNT Product WHERE (Product.Part_Number=ThisProduct.Part_Number AND Product.Application_Mode='NewVersion')<1 Then
Create Product WITH Product.Description_Long=ThisProduct.Description_Long,Product.Description_Short=ThisProduct.Description_Short,Product.x_extItems=ThisProduct.x_extItems,Product.Lead_Time_Default=ThisProduct.Lead_Time_Default,Product.List_Price=ThisProduct.List_Price,Product.Model_Number=ThisProduct.Model_Number,Product.Part_Number=ThisProduct.Part_Number,Product.Remark_History=ThisProduct.Remark_History,Product.Support_Person=ThisProduct.Support_Person,Product.X_Attachment=ThisProduct.X_Attachment,Product.X_Company_Supplier=ThisProduct.X_Company_Supplier,Product.X_Export_Item_Product=ThisProduct.X_Export_Item_Product,Product.X_Ref_Product_Family=ThisProduct.X_Ref_Product_Family,Product.X_Alert_Notification=ThisProduct.X_Alert_Notification,Product.Application_Mode='NewVersion',Product.Revision=ThisProduct.Revision+1
Pretty straight forward. I want to Edit the newly created Product. What do I need to do? Everytime I try to use some form of editing I always get the original Product versus the new Product. I am sure there must be a simple way to edit the new Product.
Help with Edit
Is there some reason why you can't use ENTER NEW
If COUNT Product WHERE (Product.Part_Number=ThisProduct.Part_Number AND Product.Application_Mode='NewVersion')<1 Then
ENTER NEW Product WITH Product.Description_Long=ThisProduct.Description_Long,Product.Description_Short=ThisProduct.Description_Short,Product.x_extItems=ThisProduct.x_extItems,Product.Lead_Time_Default=ThisProduct.Lead_Time_Default,Product.List_Price=ThisProduct.List_Price,Product.Model_Number=ThisProduct.Model_Number,Product.Part_Number=ThisProduct.Part_Number,Product.Remark_History=ThisProduct.Remark_History,Product.Support_Person=ThisProduct.Support_Person,Product.X_Attachment=ThisProduct.X_Attachment,Product.X_Company_Supplier=ThisProduct.X_Company_Supplier,Product.X_Export_Item_Product=ThisProduct.X_Export_Item_Product,Product.X_Ref_Product_Family=ThisProduct.X_Ref_Product_Family,Product.X_Alert_Notification=ThisProduct.X_Alert_Notification,Product.Application_Mode='NewVersion',Product.Revision=ThisProduct.Revision+1
If COUNT Product WHERE (Product.Part_Number=ThisProduct.Part_Number AND Product.Application_Mode='NewVersion')<1 Then
ENTER NEW Product WITH Product.Description_Long=ThisProduct.Description_Long,Product.Description_Short=ThisProduct.Description_Short,Product.x_extItems=ThisProduct.x_extItems,Product.Lead_Time_Default=ThisProduct.Lead_Time_Default,Product.List_Price=ThisProduct.List_Price,Product.Model_Number=ThisProduct.Model_Number,Product.Part_Number=ThisProduct.Part_Number,Product.Remark_History=ThisProduct.Remark_History,Product.Support_Person=ThisProduct.Support_Person,Product.X_Attachment=ThisProduct.X_Attachment,Product.X_Company_Supplier=ThisProduct.X_Company_Supplier,Product.X_Export_Item_Product=ThisProduct.X_Export_Item_Product,Product.X_Ref_Product_Family=ThisProduct.X_Ref_Product_Family,Product.X_Alert_Notification=ThisProduct.X_Alert_Notification,Product.Application_Mode='NewVersion',Product.Revision=ThisProduct.Revision+1
Rocketman
V8.7 Developer Edition. Server 2016 Standard edition. MySql 5.5
V8.7 Developer Edition. Server 2016 Standard edition. MySql 5.5