Re: Select View Problems

[BOB LANG <herr_langer2@HOTMAIL.COM>]

You would need to send the SQL for the view in order for a full analysis to
occur.


>From: "Noonan, Marybeth" <MNoonan@MFS.COM>
>Reply-To: sqr-users@list.iex.net
>To: SQR-USERS@list.iex.net
>Subject: Select View Problems
>Date: Tue, 20 Feb 2001 13:57:42 -0500
>
>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

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com