Deleting a Phantom Table (OpenInsight Specific)
At 11 JUL 2000 01:07:39PM CT 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:44PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
The file is probably in the DBT record and needs to be deleted.
Don't believe anyone in the office has written an OI program to manipulate this as we usually use ARev to handle DBT editting.
Just load it up into ARev and you'll find it's simply a record containing SYSVOLUME and SYSTABLE information. Should be simple to remove the offending records. Just ensure you remove from both sections.
[/i]World leaders in all things RevSoft[/i]
At 18 JUL 2000 04:36AM Simon Wilmot wrote:
The easy way is to detach the table and run a Define_Database !!