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

Owned by Beth Blok (Unlicensed)
Aug 11, 2017
1 min read

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

SQL skills are required

Sound SQL skills are required to complete this task



  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