Ok, thanks! I sure appreciate your help.
Sleep tight Helen.

Gordon Hamm
Voice Data Systems Inc.
435-635-7464

----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, August 14, 2001 11:07 AM
Subject: Re: [IBO] Wrong record..


> 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
> _______________________________________________________
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>