Get statement

Tue, 19 Mar 2002 11:27: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_01C1CF39.0D636DB0
Content-Type: text/plain;
	charset="iso-8859-2"

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.

------_=_NextPart_001_01C1CF39.0D636DB0
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>sorry 
all,&nbsp; for 'it is fixed' please read ' it is NOT fixed',</DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
 <DIV align=left class=OutlookMessageHeader dir=ltr>-----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 </DIV>
 it is fixed in 710G4, 
 my keys are&nbsp; 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 [<A 
 href="mailto:Aci.Polajnar@rcc-irc.si">mailto:Aci.Polajnar@rcc-irc.si</A>] 
 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 &nbsp; get krckre viai krckre-id using 
 "3000052" opt &nbsp; if accessok &nbsp;&nbsp; then info "3000052 - OK - 1!" now res &nbsp; while retr krckre viai krckre-id using "9876543" 
 &nbsp; begin &nbsp;&nbsp;&nbsp; info 
 "9876543 - OK!" now res &nbsp; end &nbsp; get krckre viai krckre-id using "3000052" opt&nbsp; 
 &lt;----------- &nbsp; if accessok &nbsp;&nbsp; then info "3000052 - OK - 2!" now res &nbsp;&nbsp; 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&nbsp; "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! 
 -- &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 _\\///_ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 (' o-o ') _______________ooOo_( 
 )_oOoo_____________________________________ 
 Aci 
 Polajnar&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 Tel&nbsp;&nbsp; : +386(0)3 4274174 IS 
 Consultant&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 Fax&nbsp;&nbsp; : +386(0)3 4274198 Razvojni Center 
 Celje&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; e-mail: 
 acip@rcc-irc.si 3000 Celje, 
 Slovenia&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; URL&nbsp;&nbsp; 
 : <A href="http://www.rcc-irc.si" 
 target=_blank>http://www.rcc-irc.si</A>&nbsp; _______________oooO____Oooo______________________________________ 
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 (&nbsp;&nbsp; )&nbsp;&nbsp;&nbsp; (&nbsp;&nbsp; ) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 \ (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ) / &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 \_)&nbsp;&nbsp;&nbsp; (_/ 
 = = = = = = = = = = = = = = = = = = = = = = = = = = = = 
 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 
 <A href="http://lists.swau.edu/mailman/listinfo/powerh-l" 
 target=_blank>http://lists.swau.edu/mailman/listinfo/powerh-l</A> 
 This list is closed, thus to post to the list you must be a 
 subscriber. 
 This message may contain privileged and/or confidential 
 information.&nbsp; 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.&nbsp; Thank 
 you.</BLOCKQUOTE></BODY></HTML>

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_01C1CF39.0D636DB0--