PH Quick -- entering and displaying two different Order-Detai
l files on the same screen
Deskin, Bob
Bob.Deskin@Cognos.COM
Mon, 9 Sep 2002 13:48:47 -0400
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C25829.263F20D0
Content-Type: text/plain;
charset="iso-8859-1"
Here's how I understand your requirement:
you have two files where the records are in a one-to-one correspondence. In
other words, for each Order-Detail 1 record, there's a corresponding
Order-Detail 2 record. You have a cluster of Order_detail 1 record and would
like to see the corresponding Order-Detail 2 record. If this is the case,
you can set the Order Detail 2 file as a SECONDARY OCCURS WITH
Order-Detail-1. You'll also need an ACCESS statement such as
ACCESS VIA Order-Detail-2-key USING Order-Detail-1-item UNIQUE
The UNIQUE is very important. It tells QUICK to re-evaluate the retrieval
every time. Otherwise, QUICK establishes the retrieval mechanism based on
first retrieval and then does a GET NEXT down the chain if there is one.
This should work for repeating PRIMARY or DETAIL files. If you don't want
the user to enter data into the related file, make the fields DISPLAY.
Bob Deskin
PowerHouse Web Product Manager, Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA
-----Original Message-----
From: Rendell Requiro [mailto:rendell@agbus.com]
Sent: Monday, September 09, 2002 1:33 PM
To: powerh-l@lists.swau.edu
Subject: PH Quick -- entering and displaying two different Order-Detail
files on the same screen
I am trying to create a screen that receives an Order-Header record as
master. I have two similiar, but distinct Order-Detail files on this screen
(one is primary and the other is going to be something else -- don't know
what yet).
Order-Detail 1 file has fields for input on the screen. User will update
this file only.
I want to DISPLAY all matching records from file Order-Detail 2 (occurs 5)
on the same screen in a cluster below the data fields for file Order-Detail
1.
I have tried making Order-Detail 2 a designer, a detail, and a reference
file, but with no luck yet. When Detail 2 is a designer or detail, I do not
see any records on the screen when in Entry mode. When Detail 2 is a
reference file, I see my data while in Entry mode, but I only see the first
record repeated for the number of occurrences.
Any ideas or advice on this issue?
Rendell Requiro
AG Business Management, Inc.
rendell@agbus.com <mailto:rendell@agbus.com>
Rendell Requiro
AG Business Management, Inc.
rendell@agbus.com <mailto:rendell@agbus.com>
831-455-2355 x101 voice
831-455-2264 fax
www.agbus.com <http://www.agbus.com>
This message may contain privileged and/or confidential information. If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. Thank you.
------_=_NextPart_001_01C25829.263F20D0
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.00.3502.4373" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=674124317-09092002>Here's
how I understand your requirement:</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=674124317-09092002></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=674124317-09092002>you
have two files where the records are in a one-to-one correspondence. In other
words, for each Order-Detail 1 record, there's a corresponding Order-Detail 2
record. You have a cluster of Order_detail 1 record and would like to see the
corresponding Order-Detail 2 record. If this is the case, you can set the Order
Detail 2 file as a SECONDARY OCCURS WITH Order-Detail-1. You'll also need an
ACCESS statement such as </SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=674124317-09092002></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=674124317-09092002>ACCESS
VIA Order-Detail-2-key USING Order-Detail-1-item UNIQUE</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=674124317-09092002></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=674124317-09092002>The
UNIQUE is very important. It tells QUICK to re-evaluate the retrieval every
time. Otherwise, QUICK establishes the retrieval mechanism based on first
retrieval and then does a GET NEXT down the chain if there is
one.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=674124317-09092002></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=674124317-09092002>This
should work for repeating PRIMARY or DETAIL files. If you don't want the user to
enter data into the related file, make the fields DISPLAY.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=674124317-09092002>
<P><FONT face=Arial size=2>Bob
Deskin
</FONT><BR><FONT face=Arial size=2>PowerHouse Web Product Manager, Application
Development Tools, Cognos Inc.</FONT> <BR><FONT face=Arial
size=2>bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178</FONT>
<BR><FONT face=Arial size=2>3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON
K1G 4K9 CANADA</FONT> </P></SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Rendell Requiro
[mailto:rendell@agbus.com]<BR><B>Sent:</B> Monday, September 09, 2002 1:33
PM<BR><B>To:</B> powerh-l@lists.swau.edu<BR><B>Subject:</B> PH Quick --
entering and displaying two different Order-Detail files on the same
screen<BR><BR></DIV></FONT>
<DIV>
<DIV><FONT size=2>I am trying to create a screen that receives an Order-Header
record as master. I have two similiar, but distinct Order-Detail files
on this screen (one is primary and the other is going to be something else --
don't know what yet).</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Order-Detail 1 file has fields for input on the
screen. User will update this file only.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>I want to DISPLAY all matching records from file
Order-Detail 2 (occurs 5) on the same screen in a cluster below the data
fields for file Order-Detail 1. </FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>I have tried making Order-Detail 2 a designer, a detail, and
a reference file, but with no luck yet. When Detail 2 is a designer or
detail, I do not see any records on the screen when in Entry mode. When
Detail 2 is a reference file, I see my data while in Entry mode, but I only
see the first record repeated for the number of occurrences. </FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Any ideas or advice on this issue?</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Rendell Requiro<BR>AG Business Management, Inc.<BR><A
href="mailto:rendell@agbus.com">rendell@agbus.com</A><BR></FONT></DIV></DIV>
<DIV><FONT size=2>Rendell Requiro<BR>AG Business Management, Inc.<BR><A
href="mailto:rendell@agbus.com">rendell@agbus.com</A><BR>831-455-2355
x101
voice<BR>831-455-2264
fax<BR><A
href="http://www.agbus.com">www.agbus.com</A><BR></FONT></DIV></BLOCKQUOTE></BODY></HTML>
<BR>
<P><FONT SIZE=2 FACE="Arial">This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you.</FONT></P>
------_=_NextPart_001_01C25829.263F20D0--