{{tag>category:"OpenInsight 32-Bit" author:"John Bouley" author:"Sean FitzSimons"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== Equates created for multi-part keys (OpenInsight 32-Bit) ====
=== At 26 SEP 2007 02:29:44PM John Bouley wrote: ===
 
 
<QUOTE>
I just noticed that the Equates created from the table builder assign a zero to key prompts even for multi-part keys. I assumed it would create equate key1 to 1, equate key2 to 2. Has it always been this way? What purpose is equating the key field(s) to zero?



Thanks,

John
</QUOTE>
----

=== At 26 SEP 2007 04:43PM Sean FitzSimons wrote:  ===

<QUOTE>John,



Yes, it has always equated keys to position 0.  The equates is created setting the TO as the Field number as defined in the %FIELDS% record in the Dictionary therefore:



EQU ID to 0

EQU F1 to 1

EQU F2 to 2.





Sean

</QUOTE>


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