* .getDistributionCode() * 04/14/2008 Cecil Champenois. Note: The below code was causing a change to the * buffered Production Table. So, I added the additional condition of: * "IF the Distrib field doesn't equal what it should", then we change it. LOCAL lcMachine As Character lcMachine=LEFT(ALLTRIM(Production.Machine),2) DO CASE CASE ((lcMachine = "02") OR (lcMachine = "03") OR ALLTRIM(Production.Machine)="2404") IF Production.Distrib <> "02" REPLACE Production.Distrib WITH "02" ENDIF CASE ((lcMachine = "11") OR (lcMachine = "14") OR ALLTRIM(Production.Machine)="2406") IF Production.Distrib <> "14" REPLACE Production.distrib WITH "14" ENDIF CASE ((lcMachine = "09") OR (lcMachine = "26") OR (lcMachine = "28") ; OR (lcMachine = "29") OR (lcMachine = "37")OR (lcMachine = "38") ; OR (lcMachine = "39") OR (lcMachine = "25") OR (lcMachine = "27") ; OR ALLTRIM(Production.Machine)="2402") IF Production.Distrib <> "09" REPLACE Production.Distrib WITH "09" ENDIF OTHERWISE IF Production.Distrib <> "08" REPLACE Production.Distrib WITH "08" ENDIF ENDCASE>>How do I stop my program from causing a change to the buffered table?