Subject | RE: [firebird-support] something like delphi's 'isempty' ref/eDN6052838979 |
---|---|
Author | Dennis |
Post date | 2006-10-16T09:51:37Z |
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
Stefan Heymann
www.destructor.de/firebird
[Non-text portions of this message have been removed]
_____
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 leaston
> record with specific criteria.--
Stefan Heymann
www.destructor.de/firebird
[Non-text portions of this message have been removed]