Get statement
Boyle, Joe
Joe.Boyle@cognos.com
Tue, 19 Mar 2002 11:58:28 -0000
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_01C1CF3D.61E2C210
Content-Type: text/plain;
charset="iso-8859-2"
but is fixed in 8.10, 8.20 and 8.30
-----Original Message-----
From: Boyle, Joe [mailto:Joe.Boyle@cognos.com]
Sent: 19 March 2002 11:27
To: 'Aci Polajnar'; 'PowerHouse List'
Subject: RE: Get statement
sorry all, for 'it is fixed' please read ' it is NOT fixed',
-----Original Message-----
From: Boyle, Joe [mailto:Joe.Boyle@cognos.com]
Sent: 19 March 2002 11:19
To: 'Aci Polajnar'; 'PowerHouse List'
Subject: RE: Get statement
it is fixed in 710G4,
my keys are A, B, C, D
with a bad key 'G' I get,
A - OK - 1!
A - NOT OK - 2!
with a good key 'B' I get,
A - OK - 1!
B - OK!
A - OK - 2!
-----Original Message-----
From: Aci Polajnar [ mailto:Aci.Polajnar@rcc-irc.si
<mailto:Aci.Polajnar@rcc-irc.si> ]
Sent: 19 March 2002 09:46
To: 'PowerHouse List'
Subject: Get statement
Hi there!
I have troubles with an very simple screen looks like this:
scr x
file krckre designer
procedure designer xx nodata
begin
get krckre viai krckre-id using "3000052" opt
if accessok
then info "3000052 - OK - 1!" now res
while retr krckre viai krckre-id using "9876543"
begin
info "9876543 - OK!" now res
end
get krckre viai krckre-id using "3000052" opt <-----------
if accessok
then info "3000052 - OK - 2!" now res
else info "3000052 - NOT OK - 2!" now res
end
My platform is OPEN VMS 7.3, PH is 7.10G1 and krckre is
RMS file with unique index krckre-id. In my file I have an
existing id "3000052". Id "9876543" doesen't exists.
My problem is that the second get statement alvays fails if preceding
while retrieving loop doesen't find anything. I have already tried all
kinds of open and close options I can also ommit the first get statement,
with same result.
Anyone familiar with this???
Regards!
--
_\\///_
(' o-o ')
_______________ooOo_( )_oOoo_____________________________________
Aci Polajnar Tel : +386(0)3 4274174
IS Consultant Fax : +386(0)3 4274198
Razvojni Center Celje e-mail: acip@rcc-irc.si
3000 Celje, Slovenia URL : http://www.rcc-irc.si
<http://www.rcc-irc.si>
_______________oooO____Oooo______________________________________
( ) ( )
\ ( ) /
\_) (_/
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
<http://lists.swau.edu/mailman/listinfo/powerh-l>
This list is closed, thus to post to the list you must be a subscriber.
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.
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.
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_01C1CF3D.61E2C210
Content-Type: text/html;
charset="iso-8859-2"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-2">
<TITLE>RE: Get statement</TITLE>
<META content="MSHTML 5.00.2314.1000" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT size=2><FONT color=#0000ff><FONT face=Arial><SPAN
class=465065711-19032002>but is fixed in 8.10, 8.20 and
8.30</SPAN></FONT></FONT></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> Boyle, Joe
[mailto:Joe.Boyle@cognos.com]<BR><B>Sent:</B> 19 March 2002
11:27<BR><B>To:</B> 'Aci Polajnar'; 'PowerHouse List'<BR><B>Subject:</B> RE:
Get statement<BR><BR></DIV></FONT>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=566492511-19032002>sorry all, for 'it is fixed' please read ' it
is NOT fixed',</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> Boyle, Joe
[mailto:Joe.Boyle@cognos.com]<BR><B>Sent:</B> 19 March 2002
11:19<BR><B>To:</B> 'Aci Polajnar'; 'PowerHouse List'<BR><B>Subject:</B> RE:
Get statement<BR><BR></DIV></FONT>
<P><FONT size=2>it is fixed in 710G4,</FONT> </P>
<P><FONT size=2>my keys are A, B, C, D</FONT> </P>
<P><FONT size=2>with a bad key 'G' I get,</FONT> </P>
<P><FONT size=2>A - OK - 1!</FONT> <BR><FONT size=2>A - NOT OK - 2!</FONT>
</P>
<P><FONT size=2>with a good key 'B' I get,</FONT> </P>
<P><FONT size=2>A - OK - 1!</FONT> <BR><FONT size=2>B - OK!</FONT> <BR><FONT
size=2>A - OK - 2!</FONT> </P><BR><BR><BR>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From: Aci
Polajnar [<A
href="mailto:Aci.Polajnar@rcc-irc.si">mailto:Aci.Polajnar@rcc-irc.si</A>]</FONT>
<BR><FONT size=2>Sent: 19 March 2002 09:46</FONT> <BR><FONT size=2>To:
'PowerHouse List'</FONT> <BR><FONT size=2>Subject: Get statement</FONT>
</P><BR>
<P><FONT size=2>Hi there!</FONT> </P>
<P><FONT size=2>I have troubles with an very simple screen looks like
this:</FONT> </P>
<P><FONT size=2>scr x</FONT> </P>
<P><FONT size=2>file krckre designer</FONT> </P>
<P><FONT size=2>procedure designer xx nodata</FONT> <BR><FONT
size=2>begin</FONT> <BR><FONT size=2> get krckre viai krckre-id using
"3000052" opt</FONT> <BR><FONT size=2> if accessok</FONT> <BR><FONT
size=2> then info "3000052 - OK - 1!" now res</FONT> <BR><FONT
size=2> while retr krckre viai krckre-id using "9876543"</FONT>
<BR><FONT size=2> begin</FONT> <BR><FONT size=2>
info "9876543 - OK!" now res</FONT> <BR><FONT size=2> end</FONT>
<BR><FONT size=2> get krckre viai krckre-id using "3000052" opt
<-----------</FONT> <BR><FONT size=2> if accessok</FONT> <BR><FONT
size=2> then info "3000052 - OK - 2!" now res</FONT> <BR><FONT
size=2> else info "3000052 - NOT OK - 2!" now res</FONT>
<BR><FONT size=2>end</FONT> </P>
<P><FONT size=2>My platform is OPEN VMS 7.3, PH is 7.10G1 and krckre
is</FONT> <BR><FONT size=2>RMS file with unique index krckre-id. In my file
I have an</FONT> <BR><FONT size=2>existing id "3000052". Id "9876543"
doesen't exists.</FONT> </P>
<P><FONT size=2>My problem is that the second get statement alvays fails if
preceding</FONT> <BR><FONT size=2>while retrieving loop doesen't find
anything. I have already tried all</FONT> <BR><FONT size=2>kinds of open and
close options I can also ommit the first get statement,</FONT> <BR><FONT
size=2>with same result.</FONT> </P>
<P><FONT size=2>Anyone familiar with this???</FONT> </P>
<P><FONT size=2>Regards!</FONT> </P>
<P><FONT size=2>-- </FONT><BR><FONT
size=2>
_\\///_</FONT> <BR><FONT
size=2>
(' o-o ')</FONT> <BR><FONT size=2>_______________ooOo_(
)_oOoo_____________________________________</FONT> </P>
<P><FONT size=2>Aci
Polajnar
Tel : +386(0)3 4274174</FONT> <BR><FONT size=2>IS
Consultant
Fax : +386(0)3 4274198</FONT> <BR><FONT size=2>Razvojni Center
Celje e-mail:
acip@rcc-irc.si</FONT> <BR><FONT size=2>3000 Celje,
Slovenia
URL : <A href="http://www.rcc-irc.si"
target=_blank>http://www.rcc-irc.si</A> </FONT><BR><FONT
size=2>_______________oooO____Oooo______________________________________</FONT>
<BR><FONT
size=2>
( ) ( )</FONT> <BR><FONT
size=2>
\ ( ) /</FONT> <BR><FONT
size=2>
\_) (_/</FONT> </P>
<P><FONT size=2>= = = = = = = = = = = = = = = = = = = = = = = = = = =
=</FONT> <BR><FONT size=2>Mailing list: powerh-l@lists.swau.edu</FONT>
<BR><FONT size=2>Subscribe: "subscribe" in message body to
powerh-l-request@lists.swau.edu</FONT> <BR><FONT size=2>Unsubscribe:
"unsubscribe" in message body to powerh-l-request@lists.swau.edu</FONT>
<BR><FONT size=2><A href="http://lists.swau.edu/mailman/listinfo/powerh-l"
target=_blank>http://lists.swau.edu/mailman/listinfo/powerh-l</A></FONT>
<BR><FONT size=2>This list is closed, thus to post to the list you must be a
subscriber.</FONT> </P>
<P><FONT size=2>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></BLOCKQUOTE><BR>
<P><FONT face=Arial size=2>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></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_01C1CF3D.61E2C210--