Increasing IN_Main.AUX3 (Details) from 250 to 500 characters

More information about inventory items is required to be stored in the database.  The attached plugin allows entry of up to 500 characters in the inventory details field. Note that the underlying table column (IN_Main.Aux3) must also be modified to be varchar(500) using this script:

ALTER TABLE IN_Main ALTER COLUMN Aux3 VARCHAR(500) NULL

Step-by-step guide

1. Download and save the attached plugin

2. Import the plugin into the database, save and logout of the database

3. Run the script as above

Related articles