At 10:56 AM 14-08-01 -0600, you wrote:

>Ok, makes sense. So If you are just returning one row, no suspend needed,
>the EXIT would suffice in my case..
>
>Im still not clear about the null thing.. In a stored proc, I thought the
>only way to know if a select statement didnt find any result was to look at
>a key value and see if its NULL. If so, you would know if a row was
>returned. Not so? If not, how do you know (using raw sql) if no row was
>returned??

Definitely the last question before sleep! <g>

IF (EXISTS(SELECT....))
or

IF (NOT(EXISTS(SELECT...)))

but only in procedure language, of course.

In a dataset, test the IsEmpty property.

bye

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________