Try

if exists(select 1 from testfile where testfield='xxxxx') then
...


Juan Jose

--- In firebird-support@yahoogroups.com, "Michael L. Horne"
<guardian@p...> wrote:

> Hello,
>
> I need to check to see if a record exists from inside a
> stored procedure. What is the best code to use?
>
> The methods I know of are:
>
> 1.
> NO_RECORD_EXISTS = 'FALSE';
> select count(*) from testfile where testfield='xxxxx'

into :numrecords;

> if (numrecords = 0) then NO_RECORD_EXISTS = 'TRUE';
>
> 2.
> NO_RECORD_EXISTS = 'FALSE';
> for select testfield from testfile where testfield='xxxxx'

into :testfield

> do begin
> NO_RECORD_EXISTS = 'TRUE';
> end
>
> 3. /* this one doesn't seem to work correctly and I am not sure

why */

> NO_RECORD_EXISTS = 'FALSE';
> select first 1 testfield from testfile where testfield='xxxxx' into
> :testfield;
> if (testfield = null) then NO_RECORD_EXISTS = 'TRUE';
>
> -------
> But these all seem like a difficult set of things to do to find

out if a

> record exists, so is there a better way and what is it?
>
> Thanks
> Michael L. Horne