Re: SQR Not finding Rows

[Tony DeLia <tdelia@EROLS.COM>]

Hi Mark,
   I like interesting problems... Can you forward the SQR begin-select
statement as well as the SQL*Plus version... Without actually seeing the
two I can only guess a bind variable (if there's any used at all) isn't
set to what you think it is... A mispelled bind variable could wreak
havoc... Just a thought...
                                      -Tony DeLia

Mark Kraft wrote:
>
> Ok, I have a rather interesting problem,
> I have an SQR that has worked in the past, but all of a sudden, it is not
> retrieving any rows from the database.  I know this sounds like an easy
> question, but here is the kicker.  I Cut & Paste the SQL from the SQR into
> SQL*Plus in the same database instance, and the SQL brings back the
> correct rows.  I have set a flag in the SQR to see if any rows are being
> fetched and the flag shows that there are no rows fetched.  Does
> Anyone have any ideas why this could be happening.  Thanks ahead of
> time.
>
> Mark Kraft
> mkraft@gunet.georgetown.edu

--
Tony DeLia
AnswerThink Consulting Group
PeopleSoft Solutions Practice - Delphi Partners
tdelia@erols.com