refresh field value
Lorry Litman
LLitman@exchange.hsc.mb.ca
Thu, 10 Jun 2004 08:34:04 -0500
This is a multi-part message in MIME format.
--=_Part_57ce2f80$cb3a$4b28$911e$f95fbf8f8064
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable
Thank-you for the ideas. The qdesign books seemed to indicate that UNIQUE
could only be used with primary,secondary,detail files. I tried it anyway=
on
the reference file, it didn't give me an error, but, it also didn't seem =
to
change anything.
The following seems to work ok.
File section
file F reference &
transaction query for query,process
access via ....
using ...
Field section=20
02 field A of F DISPLAY
field B of F DISPLAY
field C of F DISPLAY
Procedure section
procedure designer 02
begin
run screen B passing temp...
get file F via... using... optional
display field A of F
display field B of F
display field C of F
end
-----Original Message-----
This e-mail and/or any documents in this transmission is intended for the=
address(s) only and may contain legally privileged or confidential infor=
mation. Any unauthorized use, disclosure, distribution, copying or dissem=
ination is strictly prohibited. If you receive this transmission in error=
, please notify the sender immediately and return the original.
--=_Part_57ce2f80$cb3a$4b28$911e$f95fbf8f8064
Content-Type: message/rfc822
Content-Transfer-Encoding: 8bit
From: Johnson, Harold A EDUC:EX
[mailto: Harold.A.Johnson@gems1.gov.bc.ca]
Sent: Wednesday, June 09, 2004 2:25 PM
To: 'Deskin, Bob'; chuck.reinke; Lorry Litman
Cc: PowerHouse listserver (E-mail)
Subject: RE: refresh field value
MIME-Version: 1.0
If the calling screen had the file defined as a PRIMARY and passed it as a
MASTER to the subscreen, the field would automatically get refreshed. I
tried putting the calling screen file as a SECONDARY, but that didn't
refresh the field automatically. Too bad.
I've had to put in extra "GET"s when doing this type of coding. Not a big
deal, but sometimes needs a few tries to get it right.
cheers
-----Original Message-----
--=_Part_57ce2f80$cb3a$4b28$911e$f95fbf8f8064
Content-Type: message/rfc822
Content-Transfer-Encoding: 8bit
From: powerh-l-admin@lists.sowder.com
[mailto: powerh-l-admin@lists.sowder.com]On Behalf Of Deskin, Bob
Sent: 2004 June 9 12:10 PM
To: chuck.reinke; Lorry Litman
Cc: PowerHouse listserver (E-mail)
Subject: RE: refresh field value
MIME-Version: 1.0
Possibly. UNIQUE tells QUICK to re-evaluate the retrieval each time the
GET is executed. This may or may not have the desired effect in this
case. As well, it may affect other retrievals the wrong way. It's
something that would have to be tried.
Bob
-----Original Message-----
--=_Part_57ce2f80$cb3a$4b28$911e$f95fbf8f8064
Content-Type: message/rfc822
Content-Transfer-Encoding: 8bit
From: chuck.reinke [mailto:chuck.reinke@sbcglobal.net]
Sent: June 9, 2004 12:02 PM
To: Deskin, Bob; Lorry Litman
Cc: PowerHouse listserver (E-mail)
Subject: Re: refresh field value
MIME-Version: 1.0
I've heard "It's what people know that ain't so that gets them in
trouble" but.. I seem to remember that using the UNIQUE option with a
GET verb could sometimes force a retrieval on a Reference file.
Chuck
----- Original Message -----
--=_Part_57ce2f80$cb3a$4b28$911e$f95fbf8f8064
Content-Type: message/rfc822
Content-Transfer-Encoding: 8bit
From: "Deskin, Bob" <Bob.Deskin@Cognos.COM>
To: "Lorry Litman" <LLitman@exchange.hsc.mb.ca>
Cc: "PowerHouse listserver (E-mail)" <powerh-l@lists.sowder.com>
Sent: Wednesday, June 09, 2004 8:10 AM
Subject: RE: refresh field value
MIME-Version: 1.0
> You may or may not get the "expected" results. Because of the
> automatic retrieval, if you do a GET F (the reference file) and then
> DISPLAY item OF F, QUICK may re-retrieve the original F record. This
> assumes that you're still within the same screen transaction (i.e.
> whatever QUICK started when the current entry or find sequence
> started).
>
> If you're going to do GETs and DISPLAYs, I would suggest trying a
> DESIGNER file. No, you won't get automatic retrieval, but you can
> still do lookups and displays. And if you need a retrieval after a
> FIND, use the POSTFIND procedure. By using a DESIGNER file, you won't
> run into QUICK's assumptions about reference files.
>
> Bob Deskin
> Senior 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: Lorry Litman [mailto:LLitman@exchange.hsc.mb.ca]
> Sent: June 9, 2004 10:56 AM
> To: Deskin, Bob
> Cc: PowerHouse listserver (E-mail)
> Subject: RE: refresh field value
>
>
> Is there any problems or anything to be aware of by doing a GET on the
> same file F in a numbered designer procedure? In other words, in the
> designer procedure I would run screen B, GET file F, display field.
> Thanx Lorry.
>
> -----Original Message-----
>
> This e-mail and/or any documents in this transmission is intended for
> the address(s) only and may contain legally privileged or confidential
> information. Any unauthorized use, disclosure, distribution, copying
> or dissemination is strictly prohibited. If you receive this
> transmission in error, please notify the sender immediately and return
> the original.
>
> 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.
>
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
> powerh-l@lists.sowder.com
> Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com
> Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
> http://lists.sowder.com/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a
> subscriber.
>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
--=_Part_57ce2f80$cb3a$4b28$911e$f95fbf8f8064--