Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Single line IF in SQL/PSM
Fri, Feb 19 2010 10:45 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Any chance of this eg

IF (ROWCOUNT(InfoCursor) > 0) THEN SET ZapWanted = TRUE;

rather than

IF (ROWCOUNT(InfoCursor) > 0) THEN
 SET ZapWanted = TRUE;
END IF;

I know its a matter of familiarity but I get caught out every other time at least.

Roy Lambert
Sat, Feb 20 2010 1:31 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< Any chance of this eg

IF (ROWCOUNT(InfoCursor) > 0) THEN SET ZapWanted = TRUE;

rather than >>

I'll have to check it further, of course, but I don't see why that can't be
done.

For now, you can do this also:

  IF TRUE THEN SET ZapWanted = TRUE; END IF;

It's a bit weird-looking, though. Smiley

--
Tim Young
Elevate Software
www.elevatesoft.com

Sun, Feb 21 2010 5:15 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim

> IF (ROWCOUNT(InfoCursor) > 0) THEN SET ZapWanted = TRUE;
>
> rather than >>
>
>I'll have to check it further, of course, but I don't see why that can't be
>done.
>
>For now, you can do this also:
>
> IF TRUE THEN SET ZapWanted = TRUE; END IF;
>
>It's a bit weird-looking, though. Smiley

Very weird. How does ElevateDB know where the first TRUE comes from Smiley

Roy Lambert
Mon, Feb 22 2010 6:04 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< Very weird. How does ElevateDB know where the first TRUE comes from Smiley
>>

Okay, that's it - now I'm going to PhotoShop your EDB t-shirt picture before
it goes up on the new web site.   Maybe I'll add some horns.... Smiley

--
Tim Young
Elevate Software
www.elevatesoft.com

Mon, Feb 22 2010 9:03 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim

>Okay, that's it - now I'm going to PhotoShop your EDB t-shirt picture before
>it goes up on the new web site. Maybe I'll add some horns.... Smiley

any change can only be for the better!

Roy Lambert
Image