Creating Progress statement to change fields in the database.

Griff1324

New Member
I am pretty much a complete noob to Syteline (using 6.01) and Progress. I need to create a statement that will allow me to remove the list prices (field unit-price1) from the item pricing table. However, the list prices should only be removed for the following product codes 0501-6501, 6810-6843, 7000-7151, and 1001-1004 found in the item master table. I also need to clear out the effective date (field effect-date) for these same items.

All help is greatly appreciated!

Thanks,

Chris Simmons
 
Back
Top