IF condition

Article View: borland.public.interbase.sql

Article #981

Back to borland.public.interbase.sql Previous Next

#981

From: aleplgr
Date: Wed, 04 Apr 2007 11:00

19 lines
1220 bytes

Hi! In an IF condition in a store procedure is it possible to use a SELECT? Like this one:
 
 
IF (SELECT COUNT(*) FROM TEMP WHERE (FLAG = 1) > 0) THEN
BEGIN
...
END
 
I did it this other way:
 
SELECT COUNT(*) FROM TEMP WHERE FLAG = 1 INTO :MAS30;
IF MAS30>0 THEN
BEGIN
END
 
But just to know..
 
In InterBase 7.5 I'm getting an error if I use the SELECT in the condition

Technical Details

Message-ID: <4613772b$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news4.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,ba6f6a971f66229,start
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "aleplgr" <aleplgr@yahoo.es>
Sender: "aleplgr" <aleplgr@yahoo.es>
Reply-To: "aleplgr" <aleplgr@yahoo.es>
Subject: IF condition
Newsgroups: borland.public.interbase.sql
X-User-Info: 80.58.205.38     
X-Forwarded-For: 80.25.195.180, 192.168.1.55
NNTP-Posting-Host: 207.105.83.66
Message-ID: <4613772b$1@newsgroups.borland.com>
Date: 4 Apr 2007 03:00:11 -0800
X-Trace: newsgroups.borland.com 1175680811 207.105.83.66 (4 Apr 2007 03:00:11 -0800)
Lines: 20
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news4.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail