Buffer table not deleting the entries

navisionerin

Hi guys, I ave written some code which should delete my buffer table before filling the entries in, but its not doing it.
Here's my code:


TempBuffer.DELETEALL;
ActualTable.SETRANGE("Type",ActualTable."Transaction Type"::"Bills");
TempBuffer.SETCURRENTKEY("Entity ID");
TempBuffer.SETRANGE("ID",Get(COMPANYNAME))
END;


Any ideas why?

kylehardin

Put this at the top of your code to see what it is doing:

MESSAGE(FORMAT(TempBuffer.COUNT));
TempBuffer.DELETEALL;
MESSAGE(FORMAT(TempBuffer.COUNT));

If the second message isn't zero, then you have a filter set somewhere on TempBuffer. Do this:

TempBuffer.RESET;
TempBuffer.DELETEALL;

RockWithNAV

@navisionerin - Make sure this trigger is getting executed where ever you writing this code. See the variable OR else I will say make the Tempbuffer RESET once and then check.