Re: Chainfail equivalent in SQL

Michael Ryan wrote:

Of course, "No I found it, Yes it's not there" is pretty clear.

On Wed, Apr 16, 2008 at 10:10 AM, David Gibbs <david@xxxxxxxxxxxx>

wrote:

Haas, Matt (CL Tech Sv) wrote:
> SQL State 02000 is a record not found.

<sarcasm> Oh that's intuitive </sarcasm>

<still in sarcasm mode>

Hmm ... let's see, what's easier to understand?

if SQLSTATE = 2000;
// handle missing record
endif;

or

if not %found(filename);
// handle missing record
endif;

</still in sarcasm mode>

david

--
IBM System i - For when you can't afford to be out of business

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.