Finance | Project Operations, Human Resources, ...

While looping a temp table and after the loop, the records are disappeared from the temp table - need help

(0) Share

Report

Posted on by XPlusPlus

Hello,

I have a temp table that has a record for now (it may have more in different scenarios). I am doing a while loop on it to fill another temp table and here is the code looks like

while select tmpProjAdjustmentSale
            where tmpProjAdjustmentSale.TransId == tmpProjAdjustment.TransId
        {
            tmpProjAdjustmentCreateSale.clear();
            tmpProjAdjustmentCreateSale.RefRecId        = tmpProjAdjustmentCreate.RecId;
            tmpProjAdjustmentCreateSale.SaleRefRecId    = tmpProjAdjustmentSale.SaleRefRecId;
            tmpProjAdjustmentCreateSale.FundingSource   = tmpProjAdjustmentSale.FundingSource;
            tmpProjAdjustmentCreateSale.SalesPrice      = tmpProjAdjustmentSale.SalesPrice;
            tmpProjAdjustmentCreateSale.LineAmount      = -tmpProjAdjustmentSale.LineAmount;
            if (tmpProjAdjustment.AdjustmentType == ProjAdjustmentType::Revenue)
            {
                tmpProjAdjustmentCreateSale.SalesPrice  = -tmpProjAdjustmentSale.SalesPrice;
                tmpProjAdjustmentCreateSale.LineAmount  = -tmpProjAdjustmentSale.LineAmount;
            }
            tmpProjAdjustmentCreateSale.DefaultDimension = tmpProjAdjustmentSale.DefaultDimension;
            tmpProjAdjustmentCreateSale.insert();
            //select * from tmpProjAdjustmentSale;
            
        }

I am not sure if I am missing something here but when it finishes the loop then when I mouse hover or add the temp table to the watch window there is no record the record in the tmpProjAdjustmentSale disappears. tmpProjAdjustmentSale is a class level variable. Anything wrong in the code?

AX version: AX 2012 feature pack

Thanks!

All responses (3)

Answers (0)

Suggested answer

Suresh M. Parmar 340 on at

Like (0)

Report

RE: While looping a temp table and after the loop, the records are disappeared from the temp table - need help

Hi,

While select method will fetch the data until the record getting null(i.e, will execute up to satisfy the condition) after last iteration record will get blank, if you are going to check the record at last, it will display 0 RecId(a blank record).

docs.microsoft.com/.../while-select-statements

If you want the table records again then you need to write another while select for tmpProjAdjustmentSale

NOTE: For best practice use the same while select and execute your logic.

Thanks,

Suresh Parmar
Suggested answer

Martin Dráb 231,430 Most Valuable Professional on at

Like (0)

Report

RE: While looping a temp table and after the loop, the records are disappeared from the temp table - need help

Nothing is wrong with the code, just with the way how you check if the variable points to a data set with records.

What you see in the variable is just a single record; which one it depends on what you've assinged there. Because you iterated the table to the point that there are no records remaining, the currently loaded record is none.

Use a select statement to fetch data from the temporary table.
Suggested answer

Deepak Agarwal 8,566 on at

Like (0)

Report

RE: While looping a temp table and after the loop, the records are disappeared from the temp table - need help

Hi,

Pl try below

1. Use another while loop and use the info to show values stored in tmp table.

2. Double check the table type (Ideally both temp DB and Immomery should work here)

3. Call validateWrite before insert, there could be something that stopping to insert data in the table.

Community site session details

While looping a temp table and after the loop, the records are disappeared from the temp table - need help

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

Announcing Our 2025 Season 1 Super Users!

Kudos to the February Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

While looping a temp table and after the loop, the records are disappeared from the temp table - need help

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

Announcing Our 2025 Season 1 Super Users!

Kudos to the February Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates