Easy code question

djswim

I haven't done development in forever. I'm working on a demo DB and just trying to change all the GPPG's in all the items to 'RAW MAT'. I'm failing miserably at this somehow.

Item."Gen. Prod. Posting Group" := 'RAW MAT';
COMMIT;

I've also tried:

1. Without the "COMMIT"
2. Without the "Item." (Item table is the data element in my report)
3. All sorts of unnecessarily complicated crap like "IF GPPG = '' THEN <code to insert value> ELSE ERROR('You suck')" Could someone please tell me what I'm missing?

Alex_Chow

You need to use MODIFY

djswim

I KNEW it was something like that. Thank you!