Changing field sizes in apvenmast

Jay,

Theoretically, it's not a big deal to make this change:
- Change the element size in dbdef
- blddbdict
- dbreorg
- cobcmp

You would then need modify the maintenance screens (e.g. AP10, etc.) that update these fields, and recompile them.

HOWEVER -- PLEASE PROCEED WITH CAUTION !!!

What you are making is MODIFICATION to the BASE LAWSON DELIVERED PRODUCT. This can have SIGNIFICANT IMPACT on your ability to maintain Lawson. For example, since you have modified the standard Lawson tables, when you install an MSP you will need to use the manual installation process--you can no longer use the Automated process. You also have to be prepared that this change may be undone if any CTP changes the APVENMAST table and requires a dbreorg. You would need to intervene before the dbreorg and reapply your table modification.

Having said all of that (I just want you to be aware of the implications), this is a fairly common issue (longer addresses) and one which Lawson should have made in the base product a long time ago. So I understand your reasons for wanting to make the change.

You could do it less intrusively (i.e. reducing the risk of getting clobbered by an MSP) by creating some subordinate "longer address" tables which are joined to the primary APVENMAST/APVENADDR tables. You could then use some Design Studio forms to allow for entry into the longer address tables. Depending on why you're changing the addresses, you could clone the various programs (AP155, AP160, etc.) on which you want to present the longer addresses.

Good Luck!

In theory, would it be that "easy" do make the item description field longer in the item master?

I don't know who in their right mind thinks 30 characters is enough...

In theory yes, but not in practice.

The problem is that for other fields you would have to comb thru and change the references in wslib/* that define it.

Interesting thing is that Lawson gave *itself* the mechanism via element definitions to define it ONCE and then use "LIKE ..." syntax which the bismark pre-compiler then replaces with the appropriate PIC clause.