Deleting Phantom Tables (OpenInsight)
At 11 JUL 2000 01:09:56PM Tom Savell wrote:
Somehow when I was creating the tables in OI using the OI Table Builder, things got screwed up and the Table name was created in the Application Menu but the Table was never really created.
This left a problem. Now I have four Tables in the Application Manager under OpenInsight Tables which have the following behavior:
1) If I double click on the bad table the Table Builder screen appears but with "" in the top menu bar.
2) If I highlight the bad table select Entity and Delete, I get a message that says: "Entity BADTABLE is protected, inherited from another application, or does not exist. Deletion of this Entity is not allowed from the application APPLICATIONNAME."
3) If I attempt to delete the table from the System Editor command line with the command: RUN DELETE_TABLE "BADTABLE", "", "". I get the error: "The BADTABLE table does not exist."
I conclude that to clean this out of the system I will need to edit an OI system file. HELP!!
At 11 JUL 2000 01:46PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
We posted an answer to this in the main board.
[/i]World leaders in all things RevSoft[/i]
At 11 JUL 2000 11:37PM Donald Bakke wrote:
Tom,
Even though your problem was resolved, I thought it would be good for others to know what the solution was. Essentially the problem was related to the Database Defintion not having these particular tables included. Thus, when you logged back into OI the tables were not attached. When you tried to delete them they were not there. When you tried to create new ones of the same name in the same volume the system told you they already existed.
The solution, then, was to use Database Manager to add them and then use Database Manager to delete them. Then you were free to create new tables with the original names.
At 12 JUL 2000 11:42AM Tom Savell wrote:
Yes, and thanks for your help in fixing the problem.
Tom