Here is a strange situation…
I want to delete rows manually in a table (TEMP_PRE).
Open TOOLS ]] DATABASE MANAGER, select the table (TEMP_PRE) with a double-click (the field names appear in the outline) - then select FILE ]] OPEN.
This opens the TABLE BROWSER (Isn't there a short-cut?), which tells me: No key columns detected. Unable to open table.
The SYSTEM EDITOR, on the other side, opens the table and lets me view each record of TEMP_PRE.
a) What did I do wrong?
b) How do I manually clear a file (or parts of it), without using AREVs TCL commands?
Thanks
Wilhelm
Wilhelm,
The Table Browser is an old tool that didn't always work and hasn't been supported for years.
And I'm not sure it's wise to give one's tables names starting with "TEMP_".
- Oystein -
FWIW .. I don't use Table Browser much at all for dict management. It has made more problems than it solves for me. I use AREV 3.12 to do these tasks. It has the added benefit of date/time stamping dict changes so it is easy to get the things that have been changed since …. for upgrades. Don't EVER name a table TEMP_something. TMP_something is OK.
Don Miller
C3 Inc.
Don,
is there a specific situation where AREV/OI drives crazy when handling files named TEMP_* or TEMP* ?
Wilhelm
Oystein,
what do you use for file/dict management?
Wilhelm
Wilhelm,
For dict management I use the Table Builder.
And my own tool that can (re)create a dict from specs in a text file. (It deletes the old data table and its dict and creates a new dict and an empty data table.) This tool is very convenient in a development and test phase. For me it's normally easier to make changes to a text file and rerun this tool than using the Table Builder. And easier to copy chunks of dict items between tables.
Some people copy dict items between tables with the System Editor.
And for data table management? I don't do it much, really. Except when I establish test data for my apps. Or data for tables with lists of e.g legal values. Then I use one of several import tools I've made. It's the same idea again: Create and maintain data in external text files and import to tables. One tool does delimited data:
134@George@Bush@President
One does labelled data:
ID:134
FIRSTNAME:George
LASTNAME:Bush
OCCUPATION:President
Etc.
For small changes to data tables I might use the System Editor.
But I agree a proper grid based tool like Table Browser could have been is a good idea.
- Oystein -
Wilhelm ..
Yes. When Form Designer or Table Builder load a dictionary, it creates a temp file prefixed by TEMP_. Then if any changes are made to dict items, the temp file is copied back and deleted. Table Builder is notorious for leaving this behind. Then the next time either tool is started the "Unable to load Dictionary" error occurs. Getting rid of the TEMP file is no simple task either.
HTH
Don C. Miller
C3 Inc.