Re: SQR Not finding Rows

[Brian Nice <bnice@CCCI.ORG>]

Did you need to issue a commit some place? This may not be the case, but one thing that has driven me nuts is when I do an insert into
a table in SQLTalk and do not issue a commit and then run the SQR. The SQR doesn't pick
up any of the inserts that happened in SQLTalk because I didn't commit.


/********************
* Brian Nice
* Senior Programmer/Analyst
* Campus Crusade for Christ
* bnice@ccci.org
*********************************/

>>> Mark Kraft <kraftm@GUNET.GEORGETOWN.EDU> 01/06 3:24 PM >>>
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