Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 1.04 » View Incident Report |
Minor |
Reported By: Praveen Reported On: 7/13/2007 For: Version 1.04 Build 5 |
DBISAM ---------- CREATE TABLE IF NOT EXISTS "TEMP" ( "db_table_name" CHARACTER(30) NOT NULL, "level_num" INTEGER NOT NULL, "field_name" CHARACTER(30), PRIMARY KEY ("db_table_name","level_num") COMPRESS NONE LANGUAGE "ANSI Standard" SORT "Default Order" ); ELEVATEDB 1.04 B5 ----------------------- CREATE TABLE "TEMP" ( "db_table_name" VARCHAR(30) COLLATE "ANSI" NOT NULL, "level_num" INTEGER NOT NULL, "field_name" VARCHAR(30) COLLATE "ANSI", CONSTRAINT "PK" PRIMARY KEY ("db_table_name", "level_num") ) DBISAM ------ "SELECT DISTINCT db_table_name FROM TEMP" - returns distinct db_table_name. ELEVATEDB 1.04 B5 ----------------------- "SELECT DISTINCT db_table_name FROM TEMP" - doesn't work. All values are returned.
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |