Hi! In an IF condition 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


---------------------------------

LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y móviles desde 1 céntimo por minuto.
http://es.voice.yahoo.com

[Non-text portions of this message have been removed]