I have developed a UDT and using as a lookup table for UDF in Sales Order Entry. Prior to updating the table with new look up values my script is:
Do until oUDT.Eof = 1
retVal = oUDT.GetValue("UDF_SHIP_VIA$",Via)
if Via <> "" then
Counter = Counter +1
ocsVal = oScript.DebugPrint("UDT Delete Count: " & Counter)
retVal = oUDT.Delete()
end if
retVal = oUDT.MoveNext()
Loop
The End of File value is 1 and no records are deleted.
I have tied the purge script to: PostLoad and OnExit of forms, a link button, table prewrite and table load. Nothing is working.