![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.03 » View Incident Report |
![]() |
Reported By: Terry Swiers Reported On: 7/26/2010 For: Version 2.03 Build 17 |
CREATE TABLE "code" ( "StockCode" VARCHAR(20) COLLATE "UNI" DESCRIPTION 'Unique stock code (SKU)', "AltCode" VARCHAR(20) COLLATE "UNI" DESCRIPTION 'Alternate stock code (if non-blank must be unique)', "Mfr" VARCHAR(40) COLLATE "UNI" DESCRIPTION 'Manufacturer', "Model" VARCHAR(20) COLLATE "UNI" DESCRIPTION 'Model', "Descr" VARCHAR(128) COLLATE "UNI" DESCRIPTION 'Description of item', .... CONSTRAINT "PrimaryKey" PRIMARY KEY ("StockCode") ) ALTER TABLE "code" ALTER COLUMN "StockCode" AS VARCHAR(40) COLLATE "UNI" DESCRIPTION 'Unique stock code (SKU)', ALTER COLUMN "Descr" AS VARCHAR(250) COLLATE "UNI" DESCRIPTION 'Description of item'
This web page was last updated on Tuesday, June 3, 2025 at 08:21 AM | Privacy Policy![]() © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |