Deleting and inserting record in same table

(0) Share

Report

Posted on by Community Member

Dear all,

I m creating job for deleting and inserting modified filed value in main table . for this i create a one job it was working well for deleting and inserting single field value in main table correctly but while i modified multiple records i facing issue .. (first record will deleting and inserting then for next modified record will not delete previous record in main table and inserting modified filed values in main table ).

ttsbegin;
        while select inventTable
            where inventTable.ItemId == '10369535'
            join inventTableModule
            where inventTableModule.ItemId == inventTable.ItemId && inventTableModule.ModuleType == ModuleInventPurchSales::Sales
            join infocodeTable
            where infocodeTable.BBB_Warranty_Min <= inventTableModule.Price && infocodeTable.BBB_Warranty_Max >= inventTableModule.Price
            {
                select infocodeTableSpecific where infocodeTableSpecific.infocodeId == infocodeTable.infocodeId && infocodeTableSpecific.refRelation == inventTable.ItemId;
                if(!infocodeTableSpecific)
                {

                     delete_from infocodeTableSpecific where infocodeTableSpecific.refRelation == inventTable.ItemId;
                    }
                    infocodeTableSpecific.refRelation   = inventTable.ItemId;
                    infocodeTableSpecific.infocodeId    = infocodeTable.infocodeId;
                    infocodeTableSpecific.refTableId    = RBOInfocodeRefTableIdBase::RBOInventTable;
                    infocodeTableSpecific.sequence      = 0;
                    infocodeTableSpecific.inputRequired = NoYes::Yes;
                    infocodeTableSpecific.whenRequired = RBONoneAlwaysPositiveNegative::None;
                    infocodeTableSpecific.insert();

                }

            ttscommit;
    }

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Jesus R. ABASCAL 1,450 on at

Like (0)

Report

RE: Deleting and inserting record in same table

Is correct this line "if(!infocodeTableSpecific)"?

I think it should be if(infocodeTableSpecific) beacuse in the code if infocodeTableSpecific has record you can do an insert you should do an update.

Was this reply helpful? Yes No
Martin Dráb 236,320 Most Valuable Professional on at

Like (0)

Report
RE: Deleting and inserting record in same table

What are you trying to achieve by that? Why don't use simply update the records?

By the way, let me make your code snippet more readable, so others don't have to decipher it:

while select inventTable where inventTable.ItemId == '10369535' join inventTableModule where inventTableModule.ItemId == inventTable.ItemId && inventTableModule.ModuleType == ModuleInventPurchSales::Sales join infocodeTable where infocodeTable.BBB_Warranty_Min <= inventTableModule.Price && infocodeTable.BBB_Warranty_Max >= inventTableModule.Price { select infocodeTableSpecific where infocodeTableSpecific.infocodeId == infocodeTable.infocodeId && infocodeTableSpecific.refRelation == inventTable.ItemId; if (!infocodeTableSpecific) { delete_from infocodeTableSpecific where infocodeTableSpecific.refRelation == inventTable.ItemId; } infocodeTableSpecific.refRelation = inventTable.ItemId; infocodeTableSpecific.infocodeId = infocodeTable.infocodeId; infocodeTableSpecific.refTableId = RBOInfocodeRefTableIdBase::RBOInventTable; infocodeTableSpecific.sequence = 0; infocodeTableSpecific.inputRequired = NoYes::Yes; infocodeTableSpecific.whenRequired = RBONoneAlwaysPositiveNegative::None; infocodeTableSpecific.insert(); }

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Deleting and inserting record in same table

select infocodeTableSpecific where infocodeTableSpecific.infocodeId == infocodeTable.infocodeId && infocodeTableSpecific.refRelation == inventTable.ItemId;

if(!infocodeTableSpecific)

{

if suppose record is mismatch i want to delete that record and insert the record with modified value in main table ..

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Deleting and inserting record in same table

Hai Martin . here i m trying to delete mismatch record in main table and insert it in modified record for deleted record in main table

Was this reply helpful? Yes No