I created a file using Table_Builder. In fact, I created two files in Table Builder, because I could not find the first one. I have since found them both.

I created a file – let's call it FILE_A – in database MYDB while I was logged in as user USER1.

When I went to define column definitions I could not find the file in the popup. There did appear to be a file called USER1, but when I went to open it, I got an error: no dictionary.

I created the second file – let's call it FILE_B – in the same database.

Going to define column definitions, I now have TWO files named USER1 in the popup.

Going to the System Editor, the Edit Record drop-down shows two files named USER1@FILE_A and USER1@FILE_B.

Looking at the volume via LIST_VOLUME, I see two tables assigned to MYDB: USER1@FILE_A and USER1@FILE_B.

Problems:

1) The popup does not display the filename. Thus, I've created a file that I cannot access.

2) There is no way to choose whether or not the system should append the user id to the filename. Thus there is no way to create a table of global interest.

3) The undocumented function RENAME_TABLE cannot rename the table. It returns the message 'FS145: The "" table does not exist.' regardless of whether the user id is included or not.

Are other people experiencing this series of problems, or are we unique?

Wayne

Wayne,

What version of OI are you using?

Sean

7.1.

Wayne

Wayne,

The username is placed when the table is being built by someone without System Administrator rights. The file will not display in the popup, but as a workaround you can access the file by right clicking on the file in the Database Manager. In the Database Manager, a right click on a selected table will open the Table Builder and load the dictionary.

By the way, the RENAME_TABLE is documented in the help.

Sean

Thanks for the reminder about the help. I usually go to the programmers reference manual for knowledge, but that hasn't been updated in quite a while so far as I know.

When I right click on the file name in database manager, I get a LIST_VOLUME, not TABLE_BUILDER. Did I not get something installed properly?

Wayne

An explanation:

Right-click does not response to the item you are right-clicking on. First you must SELECT a line in the Database Manager files list and then you can right-click ANYWHERE in the box and it will respond according to the line you previously selected. No matter what I right-clicked on, I was getting the volume list because I had previously left-clicked on the volume line in order to get it to display the list of files in the volume. It was still selected and although I was right-clicking on the file, it was responding to the selected volume line. This is sort of a bug, but once learned can be dealt with.

View this thread on the Works forum...