Subject RE: [firebird-support] something like delphi's 'isempty' ref/eDN6052838979
Author Dennis
Thank you Stefan!



_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Stefan Heymann
Sent: Monday, October 16, 2006 11:05 AM
To: Dennis
Subject: Re: [firebird-support] something like delphi's 'isempty'
ref/eDN6052838979



Hi Dennis,

try

SELECT FIRST 1 <blablabla>

e.g.

SELECT FIRST 1 from reg_header where customer_code='23232323'

This will return either exactly one record or no records at all.

Best Regards

Stefan

> I want to ask the base with a query and to return me if there is a least
on
> record with specific criteria.

--
Stefan Heymann
www.destructor.de/firebird





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