<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1607" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=015335708-29022008><FONT face=Arial size=2>Dear
all,</FONT></SPAN></DIV>
<DIV><SPAN class=015335708-29022008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=015335708-29022008><FONT face=Arial size=2>I've got a rather
strange problem in QUICK. When I do a select in a quick screen and afterwards a
get via a key, quick doesn't use the key I tell it to use, but seems to use the
key in which I entered a value during my select. I'll try to explain the
situation:</FONT></SPAN></DIV>
<DIV><SPAN class=015335708-29022008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=015335708-29022008><FONT face=Arial size=2>I'm using a primary
record with multiple (segmented) indexes:</FONT></SPAN></DIV>
<DIV><SPAN class=015335708-29022008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=015335708-29022008><FONT face=Arial size=2>Record:
ORDERS</FONT></SPAN></DIV>
<DIV><SPAN class=015335708-29022008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=015335708-29022008><FONT face=Arial size=2>1. Primary (unique)
index segment: </FONT></SPAN><SPAN class=015335708-29022008><FONT face=Arial
size=2>ORD-NR</FONT></SPAN></DIV>
<DIV><SPAN class=015335708-29022008><FONT face=Arial size=2>2. Alternate
(unique) index segments: CLIENT-NR, ORD-NR</FONT></SPAN></DIV>
<DIV><SPAN class=015335708-29022008><FONT face=Arial size=2>3. Repeating index,
segment: TRANS-REF</FONT></SPAN></DIV>
<DIV><SPAN class=015335708-29022008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=015335708-29022008><FONT face=Arial size=2>The file is accessed
as follows:</FONT></SPAN></DIV>
<DIV><SPAN class=015335708-29022008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=015335708-29022008><FONT face=Arial size=2>FILE ORDERS PRIMARY
CLOSE</FONT></SPAN></DIV>
<DIV><SPAN class=015335708-29022008><FONT face=Arial size=2> ACCESS VIA
ORD-NR</FONT></SPAN></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=015335708-29022008> ACCESS
VIA CLIENT-NR</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=015335708-29022008> ACCESS
VIA TRANS-REF</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=015335708-29022008></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=015335708-29022008>Nothing
strange there. Now for the problem:</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=015335708-29022008></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=015335708-29022008>Using a Select
(not a FIND!) I'll step over the first two indexes (ORD-NR & CLIENT-NR)
and fill in a value in the field TRANS-REF.</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=015335708-29022008></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=015335708-29022008>Since this is
a very complex screen, in the PREUPDATE procedure the primary file is retrieved
again to avoid 'Record has been changed since you found
it'.</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=015335708-29022008>The retrieval command is
simple:</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=015335708-29022008></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=015335708-29022008>GET ORDER VIA
ORD-NR USING ORD-NR OF ORDER</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=015335708-29022008></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=015335708-29022008>Since this
record should always be there, no optional has to be used. But... when I check
out the 'accessok' after the GET statement, it is false! The record absolutely
still exists (no delete has been done) and when looking at the content of the
file ORDERS, after the GET statement, some other (random?) record is displayed.
It seems that Quick doesn't use my programmed index, but instead uses the index
of the field in which I put my select value.</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=015335708-29022008></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=015335708-29022008>Does anybody
recognizes this problem and, more important, does anybody has a solution for
this problem, without:</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=015335708-29022008>- adding
new indexes</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=015335708-29022008>- putting
'NOSELECT' on the TRANS-REF field</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=015335708-29022008></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=015335708-29022008>Thanks in
advance for your time and help,</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=015335708-29022008></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=015335708-29022008>Jeroen van der
Linde</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=015335708-29022008></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=015335708-29022008>-------------------------------------------------</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=015335708-29022008>Powerhouse
version: 7.10G1</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=015335708-29022008>OpenVMS
version: 7.3-1</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=015335708-29022008></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=015335708-29022008>All files are
RMS files</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=015335708-29022008>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=015335708-29022008>-------------------------------------------------</SPAN></FONT></FONT></DIV></SPAN></FONT></FONT></DIV></BODY></HTML>