Single key and multipart key in the same file (OpenInsight 32-bit Specific)
At 07 MAY 2003 07:27:52PM Wilhelm Schmitt wrote:
I would like to define a dictionary with the following keys:
COMPLETE_KEY (identical to @id, example "ABC*DEF*GHI")
TYPE keypart 1 (example "ABC")
FILE keypart 2 (example "DEF")
FIELD keypart 3 (example "GHI")
The dictionary (TABLE_BUILDER) reorders automatically into
KEY 1 COMPLETE_KEY
KEY 2 TYPE
KEY 3 FILE
KEY 4 FIELD
I would like to work the AREV style, where I can use COMPLETE_KEY or the multipart key.
Regards
Wilhelm
At 07 MAY 2003 08:12PM Donald Bakke wrote:
Wilhelm,
Just go into the detail screen for each field and change the Key part number to whatever you want. Use 0 for COMPLETE_KEY.
dbakke@srpcs.com
At 07 MAY 2003 08:30PM Wilhelm Schmitt wrote:
Don,
when saving the new key part values (KEY 0, KEY1 etc), the TABLE BUILDER renumbers automatically to KEY 1, KEY2 etc.
Wilhelm
At 07 MAY 2003 08:40PM Wilhelm Schmitt wrote:
Forgot to mention:
This happens on the workstation with Table Builder ver. 3.1, running OI 4.1.2 with WAN setting to a server running OI 4.1.3
Wilhelm
At 07 MAY 2003 11:10PM Donald Bakke wrote:
when saving the new key part values (KEY 0, KEY1 etc), the TABLE BUILDER renumbers automatically to KEY 1, KEY2 etc.
Yep, you are right. Can you use TB_MAIN instead? I've tested that successfully.
dbakke@srpcs.com
At 08 MAY 2003 10:53AM Wilhelm Schmitt wrote:
Don,
I found that I have a version problem. With OI413 defining KEY0, KEY1 etc. is no problem.
(We also went the other way, editing the position in the DICT entry of the key fields directly and the corresponding entries in the %fields% record.)
Regards
Wilhelm