<HTML dir=ltr><HEAD>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6000.16609" name=GENERATOR>
<STYLE>
<!--
font-face
{font-family:Tahoma;}
font-face
{font-family:"Trebuchet MS";}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.E-mailStijl17
{
font-family:Arial;
color:navy;}
div.Section1
{page:Section1;}
-->
</STYLE>
</HEAD>
<BODY lang=NL vLink=purple link=blue>
<DIV id=idOWAReplyText3172 dir=ltr><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">Dear Jeroen,</SPAN></FONT></DIV>
<DIV dir=ltr><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </DIV>
<DIV dir=ltr><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">You may ask Cognos support to work on this but I expect they will point you to Cognos Consultancy.</SPAN></FONT></DIV>
<DIV dir=ltr><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">The way you describe it, is to </SPAN></FONT><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">my opinion standard expected PowerHouse behavior.</SPAN></FONT></DIV>
<DIV dir=ltr><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </DIV>
<DIV dir=ltr><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">- As you mention, a Select is not a Find;</SPAN></FONT></DIV>
<DIV dir=ltr><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">- The select on TRANS-REF will build a set of rows that matches the value you entered;</SPAN></FONT></DIV>
<DIV dir=ltr><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">- It looks as if your screen is -when retrieving- automatically going to pre-, update and postupdate;<BR>- This updates forces an update next, and that means you will jump tot the next row that matches your selection criterea;</SPAN></FONT></DIV>
<DIV dir=ltr><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">- And, the select forces that the get in the preupdate is not done. The accessok will always be false.</SPAN></FONT></DIV>
<DIV dir=ltr><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </DIV>
<DIV dir=ltr><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">The re-retrieve to get rid of <FONT face=Arial size=2>'Record has been changed since you found it' is a bit risky. <BR>I would try to use different paths and write your own find procedure to get the data you wish and to make a different get in preupdate work.</FONT></SPAN></FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2><SPAN style="FONT-SIZE: 12pt">But, this all said, there are a few others in this mailing list who are at least able to clarify the why of PowerHouse more then me.</SPAN></FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2><SPAN style="FONT-SIZE: 12pt">Yes, write your own find in a complex screen with different type of files takes time.</SPAN></FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2><SPAN style="FONT-SIZE: 12pt">Regards,</SPAN></FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2><SPAN style="FONT-SIZE: 12pt"><BR>Bert</SPAN></FONT></DIV>
<P><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"> </P>
<DIV dir=ltr>
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</DIV></SPAN></FONT>
<DIV>
<DIV class=Section1>
<DIV>
<P class=MsoNormal><B><FONT face=Tahoma size=2><SPAN style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">Van:</SPAN></FONT></B><FONT face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> powerh-l-bounces+f.tang=piramide.nl@lists.sowder.com [mailto:powerh-l-bounces+f.tang=piramide.nl@lists.sowder.com] <B><SPAN style="FONT-WEIGHT: bold">Namens </SPAN></B>Jeroen van der Linde<BR><B><SPAN style="FONT-WEIGHT: bold">Verzonden:</SPAN></B> vrijdag 29 februari 2008 10:36<BR><B><SPAN style="FONT-WEIGHT: bold">Aan:</SPAN></B> powerh-l@lists.sowder.com<BR><B><SPAN style="FONT-WEIGHT: bold">Onderwerp:</SPAN></B> QUICK using unexpected index</SPAN></FONT></P></DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Dear all,</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">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:</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I'm using a primary record with multiple (segmented) indexes:</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Record: ORDERS</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">1. Primary (unique) index segment: ORD-NR</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">2. Alternate (unique) index segments: CLIENT-NR, ORD-NR</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">3. Repeating index, segment: TRANS-REF</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">The file is accessed as follows:</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">FILE ORDERS PRIMARY CLOSE</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> ACCESS VIA ORD-NR</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> ACCESS VIA CLIENT-NR</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> ACCESS VIA TRANS-REF</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Nothing strange there. Now for the problem:</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">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></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">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></P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">The retrieval command is simple:</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">GET ORDER VIA ORD-NR USING ORD-NR OF ORDER</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">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></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Does anybody recognizes this problem and, more important, does anybody has a solution for this problem, without:</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">- adding new indexes</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">- putting 'NOSELECT' on the TRANS-REF field</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Thanks in advance for your time and help,</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Jeroen van der Linde</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">-------------------------------------------------</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Powerhouse version: 7.10G1</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">OpenVMS version: 7.3-1</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">All files are RMS files</SPAN></FONT></P></DIV>
<DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">-------------------------------------------------</SPAN></FONT></P></DIV></DIV></DIV></DIV></BODY></HTML>