Re: Select View Problems

["Hood Louise (app1lxh)" <app1lxh@UPS.COM>]

Marybeth,

You have a branch off to sub-routine show-count, but it is not clear what
that does.  Do you increment your counter there?  It is also not clear why
there is an add to #count_rows outside the select statement.  If you want to
count the items selected, it should be inside.  Also, why use 2 moves on the
same column item (&child).  Have you tried putting in some DISPLAY
statements instead to reveal what the variables contain at each step being
executed?

Louise

-----Original Message-----
From: Noonan, Marybeth [mailto:MNoonan@MFS.COM]
Sent: Tuesday, February 20, 2001 1:58 PM
To: SQR-USERS@list.iex.net
Subject: Select View Problems


Hello,
Environment:Oracle 8.05.00, Ptools 7.58 Apps 7.52 SQR 4.2.3
I have a view that retrieves 160 rows when I use SQLPLUS, however my SQR
select stmt only retrieves 143 rows.  Does anyone know why/how this would
happen.  Here's the code
begin-SELECT  ON-ERROR=SQL-Error
!parent is the manager and child is the DEPTID.
parent
child
descr
  SHOW 'BFORE PARENT '  $Parent ' CHILD ' $Child
     move &Parent to $Parent
     move &Child to $Child
     move &Child to $DEPTID_In
    ! do Get-DEPTID-Descr
  #IFDEF DebugD
    show '********** DATA **********:Get-Responsibility'
    show '$Parent = ' $Parent
    show '$Child = ' $Child
  #ENDIF
    do show-count
   ! do Get-Journal-Detail
FROM MFS_RCS_RESP_VW
!      WHERE PARENT <> 'TOP'
  ORDER BY  1,2

end-SELECT
 Add 1 to  #count_rows


MaryBeth  Noonan
MFS Financial Systems
Ext.  57467
mnoonan@mfs.com