![]() | Products |
| Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.14 » View Incident Report |
| 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, April 8, 2026 at 04:38 AM | Privacy Policy © 2026 Elevate Software, Inc. All Rights Reserved Questions or comments ? |

