Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.14 » View Incident Report |
Serious |
Reported By: Adam Brett [Tropical Wholefoods] Reported On: 9/18/2013 For: Version 2.11 Build 3 |
Run the following script: SCRIPT BEGIN EXECUTE IMMEDIATE ' CREATE TABLE "Activities" ( "ID" INTEGER NOT NULL, "PersonID" INTEGER, "Name" VARCHAR(100) COLLATE "ANSI", CONSTRAINT "PrimaryKey" PRIMARY KEY ("ID") ) '; EXECUTE IMMEDIATE ' CREATE VIEW A_NameList as SELECT PersonID, LIST(Name) as NameList FROM Activities GROUP BY PersonID ORDER BY PersonID '; EXECUTE IMMEDIATE ' ALTER TABLE Activities RENAME COLUMN PersonID TO AuthorID ' ; END; Now use the EDBMgr IDE to open the view A_NameList, you will receive an error message "Field PersonID does not exist" Now Run the following script SCRIPT BEGIN EXECUTE IMMEDIATE ' DROP VIEW A_NameList '; EXECUTE IMMEDIATE ' DROP TABLE Activities '; END You will receive an error message again. It is possible to ALTER the view to remove the incorrect field, but not to drop it.
This web page was last updated on Wednesday, October 30, 2024 at 11:41 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |