The way to do it is to check the IsEmpty property.
Don't do RecordCount or rely on some arbitrary data value.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "pepmallorca" <pepmallorca@...>
To: <IBObjects@yahoogroups.com>
Sent: Saturday, March 09, 2002 3:49 AM
Subject: [IBO] Re: null result from a query


> --- In IBObjects@y..., Duilio Foschi <dedalus@y...> wrote:
> > how do I detect that a query - done with TIBOQuery - gave null
> result ?
> >
>
> I had read your question. I have not prove it now.
>
> But you can test with one of the nexts lines:
>
> IBOQuery.open;
> IBOQuery.first (if you need it)
>
> and then:
>
> IBOQuery.RecordCount
> IBOQuery.RowsSelected
> IBOQuery.Rownum
>
> or IBOQuery.FieldByname('ONEFIELD').AsString='' for example.
>
> You will say if one of this lines, is good for you.
>
> If it doesn't works, you can ask another time about it.