[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Single key and multipart key in the same file (OpenInsight 32-bit Specific) ====
=== At 07 MAY 2003 07:27:52PM Wilhelm Schmitt wrote: ===
 
{{tag>"OpenInsight 32-bit Specific"}}
 
<QUOTE>
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
</QUOTE>
----

=== At 07 MAY 2003 08:12PM Donald Bakke wrote:  ===

<QUOTE>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

[url=http://www.srpcs.com]SRP Computer Solutions, Inc.[/url]



[img]http://www.srpcs.com/srpicon1.gif[/img]

</QUOTE>

----

=== At 07 MAY 2003 08:30PM Wilhelm Schmitt wrote:  ===

<QUOTE>Don,



when saving the new key part values (KEY 0, KEY1 etc), the TABLE BUILDER renumbers automatically to KEY 1, KEY2 etc.



Wilhelm

</QUOTE>

----

=== At 07 MAY 2003 08:40PM Wilhelm Schmitt wrote:  ===

<QUOTE>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

</QUOTE>

----

=== At 07 MAY 2003 11:10PM Donald Bakke wrote:  ===

<QUOTE>[i]when saving the new key part values (KEY 0, KEY1 etc), the TABLE BUILDER renumbers automatically to KEY 1, KEY2 etc.[/i]



Yep, you are right. Can you use TB_MAIN instead? I've tested that successfully.



dbakke@srpcs.com

[url=http://www.srpcs.com]SRP Computer Solutions, Inc.[/url]



[img]http://www.srpcs.com/srpicon1.gif[/img]

</QUOTE>

----

=== At 08 MAY 2003 10:53AM Wilhelm Schmitt wrote:  ===

<QUOTE>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

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=26167E1BE31658F185256D1F0080E505|View this thread on the  forum...]]