Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Issue clearing Temp Table

Issue clearing Temp Table

(0) Share

Report

Posted on by Community Member

I've a while loop in dexterity where in I'm clearing a temp table and filling it up with some values. so my code is somewhat like this.

while i < 10 do
  clear table Test_Temp; {This error out with Invalid data for clear: 27. Message}
  //Filling the Test_Temp table  
end while;

clear table is error out. Test_Temp table isn't accessed and not initialized. But I'm not sure how can i add condition to clear table only if it is initialized.

Appreciate any help

Regards.

Himal

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

RE: Issue clearing Temp Table

Assuming it's a dexterity code.

Clearing a table removes the data currently in its table buffer. It doesn’t remove data from the actual table.

So I don't think you need a while loop, by just writing clear table 'Test_Temp' will clear the buffer.