Share
Report
32I'm trying to use a temp table as the data source for a report. My challenge is that the table records are not clearing which is causing the number of labels that we end up printing to increase with every report run.
I've tried clear, delete and remove at the end of the below range phrase, but nothing is working. The temp table has one index with 4 columns as shown below. I've tried single table commands as well. My goal with the below snippet is to end up with either an empty or missing TAS_Packing_Labels_TEMP.
range clear table TAS_Packing_Labels_TEMP;
clear field 'SOP Number' of table TAS_Packing_Labels_TEMP;
clear field 'SOP Type' of table TAS_Packing_Labels_TEMP;
clear field 'Component Sequence' of table TAS_Packing_Labels_TEMP;
clear field 'Line Item Sequence' of table TAS_Packing_Labels_TEMP;
range start table TAS_Packing_Labels_TEMP;
fill field 'SOP Number' of table TAS_Packing_Labels_TEMP;
fill field 'SOP Type' of table TAS_Packing_Labels_TEMP;
fill field 'Component Sequence' of table TAS_Packing_Labels_TEMP;
fill field 'Line Item Sequence' of table TAS_Packing_Labels_TEMP;
range end table TAS_Packing_Labels_TEMP;
clear table TAS_Packing_Labels_TEMP;
What am I doing wrong?
All responses (
Answers (
