Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.03 » View Incident Report |
Serious |
Reported By: Terry Swiers Reported On: 7/23/2010 For: Version 2.03 Build 17 |
CREATE TABLE "code" ( "StockCode" VARCHAR(20) COLLATE "ISL" DESCRIPTION 'Unique stock code (SKU)', "AltCode" VARCHAR(20) COLLATE "ISL" DESCRIPTION 'Alternate stock code (if non-blank must be unique)', "Mfr" VARCHAR(40) COLLATE "ISL" DESCRIPTION 'Manufacturer', "Model" VARCHAR(20) COLLATE "ISL" DESCRIPTION 'Model', "Descr" VARCHAR(128) COLLATE "ISL" DESCRIPTION 'Description of item', ... CONSTRAINT "PrimaryKey" PRIMARY KEY ("StockCode") ) select * from code where lower(descr) like '%neš%' select * from code where Descr contains 'neš*'
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |