Re: Chainfail equivalent in SQL

["Aaron Bartell" <aaronbartell@xxxxxxxxx>]

<sarcasm-combater>
Or maybe do the following:

D SQLFound          c                  const(2000)
 /free

  if SQLFound;
    // do something REALLY exciting
  endif;

 /end-free
</sarcasm-combater>

<grin>

Aaron Bartell
http://mowyourlawn.com


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

> 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.