help me interpret %MY_KEY% (AREV Specific) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
[[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]]


==== help me interpret %MY_KEY% (AREV Specific) ====
=== At 13 MAY 2009 04:39:39PM James Foulkrod wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
Hi, I've been away from arev for a long time and am working with code written by someone else.  A program is failing on this read line:

read batchkey2 from dict.product, %MY_KEY%, 1 else 



MY_KEY is not a dictionary item in dict.product and it is not a variable set to anything in the program.  It looks to me like a sequential counter but beyond that I don't know how to fix it.



Any help will be appreciated.

Thanks

Jim
</QUOTE>
----

=== At 13 MAY 2009 04:53PM James Foulkrod wrote:  ===

<QUOTE>I mistyped, there are single quotes around %MY_KEY% so the code is

read batchkey2 from dict.product, '%MY_KEY%', 1 else



this code worked in AREV3.12 and is failing in AREV32



also, it comes after a successful read:

read batchkey from dict.product, '%SK%',1 else



thanks

</QUOTE>

----

=== At 13 MAY 2009 04:58PM James Foulkrod wrote:  ===

<QUOTE>I mistyped, there are single quotes around %MY_KEY% so the code is

read batchkey2 from dict.product, '%MY_KEY%', 1 else



this code worked in AREV3.12 and is failing in AREV32



also, it comes after a successful read:

read batchkey from dict.product, '%SK%',1 else



thanks

</QUOTE>

----

=== At 13 MAY 2009 05:07PM Richard Hunt wrote:  ===

<QUOTE>If, as you say, '%MY.KEY%' is in quotes, single or double, then it is a literal string and not a variable.  If this KEY does not exist in the folder then the ELSE part of the sentence will be executed. So...  I am not sure what the actual complaint is.

</QUOTE>

----

=== At 13 MAY 2009 10:28PM James Foulkrod wrote:  ===

<QUOTE>Without a successful read the routine fails and since %MY_KEY% is not a key or a field name in the dictionary dict.product the read does fail.  The product table has a single part key (KEY_NO).  In the AREV3.12 version the dict.product did not contain a %MY_KEY% key or field name but the read does not fail.  So, Is this another (AREV3.12) version of %SK% that will return the sequential key that is not permitted in AREV32?

</QUOTE>

----

=== At 14 MAY 2009 08:19AM Dave Harmacek wrote:  ===

<QUOTE>Rows in dictionaries that start with "%" don't show up in the various list dictionary routines.



Thus, you can create your own row in the dictionary for your own use.  



This "%MY_KEY%" probably wasn't copied from the ArevDOS conversion.  Can you go back and examine it?  Just get to the command line and enter 



EDIT DICT.filename %MY_KEY%



both to examine in ArevDOS, and to create a row in Arev32.



Dave

</QUOTE>

----

=== At 14 MAY 2009 09:31AM James Foulkrod wrote:  ===

<QUOTE>Right on.  No way I could have solved that on my own.

Thanks again Dave.

Jim

</QUOTE>


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