Oops, I have a file name with a dot in it, can't get rid of it (OpenInsight)
At 09 JUN 2000 02:50:46PM David Singer wrote:
3.7.2 Table Builder let me name a new file "Xfer.Anything"
Now there is a table called "DICT.XFER.ANYTHING" and a record in REVMEDIA called "ANYTHING*SYSPROG".
Naturally, Delete_table won't get rid of either, because the first has an illegal character and the second does not have a table associated with it.
1. How do I get rid of these two references?
2. Can Table Builder be "set" or "modified" to prevent my stupidity from getting the better of me?
David
At 10 JUN 2000 08:25PM WinWin/Revelation Technical Support wrote:
David-
run ALIAS_TABLE to the REVMEDIA of the subdirectory in question. Edit the file XREF.ANYTHING*your_app_name, and make a note of the REV file number.
Delete the row in revmedia, and delete the dos REVXXXXX files.
This should get rid of the problem.
Hope it helps-
Mike Ruane
At 13 JUN 2000 11:26AM David Singer wrote:
Mike-
Thanks for the advice. Unfortunately, there was no file "XFER.ANYTHING", which was my problem, essentially. I had a DICT.XFER.ANYTHING*SYSPROG showing in the database under Application Manager, and a physical file ANYTHING*SYSPROG on the disk (rev21056) as well as listed in the revmedia table.
With your help I got most of the damaged controlled, but not all.
Here's what I did:
1. I used the Database Manager to remover "DICT.XFER.ANYTHING" from the Application Manager list.
2. I dos-deleted the rev21056 files.
3. I could "empty" the row "ANYTHING*SYSPROG" in the revmdia table by using System Editor.
However, I cannot find a way to delete "ANYTHING*SYSPROG" from revmedia. I think I'm missing the knowledge of how to EDIT revmedia, yes?
David
At 13 JUN 2000 12:44PM WinWin/Revelation Technical Support wrote:
David-
To delete the entry in REVMEDIA, type
RUN DELETE_ROW 'REVMEDIA','ANYTHING*SYSPROG'
from the EXEC line in the system editor. It will delete it.
Hope it helps-
Mike Ruane
At 13 JUN 2000 04:49PM David Singer wrote:
Thanks, Mike! Somehow it's the "simple stuff" which is hard to relearn in moving on up.
David