Re: No Report for Deleted Record

[Ted Barry <tbarry@xxxxxxxxxxxxxxxxxxxx>]

Jim, I looked it up online
(http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/QB3AGZ03/4.4.24) and it 
treats it as '1' if a record is found, but somehow the status of my
main read (SB220AP) is getting lost in the shuffle.

>>> Jim Langston <jimlangston@conexfreight.com> 01/26/01 03:46pm
>>>
Your code is looking at the %found condition returned by the
DELETE op code, not the CHAIN or READE op codes.  DELETE also
changes the %Found condition (no idea what it changes it to,
*ON if another record exists with same key?  *OFF if it successfully
deleted the record?  The DELETE help doesn't specify how it changes
it).

If you are trying to condition on the CHAIN and READE statements, then
move your if statements up before the DELETE op codes.  If you are
trying
to condition on the DELETE op code, I don't know what it changes the
%FOUND
to.

Regards,

Jim Langston


4.1.1.15 %FOUND (Return Found Condition)

     %FOUND{(file_name)} 

%FOUND returns '1' if the most recent relevant file operation found a
record, a string operation found a match, or a search operation found an
element. Otherwise,
this function returns '0'. 

The operations that set %FOUND are: 

     File operations: 

          "CHAIN (Random Retrieval from a File)" in topic 4.4.15 

          "DELETE (Delete Record)" in topic 4.4.24 

          "SETGT (Set Greater Than)" in topic 4.4.85 

          "SETLL (Set Lower Limit)" in topic 4.4.86 

Ted Barry wrote:
> 
> I'm not getting a hit (%found) on the main read (SB220AP), but all other
> related records are reporting (exsr wrtmsg) fine.  All records are being
> deleted, any clues?
> 
> 0101.00 c     LocationId    chain     SB510AF                            40
> 0102.00 c                   dow       not *in40
> 0103.00 c                   delete    SB510AP                              99
> 0104.00 c                   if        %found
> 0105.00 c                   eval      FileName =    'SB510AP'
> 0106.00 c                   exsr      wrtmsg
> 0107.00 c                   endif
> 0108.00 c     LocationId    reade     SB510AF                                
>40
> 0109.00 c                   enddo
> 0110.00
> 0111.00 c                   delete    SB220AP                              99
> 0112.00 c                   if        %found
> 0113.00 c                   eval      FileName =    'SB220AP'
> 0114.00 c                   exsr      wrtmsg
> 0115.00 c                   endif
> 0116.00 c                   endif
> 0117.00
> 0118.00 c                   read      SB220AF                                
>LR
> 0119.00 c                   enddo
> 
> Thanks,
>   Ted
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to
RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to
RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---